Business

Data Analytics Guide with Microsoft Excel: Step by Step For From Scratch

Instructor

KuKu

Reviews 5.00 (1 Reviews)

Course Overview

To Access this Content and other Bonuses Signup or Login to Membership

What You'll Learn?

  • Basics of data analytics and its real-world importance
  • Navigating Microsoft Excel and its key functionalities
  • Data validation and conditional formatting in Excel
  • Sorting, filtering, and removing duplicate data
  • Handling null, blank, and white space in datasets
  • Applying text, logical, date, and numeric functions in Excel
  • Introduction to Power Query Editor for advanced data operations
  • Cleaning and transforming data using Power Query Editor tools
  • Creating custom and conditional columns
  • Merging queries and data modeling techniques
  • Establishing data relationships and hierarchy structures
  • Building pivot tables and charts for data presentation
  • Complete beginners interested in data analytics
  • Professionals wanting to add data skills to their resume
  • Students preparing for data-related projects or roles
  • Small business owners aiming to understand their data better
  • Individuals seeking a career change into data analysis
  • Anyone wanting to enhance their Excel skills for data-driven tasks
  • Basic understanding of computers and file handling
  • Microsoft Excel (365 or 2019 recommended)
  • No prior experience in data analytics needed
  • 6 hours on-demand video
  • 1 article
  • 1 downloadable resource
  • Access on mobile and TV
  • Full lifetime access
  • Certificate of completion

Course Content

Membership
  • Duration 06:00:00
  • Lessons 11
  • Skill Beginner
  • Last Update January 14, 2025