Microsoft Excel - Excel from Beginner to Advanced

About Course

Master Microsoft Excel: Beginner to Expert All-in-One Course

Unlock the full potential of Microsoft Excel in this comprehensive course designed to take you from beginner to advanced—plus expert-level tools like Macros and VBA. Perfect for any version from Microsoft Excel 2007 to 2024, this course bundles four intensive classes into one powerful package.

What You’ll Learn
Whether you’re just starting or looking to automate your workflow, we’ve got you covered:

Building organized and effective spreadsheets
Managing and analyzing large data sets with ease
Mastering essential Excel functions like SUM, VLOOKUP, IF, and INDEX/MATCH
- Including new Microsoft 365 Functions like XLOOKUP, SWITCH, TEXTSPLIT and more
Creating dynamic reports with PivotTables
Harnessing PowerPivot for more advanced data modeling
Cleaning and auditing formulas to ensure accuracy
Automating tasks with Macros and VBA

What’s Included?

22+ hours of in-depth video instruction led by a Microsoft Certified Trainer
Downloadable exercise files to follow along and practice
Section quizzes to reinforce learning
An interactive Q&A board for questions and support

Student Success Story

“This course is amazing. Not everyone has the gift of teaching, but Kyle truly makes Excel easy and engaging. I now know Excel better than ever and feel ready to tackle any project!”
“This course made me an Excel pro! I was a total beginner, and now I feel confident tackling any Excel task. Kyle’s course is well-structured and easy to follow—highly recommend!”
“Excel has been a mystery to me until this course! Kyle’s teaching made it simple to understand. If you’re hesitant, don’t be—this is the course to buy!”

Take the next step in mastering Excel. Enroll now and transform from an Excel novice to an Excel expert!

Who this course is for:

This Microsoft Excel courses will take you through 4 levels of Microsoft Excel topics (Beginner, Intermediate, Advanced and Macros/VBA).
If your looking to take your Excel skills from beginner to advanced level and beyond, then this course is for you.

Create and manage organized, professional Microsoft Excel spreadsheets from scratch
Master essential Excel functions like SUM, VLOOKUP, IF, and more
Analyze large Excel data sets with confidence and find key insights
Build dynamic reports using Excel PivotTables and visualizations
Automate repetitive tasks efficiently with Excel Macros and VBA
Design interactive dashboards and reports with Excel PowerPivot
Use advanced Excel functions to tackle real-world business problems
Improve productivity with time-saving Excel shortcuts and best practices
Gain the confidence to solve complex Excel tasks with ease

Course Content

Excel Basics & Interface Navigation
Introduction to the Excel interface, workbook structure, and essential features. Understanding the Excel Ribbon, Quick Access Toolbar, and status bar. Opening, saving, and managing Excel files efficiently. Common keyboard shortcuts to speed up workflow.

Data Entry & Basic Formulas
Entering and formatting text, numbers, and date values. Creating basic formulas and understanding relative vs. absolute references. Order of operations and working with common functions (SUM, MIN, MAX, AVERAGE, COUNT).

Formatting & Customizing Excel Sheets
Modifying cell size, inserting/deleting rows and columns, and renaming sheets. Applying font styles, borders, colors, and conditional formatting. Creating and managing styles for professional formatting.

Charts & Data Visualization
Inserting and customizing Excel charts (column, pie, and more). Formatting charts, modifying chart data, and moving charts between sheets. Working with SmartArt and shapes for enhanced visualization.

Printing & Page Setup
Print preview, adjusting margins, and setting up page layout. Adding headers and footers for professional reports. Printing specific ranges and optimizing print settings.

Sorting, Filtering, & Data Validation
Sorting data with single and multi-level sorts. Filtering data using AutoFilter and removing duplicates. Creating dynamic drop-down lists with Data Validation.

PivotTables & Advanced Data Analysis
Creating and formatting PivotTables for data summarization. Filtering PivotTables with slicers and modifying calculations. Introduction to Power Pivot and Data Model relationships.

Working with Large Datasets
Freezing panes, grouping data, and linking worksheets. Consolidating data from multiple worksheets. Managing large datasets with advanced Excel tools.

Advanced Functions & Formulas
Using logical functions: IF, AND, OR, COUNTIF, SUMIF. Lookup functions: VLOOKUP, HLOOKUP, INDEX, MATCH. Text functions: LEFT, RIGHT, MID, LEN, SEARCH, CONCATENATE. Introduction to new Excel 365 functions: FILTER, SORT, UNIQUE, XLOOKUP, TEXTSPLIT.

Excel Automation with Macros & VBA
Understanding macros and the Developer Tab. Recording and editing macros using VBA. Writing VBA code, working with loops, and automating repetitive tasks. Creating custom buttons and user forms with VBA.

Excel Projects & Real-World Applications
Automating data entry and formatting with VBA. Creating reusable functions and improving user interaction. Importing and exporting data from text files and databases. Final capstone project: Building an automated reporting system.

Certification & Course Completion
Course review and final exercises. Tips for real-world Excel applications in business and finance. Downloadable resources and next steps for Excel mastery.

Microsoft Excel – Excel from Beginner to Advanced

About Course

Who this course is for:

What Will You Learn?

Course Content

Excel Basics & Interface Navigation
Introduction to the Excel interface, workbook structure, and essential features. Understanding the Excel Ribbon, Quick Access Toolbar, and status bar. Opening, saving, and managing Excel files efficiently. Common keyboard shortcuts to speed up workflow.

Data Entry & Basic Formulas
Entering and formatting text, numbers, and date values. Creating basic formulas and understanding relative vs. absolute references. Order of operations and working with common functions (SUM, MIN, MAX, AVERAGE, COUNT).

Formatting & Customizing Excel Sheets
Modifying cell size, inserting/deleting rows and columns, and renaming sheets. Applying font styles, borders, colors, and conditional formatting. Creating and managing styles for professional formatting.

Charts & Data Visualization
Inserting and customizing Excel charts (column, pie, and more). Formatting charts, modifying chart data, and moving charts between sheets. Working with SmartArt and shapes for enhanced visualization.

Printing & Page Setup
Print preview, adjusting margins, and setting up page layout. Adding headers and footers for professional reports. Printing specific ranges and optimizing print settings.

Sorting, Filtering, & Data Validation
Sorting data with single and multi-level sorts. Filtering data using AutoFilter and removing duplicates. Creating dynamic drop-down lists with Data Validation.

PivotTables & Advanced Data Analysis
Creating and formatting PivotTables for data summarization. Filtering PivotTables with slicers and modifying calculations. Introduction to Power Pivot and Data Model relationships.

Working with Large Datasets
Freezing panes, grouping data, and linking worksheets. Consolidating data from multiple worksheets. Managing large datasets with advanced Excel tools.

Advanced Functions & Formulas
Using logical functions: IF, AND, OR, COUNTIF, SUMIF. Lookup functions: VLOOKUP, HLOOKUP, INDEX, MATCH. Text functions: LEFT, RIGHT, MID, LEN, SEARCH, CONCATENATE. Introduction to new Excel 365 functions: FILTER, SORT, UNIQUE, XLOOKUP, TEXTSPLIT.

Excel Automation with Macros & VBA
Understanding macros and the Developer Tab. Recording and editing macros using VBA. Writing VBA code, working with loops, and automating repetitive tasks. Creating custom buttons and user forms with VBA.

Excel Projects & Real-World Applications
Automating data entry and formatting with VBA. Creating reusable functions and improving user interaction. Importing and exporting data from text files and databases. Final capstone project: Building an automated reporting system.

Certification & Course Completion
Course review and final exercises. Tips for real-world Excel applications in business and finance. Downloadable resources and next steps for Excel mastery.

Quick Links

Resources

Important Pages

About Course

Who this course is for:

What Will You Learn?

Course Content

Excel Basics & Interface Navigation Introduction to the Excel interface, workbook structure, and essential features. Understanding the Excel Ribbon, Quick Access Toolbar, and status bar. Opening, saving, and managing Excel files efficiently. Common keyboard shortcuts to speed up workflow.

Data Entry & Basic Formulas Entering and formatting text, numbers, and date values. Creating basic formulas and understanding relative vs. absolute references. Order of operations and working with common functions (SUM, MIN, MAX, AVERAGE, COUNT).

Formatting & Customizing Excel Sheets Modifying cell size, inserting/deleting rows and columns, and renaming sheets. Applying font styles, borders, colors, and conditional formatting. Creating and managing styles for professional formatting.

Charts & Data Visualization Inserting and customizing Excel charts (column, pie, and more). Formatting charts, modifying chart data, and moving charts between sheets. Working with SmartArt and shapes for enhanced visualization.

Printing & Page Setup Print preview, adjusting margins, and setting up page layout. Adding headers and footers for professional reports. Printing specific ranges and optimizing print settings.

Sorting, Filtering, & Data Validation Sorting data with single and multi-level sorts. Filtering data using AutoFilter and removing duplicates. Creating dynamic drop-down lists with Data Validation.

PivotTables & Advanced Data Analysis Creating and formatting PivotTables for data summarization. Filtering PivotTables with slicers and modifying calculations. Introduction to Power Pivot and Data Model relationships.

Working with Large Datasets Freezing panes, grouping data, and linking worksheets. Consolidating data from multiple worksheets. Managing large datasets with advanced Excel tools.

Advanced Functions & Formulas Using logical functions: IF, AND, OR, COUNTIF, SUMIF. Lookup functions: VLOOKUP, HLOOKUP, INDEX, MATCH. Text functions: LEFT, RIGHT, MID, LEN, SEARCH, CONCATENATE. Introduction to new Excel 365 functions: FILTER, SORT, UNIQUE, XLOOKUP, TEXTSPLIT.

Excel Automation with Macros & VBA Understanding macros and the Developer Tab. Recording and editing macros using VBA. Writing VBA code, working with loops, and automating repetitive tasks. Creating custom buttons and user forms with VBA.

Excel Projects & Real-World Applications Automating data entry and formatting with VBA. Creating reusable functions and improving user interaction. Importing and exporting data from text files and databases. Final capstone project: Building an automated reporting system.

Certification & Course Completion Course review and final exercises. Tips for real-world Excel applications in business and finance. Downloadable resources and next steps for Excel mastery.

Quick Links

Resources

Important Pages

Excel Basics & Interface Navigation
Introduction to the Excel interface, workbook structure, and essential features. Understanding the Excel Ribbon, Quick Access Toolbar, and status bar. Opening, saving, and managing Excel files efficiently. Common keyboard shortcuts to speed up workflow.

Data Entry & Basic Formulas
Entering and formatting text, numbers, and date values. Creating basic formulas and understanding relative vs. absolute references. Order of operations and working with common functions (SUM, MIN, MAX, AVERAGE, COUNT).

Formatting & Customizing Excel Sheets
Modifying cell size, inserting/deleting rows and columns, and renaming sheets. Applying font styles, borders, colors, and conditional formatting. Creating and managing styles for professional formatting.

Charts & Data Visualization
Inserting and customizing Excel charts (column, pie, and more). Formatting charts, modifying chart data, and moving charts between sheets. Working with SmartArt and shapes for enhanced visualization.

Printing & Page Setup
Print preview, adjusting margins, and setting up page layout. Adding headers and footers for professional reports. Printing specific ranges and optimizing print settings.

Sorting, Filtering, & Data Validation
Sorting data with single and multi-level sorts. Filtering data using AutoFilter and removing duplicates. Creating dynamic drop-down lists with Data Validation.

PivotTables & Advanced Data Analysis
Creating and formatting PivotTables for data summarization. Filtering PivotTables with slicers and modifying calculations. Introduction to Power Pivot and Data Model relationships.

Working with Large Datasets
Freezing panes, grouping data, and linking worksheets. Consolidating data from multiple worksheets. Managing large datasets with advanced Excel tools.

Advanced Functions & Formulas
Using logical functions: IF, AND, OR, COUNTIF, SUMIF. Lookup functions: VLOOKUP, HLOOKUP, INDEX, MATCH. Text functions: LEFT, RIGHT, MID, LEN, SEARCH, CONCATENATE. Introduction to new Excel 365 functions: FILTER, SORT, UNIQUE, XLOOKUP, TEXTSPLIT.

Excel Automation with Macros & VBA
Understanding macros and the Developer Tab. Recording and editing macros using VBA. Writing VBA code, working with loops, and automating repetitive tasks. Creating custom buttons and user forms with VBA.

Excel Projects & Real-World Applications
Automating data entry and formatting with VBA. Creating reusable functions and improving user interaction. Importing and exporting data from text files and databases. Final capstone project: Building an automated reporting system.

Certification & Course Completion
Course review and final exercises. Tips for real-world Excel applications in business and finance. Downloadable resources and next steps for Excel mastery.