Learn Excel Online with Excel Master

Do you want to learn Advanced Excel Courses from scratch or improve your existing skills? Do you want to become more productive and efficient with Excel? Do you want to impress your boss, colleagues, or clients with your Excel knowledge and abilities?

If you answered yes to any of these questions, then you have come to the right place. Excel Master is the ultimate online destination for learning Excel. Whether you are a beginner, intermediate, or advanced user, we have something for you.

Excel Master offers 40 chapters of comprehensive and practical Excel courses that cover everything you need to know about Excel. You will learn how to:

Enter, edit, format, and manage data in Excel
Use formulas and functions to perform calculations and analysis
Create and customize charts, graphs, and dashboards
Work with tables, ranges, and named ranges
Use data validation, sorting, filtering, and conditional formatting
Master lookup and reference formulas, such as VLOOKUP, HLOOKUP, INDEX, and MATCH
Use logical formulas, such as IF, AND, OR, and NOT
Use text formulas, such as LEFT, RIGHT, MID, CONCATENATE, and TEXT
Use date and time formulas, such as TODAY, NOW, DATE, and TIME
Use statistical formulas, such as AVERAGE, MEDIAN, MODE, and STDEV
Import data from the web and other sources
Publish and share your Excel spreadsheets online
And much more!

Module 1: Introduction to Excel

1.1 Overview of Excel

Spreadsheet basics
Excel interface and ribbon
Versions of Excel and their differences

1.2 Navigating Excel

Cell addressing
Rows, columns, and sheets
Using zoom and pan features
Customizing the Quick Access Toolbar

1.3 Data Entry and Formatting

Entering data into cells
Basic formatting options (font, color, borders)
Cell styles and themes

1.4 Cell Referencing

Relative, absolute, and mixed references
Understanding the importance of referencing in formulas
Using named ranges

Module 2: Basic Formulas and Functions

2.1 Introduction to Formulas

Creating simple arithmetic formulas
Order of operations
Formula auditing tools

2.2 Common Functions

SUM, AVERAGE, MAX, MIN
COUNT, COUNTA, COUNTIF
IF statements and logical functions
Nesting functions

2.3 Using AutoFill and Flash Fill

Time-saving techniques for filling data series
Pattern recognition with Flash Fill
Custom AutoFill lists

Module 3: Data Management and Analysis

3.1 Sorting and Filtering Data

Sorting data by single and multiple criteria
Applying basic and advanced filters
Custom sorting orders

3.2 Data Validation

Setting up dropdown lists
Ensuring data accuracy and consistency
Advanced data validation rules

3.3 Data Tables and What-If Analysis

Creating one-variable and two-variable data tables
Goal Seek and Solver for scenario analysis
Data validation with tables

Module 4: Advanced Formulas and Functions

4.1 Lookup and Reference Functions

VLOOKUP, HLOOKUP, INDEX, MATCH
Using named ranges for better formula readability
Dynamic named ranges

4.2 Array Formulas

Understanding array concepts
Array formulas for advanced calculations
Frequency and array manipulation functions

4.3 Advanced Logical Functions

Nested IF statements
Using AND, OR, NOT functions effectively
SWITCH and CHOOSE functions

Module 5: PivotTables and PivotCharts

5.1 Introduction to PivotTables

Creating PivotTables from data
Modifying PivotTable layout and design
Calculated fields and items in PivotTables

5.2 PivotTable Calculations

Adding calculated fields and items
Working with slicers for interactive analysis
Grouping and ungrouping data in PivotTables

5.3 PivotCharts

Creating dynamic charts linked to PivotTables
Customizing PivotCharts for better visualization
Interactive dashboards with PivotCharts

Module 6: Data Visualization and Conditional Formatting

6.1 Conditional Formatting

Applying conditional formatting rules
Icon sets, data bars, and color scales
Advanced conditional formatting with formulas

6.2 Sparklines

Creating miniature charts within cells
Configuring and customizing sparklines
Using sparklines for trend analysis

Module 7: Data Analysis with Power Query

7.1 Introduction to Power Query

Importing and transforming data
Managing data connections and queries
Advanced data transformations with M language

7.2 Advanced Data Transformations

Merging queries and appending tables
Unpivoting and reshaping data
Using custom functions in Power Query

7.3 Query Parameters and Functions

Using parameters for dynamic data loading
Creating custom functions in Power Query
Advanced query folding techniques

Module 9: Collaborative Work and Data Security

9.1 Sharing and Protecting Workbooks

Sharing workbooks and tracking changes
Protecting worksheets and workbooks with passwords
Workbook encryption and digital signatures

9.2 Excel Online and Collaborative Editing

Working with Excel Online
Real-time collaboration and co-authoring features
Reviewing and commenting on shared workbooks

Module 10: Advanced Data Analysis Tools

10.1 Goal Seek and Scenario Manager

Using Goal Seek for reverse calculations
Managing multiple scenarios with Scenario Manager
Incorporating scenarios into decision-making

10.2 Solver Add-In

Introduction to Solver for optimization problems
Setting up and solving complex optimization models
Sensitivity analysis with Solver

10.3 Forecasting Trends with Regression Analysis

Understanding regression analysis
Using Excel’s regression tool for forecasting
Time-series analysis and forecasting techniques

Module 11: Excel Dashboards

11.1 Design Principles for Dashboards

Choosing the right charts and visuals
Creating a visually appealing and effective dashboard layout
Dashboard interactivity and user experience

11.2 Data Connections in Dashboards

Linking dashboard elements to external data sources
Dynamic data updates in dashboards
Power Query for dashboard data preparation

11.3 Interactivity in Dashboards

Adding interactive features using form controls
Creating dropdowns and slicers for user interaction

Module 12: Excel Best Practices and Tips

12.1 Efficiency Tips

Keyboard shortcuts for common tasks
Speeding up Excel performance
Advanced formula optimization techniques

12.2 Workbook Organization

Proper file naming and folder structure
Documenting and commenting formulas and code
Version control and backup strategies

12.3 Troubleshooting and Error Handling

Understanding common Excel errors
Using auditing tools and error-checking features
Troubleshooting techniques for large datasets

Module 13: Advanced Charting Techniques

13.1 Dynamic Charts

Creating charts that automatically update with new data
Using dynamic named ranges for charts

13.2 Advanced Chart Types

Radar charts, bubble charts, and surface charts
Waterfall charts for financial analysis
Gantt charts for project management

13.3 Chart Customization and Formatting

Customizing chart elements
Using chart templates for consistent formatting

Module 14: Advanced Pivot Table Techniques

14.1 Data Model and Relationships

Introduction to the Data Model
Creating relationships between tables
Utilizing external data sources in the Data Model

14.2 DAX (Data Analysis Expression)

Introduction to DAX formulas
Calculated columns and measures
Time intelligence functions in DAX

14.3 Power Pivot and Power BI Integration

- Importing Excel data into Power Pivot
- Building reports and dashboards in Power BI
- Integrating Power BI visualizations into Excel

Module 15: Advanced Data Modeling

15.1 Database Functions

DGET, DCOUNT, DSUM, and other database functions
Criteria usage in database functions

15.2 Consolidating Data from Multiple Sheets

Using 3D references for consolidation
Consolidating data with PivotTables and Power Query

15.3 Advanced Data Validation

Using custom formulas for data validation
Cascading dropdowns for dependent data validation

Module 16: Advanced Data Analysis Tools

16.1 Advanced Solver Modeling

Nonlinear optimization with Solver
Evolutionary solving methods

16.2 Advanced What-If Analysis

Data tables with two-variable and complex scenarios
Advanced Goal Seek applications

16.3 Monte Carlo Simulation in Excel

Introduction to Monte Carlo simulation
Using add-ins for simulation modeling

Module 17: Advanced Power Query Techniques

17.1 Advanced Query Transformations

M code customization
Advanced data cleaning and transformation techniques

17.2 Web Scraping with Power Query

Extracting data from websites
Handling dynamic web content

17.3 API Integration with Power Query

Connecting to APIs for data retrieval
Parsing JSON data in Power Query

Module 18: Excel for Big Data Analysis

18.1 Introduction to Power BI Desktop

Overview of Power BI features
Connecting Excel to Power BI

18.2 Power Query in Power BI

Data shaping and transformation in Power BI
Loading data models in Power BI

18.3 Analyzing Big Data with Excel

Importing data from external databases
Using Power Pivot for large datasets

Module 19: Financial Modeling in Excel

19.1 Advanced Financial Functions

NPV, IRR, XNPV, XIRR
Financial modeling best practices

19.2 Scenario Analysis in Finance

Building financial models for scenario analysis
Stress testing and sensitivity analysis

19.3 Valuation Models

Discounted Cash Flow (DCF) analysis
Comparable Company Analysis (CCA) and precedent transactions

Module 20: Excel Automation with Power Automate

20.1 Introduction to Power Automate

Creating flows for Excel automation
Integrating Excel with other apps and services

20.2 Automating Workflows with Excel

Triggering workflows based on Excel events
Advanced automation scenarios with Power Automate

Module 21: Excel and Machine Learning

21.1 Introduction to Machine Learning in Excel

Building predictive models with Excel
Using Azure Machine Learning with Excel

21.2 Regression Analysis with Machine Learning

Linear and logistic regression in Excel
Evaluating machine learning models in Excel

Module 22: Excel for Project Management

22.1 Gantt Charts and Project Planning

Creating Gantt charts in Excel
Tracking project progress with Excel

22.2 Resource Management in Excel

Allocating resources in project management
Excel templates for project tracking

Module 23: Advanced Excel Functions

23.1 TEXT Functions

CONCATENATE, TEXT, MID, LEFT, RIGHT
Advanced text manipulation in Excel

23.2 Financial Functions

PMT, FV, PV, RATE
Advanced financial calculations in Excel

23.3 Information and Lookup Functions

CELL, INFO, INDEX-MATCH, OFFSET
Advanced information retrieval in Excel

Module 24: Excel and SQL Integration

24.1 Connecting Excel to SQL Server

Importing data from SQL databases
Writing SQL queries within Excel

24.2 SQL Pivot and Unpivot Operations

Performing pivot and unpivot operations in SQL
Integrating SQL results into Excel

MS Excel VBA