Autoplay
Autocomplete
Previous Lesson
Complete and Continue
MS Excel Course - 11 Chapters
Introduction
Tips for success
Best Approach to this module - excel content list
Chapter 1: Introduction to Excel Basics
Objective
Resource: Microsoft Excel Basic Tutorial (Website)
YouTube Tutorial: Excel for Beginners - The Complete Course (by Technology for Teachers and Students)
Exercise: Create a simple budget spreadsheet with income and expenses.
Chapter 2: Formatting and Data Entry
Objective
Resource: Excel Easy - Format Cells (Website)
YouTube Tutorial: Excel Basics - Formatting Cells (by ExcelIsFun)
Exercise: Format a table to display currency and apply conditional formatting.
Chapter 3: Functions and Formulas
Objective
Resource: Exceljet - 350 Excel Functions (Website)
YouTube Tutorial: Beginner's Guide to Excel Functions and Formulas (by Technology for Teachers and Students)
Exercise: Create a budget spreadsheet with formulas for calculating totals and averages.
Chapter 4: Sorting, Filtering, and Tables
Objective
Resource: Excel Easy - Data Analysis (1. Sort 2. Filter 6. Tables) (Website)
YouTube Tutorial: Excel Basics 23: Data Analysis Features: Sort, Filter, Flash Fill to Organize & Clean Data (by ExcelIsFun)
Exercise: Sort and filter a dataset to find specific information.
Chapter 5: Charts and Graphs
Objective
Resource: Coursera - Create Charts and Dashboards Using Microsoft Excel (Website)
YouTube Tutorial: Excel Basics 24: Excel Charts & Graphs to Visualize Quantitative Data. No Chart Junk!!! (by ExcelIsFun)
Exercise: Create a bar chart and a pie chart based on provided data.
Chapter 6: Conditional Formatting and Data Validation
Objective
Resources
YouTube Tutorial: Excel Conditional Formatting in Depth (by Technology for Teachers and Students)
YouTube Tutorial: Advanced Excel - Data Validation and Drop-Down Lists (by Technology for Teachers and Students)
Exercise: Apply conditional formatting rules and create data validation rules in a worksheet.
Chapter 7: PivotTables and PivotCharts
Objective
Resource: Excel Easy - PivotTables (Website)
YouTube Tutorial: Excel Data Analysis Class 01: PivotTables, Power Query, Formulas and Charts (by ExcelIsFun)
Exercise: Create a PivotTable to summarize and analyze a dataset.
Chapter 8: Data Analysis with Functions
Objective
Resources
YouTube Tutorial: M 365 Excel Worksheet Formulas & Models (by ExcellsFun)
Exercise: Use advanced functions like VLOOKUP, SUMIF, and COUNTIF in a data analysis task.
Chapter 9: Data Validation and Protection
Objective
Resource: Excel Easy - Data Validation (Website)
YouTube Tutorial: Excel Data Validation: List, Date, Time, Custom (22 Examples) (by ExcelIsFun)
YouTube Tutorial: Advanced Excel - Protecting a Sheet - Excel Tutorial
Exercise: Apply data validation rules to restrict data entry and protect a worksheet.
Chapter 10: Advanced Charting Techniques
Objective
Resources
YouTube Tutorial: Highline Excel 2016 Class 15: Excel Charts to Visualize Data: Comprehensive Lesson 11 Chart Examples (by ExcelIsFun)
Exercise: Create a combination chart and add advanced formatting to enhance visualizations.
Chapter11: Working with Multiple Worksheets and Workbooks
Objective
Resources
YouTube Tutorial: Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks (by ExcelIsFun)
YouTube Tutorial: Highline Excel 2016 Class 21: Power Query Import Multiple Excel Workbooks with Multiple Sheets by ExcellsFun)
Exercise: Consolidate data from multiple worksheets and link data between workbooks.
Acknowledgement of Training Completed
Acknowledgement of Training Completed
Acknowledgement of Training Completed
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock