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

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

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

Show More

What Will You 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

Course Content

Introduction to Data Analytics

Microsoft Excel Introduction

Data Validation & Conditional Formatting

Sorting, Filter and Duplicate Data

Null, Blank and White Space

Learning Functions in Excel

Basics of Power Query Editor

Cleaning and Transforming Data

Custom and Conditional Column

Data Modelling and Merging

Data Modelling Relationship

Pivot Table and Charts

Earn a certificate

Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.

selected template