Data Analytics Using Excel

Dive into a comprehensive 83-minute tutorial on data analytics using Excel. Learn the three main phases of data analytics projects: data cleaning, analysis, and visualization. Master essential Excel functions, including lookup functions, conditional formatting, and data validation. Explore the power of pivot tables for data analysis and discover effective techniques for data visualization in Excel. Gain practical skills to kickstart your data analytics journey and enhance your career prospects in this in-demand field.

Introduction.
Agenda.
Phases of Data Analytics Project.
Data Cleaning.
Functions.
Lookup Functions.
Conditional Formatting.
Data Validation.
Pivot Tables.
Data Visualisation using Excel.
Summary.