This full beginner course by Luke Barousse teaches how to use Microsoft Excel for data analytics and professional data analysis workflows. It is designed for beginners who want to build strong foundational skills in spreadsheets, formulas, and data visualization for real-world analytics work.

The course starts with an introduction to Excel, explaining workbooks, worksheets, and the basic interface. Learners are then guided through essential formulas and functions, including logical, statistical, math, text, and date functions. These fundamentals are crucial for cleaning, transforming, and analyzing data efficiently.

A major part of the course focuses on data visualization using charts and graphs. Students learn how to create basic and advanced charts, use sparklines, and build visual reports that communicate insights clearly. The training also includes practical spreadsheet skills such as formatting, tables, and collaboration features.

Advanced sections cover PivotTables and PivotCharts for summarizing large datasets, as well as Power Query for data transformation and cleaning. The course also introduces Power Pivot and DAX for more advanced data modeling and analysis techniques.

Two hands-on projects help learners apply their skills by building a salary dashboard and performing full salary data analysis using Excel tools.

By the end of the course, learners gain complete beginner-to-intermediate Excel analytics skills needed for data analysis, reporting, and business decision-making.