Excel

This course covers essential to advanced Excel skills, enabling you to harness its full potential for data-driven decision-making. Participants will learn to efficiently organize and clean data, use formulas and functions for complex calculations, and create dynamic charts and graphs. Advanced topics include PivotTables, PivotCharts, and Excel's data analysis tools like Solver and Data Analysis Toolpak. Additionally, the course delves into Power Query for data transformation, Power Pivot for complex data modeling, Macros and VBA for automation, advanced conditional formatting, What-If Analysis, and dynamic array functions.