You learn how to use Excel for data analysis from the basics to advanced techniques. You start with the role of analytics, the analytics lifecycle, and how Excel fits into data work. You then learn data handling, formulas, cell referencing, Boolean logic, text functions, date and time functions, conditional functions, lookup functions, and aggregation. You also learn data cleaning, data validation, conditional formatting, PivotTables, charts, and exploratory data analysis. The course ends with two guided projects that help you apply everything you learned.