Welcome To Your Excel Course!
- Quick Tips Before Starting
Microsoft Excel 101 - Course Exercise Files
- Course Files Intro - Microsoft Excel
Setting Up Your System - Microsoft Excel
- Setting Up Your System
Introduction: Microsoft Excel for Beginners
- Getting To Know Excel: Introduction
- Introduction To The Excel Interface
- Customizing The Quick Access Toolbar
- Using Tab & Enter to Navigate the Spreadsheet
- Saving An Excel Document
- The Worksheet
- Navigation
- Formatting Excel
- Basic Math
- Getting To Know Excel: Quiz
Modifying an Excel Worksheet
- Modifying an Excel Worksheet: Introduction
- Inserting and Deleting Rows and Columns
- Changing the Width and Height of Cells
- Hiding and Unhiding Excel Rows and Columns
- Renaming an Excel Worksheet
- Deleting an Excel Worksheet
- Modifying an Excel Worksheet: Quiz
Practice Test 1: Microsoft Excel Beginner Level
- Microsoft Excel Beginner Level Test
Formatting Data in an Excel Worksheet
- Formatting Data in an Excel Worksheet: Introduction
- Working With the Font Commands
- Adding Borders to Cells
- Changing the Background Colour of a Cell
- Formatting Data in Currency
- Formatting Data in Percentages
- Using Excel Format Painter
- Merge & Centre Cells
- Formatting Data in a Excel Worksheet: Quiz
Excel Templates
- Intro to Excel Templates
- Using an Existing Excel Template
- Creating a Custom Template
- Excel Templates
Printing an Excel Worksheet
- Printing an Excel Worksheet: Introduction
- Change the Margins, Scaling, and Orientation
- Viewing your Document in Print Preview
- Page Layout View
- Adding a Header and Footer Content
- Printing a Specific Range of Cells
- Printing an Excel Worksheet
Microsoft Excel Charts
- Microsoft Excel Chart: Introduction
- Building A Column Chart
- Building A Bar Chart
- Building A Pie Chart
- Building A Line Chart
- Excel Charts: Quiz
Beginner to Intermediate Formula Knowledge
- Beginner to Intermediate Formula Knowledge: Introduction
- Order of Operations in Excel
- Formula Anatomy
- Cell Referencing
- MIN, MEDIAN, MAX, AVERAGE, & COUNT Formulas
- SUM, ROUND, & SUBTOTAL - Math Formulas
- MODE, COUNT, COUNTA - Primary Statistics
- Using IF & AND - Primary Functions
- TODAY, YEAR, MONTH, DAY and DATE Functions.
- Learning About Time in Excel
- Beginner to Intermediate Formula Knowledge: Quiz
Practice Test 2: Microsoft Excel Intermediate Level
- Microsoft Excel Intermediate Level Test
Congratulations! You've Mastered Beginner to Intermediate Microsoft Excel.
- Congratulations! You've Mastered Beginner to Intermediate Microsoft Excel.
Advanced Formula Knowledge - Importing Data, VLOOKUP & More!
- Advanced Formula Knowledge: Introduction
- Formula Auditing - Trace precedence and dependence
- Conditional Math - Use SUMIF, COUNTIF and SUMPRODUCT.
- How to Import Data in Excel
- VLOOKUP With Approximate Match
- VLOOKUP With Exact Match
- Advanced Formula Knowledge: Quiz
CONCAT & CONCATENATE Functions
- CONCATENATE Function
- Using the CONCATENATE Function
- Using Logic in your CONCATENATE Functions
ADDRESS & INDIRECT Functions
- ADDRESS Function
- Using the ADDRESS Function to String Data
- Using the ADDRESS Function in a INDIRECT Function
- INDIRECT Function
INDEX & MATCH Functions
- Introduction to Index Function
- INDEX Function Rules
- Using Array in the INDEX Function
- Using the Reference Form & Sum Function in a INDEX Function
- Introduction to MATCH Function
- Match Function
Sorting, Filtering, Tables, Ranges & More!
- Enhancing Data: Introduction
- Sorting
