Below are the lesson schedules for this Microsoft Excel training class.
Click on a specific lesson to join the class.
LESSON 1
Intro to Excel – Quick Tour of Excel
Skills you will learn in this section:
- Excel Workbook, Worksheet, Cell Structure
- Quick Tour of Excel – Ribbon & Quick Access Toolbar
- Quiz: Excel Fundamentals 5 questions
LESSON 2
Data Input & Hidden Features to Save Time
Skills you will learn in this section:
- Data Entry and Editing Excel Data
- Use Excel AutoFill To Do Your Work
- Inputting & Editing Comments & Notes in Excel
- Excel Data Validation to Reduce Time Checking Data
- Quiz: Data Input in Excel 5 questions
LESSON 3
Excel WorkSheet – Navigation, Copying and Protecting Worksheet
Skills you will learn in this section:
- Useful Excel Shortcuts for Navigation (Become Pro)
- Hide & Unhide, Insert, Adjust Columns & Rows in Excel
- Protecting Excel Worksheets & Specific Ranges
- Quiz: Worksheet Navigation 5 questions
LESSON 4
Excel Formula
Skills you will learn in this section:
- Overview – Excel Formulas & What to be Aware of
- How Excel Calculates – Order of Precedence
- Simple but Useful Excel Formulas
- Absolute and Relative Cell Referencing in Excel
- Improve Clarity with Range Names
- Referencing other Workbooks or Worksheets
- Circular References & How to Locate Them
- Quiz: Excel Formulas 5 questions
LESSON 5
Excel Functions
Skills you will learn in this section:
- Overview & Finding Excel Functions from Insert Function
- COUNT, COUNTA, COUNTBLANK
- COUNT based on a Condition (COUNTIFS)
- SUM & AVERAGE Functions in Excel
- SUM by Criteria (SUMIFS, AVERAGEIFS)
- MAX & MIN (MAXIFS & MINIFS)
- Rounding Values (ROUND, ROUNDUP & ROUNDOWN)
- Essential Excel Date Functions
- Time Calculations in Excel – Total Time Worked
- Handling Excel Formula Errors
- IF (Then, Else) Excel Function – Conditional Formulas
- VLOOKUP Function – Lookup Values from Another Place
- Summary: Important Excel Functions (text file)
LESSON 6
Excel Data Management
Skills you will learn in this section:
- Sort Data (Organize & Create Order) in Excel
- Unsort Data to Revert to Original Order
- Add Subtotals to Sorted Data
- Filter Data to Extract What you Need
- Delete Blank or Empty Rows in Excel
- Fill Empty Cells in One Go (Become Pro)
- Remove Duplicates to Get a Unique List in Excel
- Summary: Tools for Organizing, Cleaning & Managing Data in Excel (text file)
LESSON 7
Formatting in Excel – Conditional and Number Formatting
Skills you will learn in this section:
- Excel Number Formatting Options (& Special Formatting)
- Excel Conditional Formatting (Top Bottom Analysis & More)
- Quiz: Excel Formatting 4 questions
- Challenge: Format Excel Report
LESSON 8
Printing Excel Files & Saving as PDF
Skills you will learn in this section:
- Useful Printing Options in Excel
- Saving Excel Files PDF & Printing Many Sheets
LESSON 9
Workbook Design Principle
Skills you will learn in this section:
- Adding Hyperlinks (Plus a Smart Workaround) in Excel
- Define Cell Styles & Set Defaults (e.g. for Excel Tables)
- Use Your Own Excel Templates
- Quiz: Workbook Design 5 questions
LESSON 10
Working with Excel Charts
Skills you will learn in this section:
- Overview – Create Helpful Excel Charts
- Combination Charts (Plus a Hidden Excel Feature)
- Pareto & Histogram Excel Charts
- Treemap Chart in Excel
- Sunburst, Pie & Doughnut Excel Charts
- Quiz: Excel Charts 6 questions
LESSON 11
Excel Pivot Tables
Skills you will learn in this section:
- Inserting a Pivot Table in Excel
- Sorting Pivot Data & Analyzing Multiple Items
- Creating Pivot Charts
- Excel Data Analysis with Pivot Tables
- Summary: Important Pivot Table Features (text file)
LESSON 12
Power Query in Excel
Skills you will learn in this section:
- Import Text File with Power Query
- Merge data in Power Query (for Pivot Table)
- Solution: Data Cleanup with Power Query
Conclusion
Conclusion and Training Certificate – Click Here to View Lesson Conclusion and Download Training Certificate.