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
Resource: Coursera - Create Charts and Dashboards Using Microsoft Excel (Website)
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock