Advanced Excel

Advanced Formulas and Functions: Delving into complex formulas and functions, including logical functions, lookup functions, text functions, date and time functions, and array formulas.

Data Validation: Learning how to set up data validation rules to ensure data accuracy and consistency within worksheets.

PivotTables and PivotCharts: Understanding how to create PivotTables to summarize and analyze large datasets and visualize data using PivotCharts.

Data Analysis Tools: Exploring Excel’s built-in data analysis tools, such as Goal Seek, Solver, and Scenario Manager for “what-if” analysis.

Power Query: An introduction to Power Query, a powerful tool to import, transform, and clean data from various sources.

Power Pivot: Learning how to use Power Pivot to create data models, perform advanced data analysis, and create relationships between different datasets.

Power View: An introduction to Power View for creating interactive data visualizations and reports.

Data Tables and What-If Analysis: Understanding how to use data tables and scenario manager for running various scenarios and analyzing multiple outcomes.

Advanced Charting: Exploring advanced charting techniques to create dynamic and visually appealing charts and graphs.