- Data Analysis in Excel
- Organizing data for analysis
- Data cleaning and preparation techniques
2. Formulas and Functions
3. Charts and Graphs to present the data.
- Creating charts and graphs to visualize data
- Customizing charts to highlight important information.
- Identifying trends and outliers in data
4. PivotTables and Data Modeling
- Creating and manipulating PivotTables to summarize and analyze data
- Understanding data modelling and its importance in data analysis
- Creating and using data models to analyze large datasets
- Using Excel add-ins to extend functionality
5. Power Query & Power Pivot for advanced data analysis
Power Query: A data transformation and cleaning tool that helps you easily connect to and transform data from various sources.
- Quickly clean and shape data with an intuitive interface
- Combine data from multiple sources, like Excel sheets, PDF, Folders, CSV files, and databases
- Transform data using over 300 built-in functions and formulas
- Automatically refresh data with the click of a button
6. Power Pivot: an advanced data modelling tool that helps you analyze large datasets and create complex relationships between data.
- Quickly analyze large datasets without the need for complicated formulas or macros
- Create and manage relationships between multiple tables with ease
- Create custom calculations and measures with DAX formulas
- Build interactive reports with PivotTables, PivotCharts, and Slicers
- Work with larger datasets without the need for complex formulas or macros
- Create complex relationships between data that can help you gain insights and make better decisions
- Build interactive reports and dashboards that can help you easily communicate your findings to others