Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Advance Excel Training
Refer a Friend and Get 10% off for you and for them
Give 10% and Get 10%
Session 1 - Basics of Excel, Worksheet, Workbook, Data Type
Session Video - Basics of Excel, Worksheet, Workbook, Data Type (111:21)
Assessment - Basics of Excel, Worksheet, Workbook, Data Type
Assignment - Basics of Excel, Worksheet, Workbook, Data Type
Lab Activity - Introduction to Excel Basics
Quiz
Session 2 - Math Functions, Statistical Functions
Session Video - Math Functions, Statistical Functions (113:20)
Assessment - Math Functions, Statistical Functions
Assignment - Math Functions, Statistical Functions
Lab Activity - Exploring Mathematical and Statistical Functions in Microsoft Excel
Quiz
Session 3 - Basics of Excel Merge Across, Wrap Text, Multiline Text
Session Video - Basics of Excel Merge Across, Wrap Text, Multiline Text (112:35)
Assessment - Basics of Excel Merge Across, Wrap Text, Multiline Text
Assignment - Basics of Excel Merge Across, Wrap Text, Multiline Text
Lab Activity - Mastering Text Formatting in Excel
Quiz
Session 4 - Paste Special And Date Functions
Session Video - Paste Special And Date Functions (110:46)
Assessment - Paste Special and Date Functions
Assignment - Paste Special and Date Functions
Lab Activity - Mastering Paste Special and Date Functions in Microsoft Excel
Quiz
Session 5 - Sort, Advance Sort, Multi Row Sort, Color, Font Color Sort Filter
Session Video - Sort, Advance Sort, Multi Row Sort, Color, Font Color Sort Filter (110:59)
Assessment - Sort, Advance Sort, Multi Row Sort, Colour, Font Colour Sort Filter
Assignment - Sort, Advance Sort, Multi Row Sort, Color, Font Color Sort Filter
Lab Activity - Mastering Sorting and Filtering Techniques in Microsoft Excel
Quiz
Session 6 - Advance Conditional Formatting Using Formula, New Rule Match Function, Vlookup
Session Video - Advance Conditional Formatting Using Formula, New Rule Match Function, Vlookup (98:35)
Assessment - Advance Conditional Formatting Using Formula, New Rule Match Function, Vlooku
Assignment - Advance Conditional Formatting Using Formula, New Rule Match Function, VLooku
Lab Activity - Advanced Conditional Formatting and VLOOKUP
Quiz
Session 7 - Index Match, Types of Errors
Session Video - Index Match, Types of Errors (102:18)
Assessment - Index Match, Types of Errors
Assignment - Index Match, Types of Errors
Lab Activity - Advanced Excel Functions - Index Match and Error Handling
Quiz
Session 8 - Data Validation, Formula Auditing Freeze Panes, Freeze First Row
Session Video - Data Validation, Formula Auditing Freeze Panes, Freeze First Row (106:31)
Assessment - Data Validation, Formula Auditing Freeze Panes, Freeze First Row
Assignment - Data Validation, Formula Auditing Freeze Panes, Freeze First Row
Lab Activity - Mastering Excel Techniques - Data Validation, Formula Auditing, Freeze Pane
Quiz
Session 9 - Pivot Table, Unique Function, Xlookup Function Slicer, Subtotal Function
Session Video - Pivot Table, Unique Function, Xlookup Function Slicer, Subtotal Function (105:50)
Assessment - Pivot Table, Unique Function, Xlookup Function Slicer, Subtotal Function
Assignment - Pivot Table, Unique Function, XLookup Function Slicer, Subtotal Function
Lab Activity - Excel Data Analysis Masterclass Harnessing Advanced Functions for Busin
Quiz
Session 10 - Charts And Formatting Charts
Session Video - Charts And Formatting Charts (114:48)
Assessment - Charts and Formatting Charts
Assignment - Charts and Formatting Charts
Lab Activity - Creating Interactive Charts in Microsoft Excel
Quiz
Session 11 - How To Get Add In a Aided Formula Editor
Session Video - How To Get Add In a Aided Formula Editor (79:14)
Assessment - How to Get Add In a Aided Formula Editor
Assignment - How to Get Add In a Aided Formula Editor
Lab Activity - Integrating and Utilizing an Add-In Aided Formula Editor in Microsoft Exce
Quiz
Lab Activity
Lab Activity - Integrating and Utilizing an Add-In Aided Formula Editor in Microsoft Exce
Lab Activity - Exploring Mathematical and Statistical Functions in Microsoft Excel
Lab Activity - Mastering Text Formatting in Excel
Lab Activity - Mastering Paste Special and Date Functions in Microsoft Excel
Lab Activity - Mastering Sorting and Filtering Techniques in Microsoft Excel
Lab Activity - Advanced Conditional Formatting and VLOOKUP
Lab Activity - Advanced Excel Functions - Index Match and Error Handling
Lab Activity - Mastering Excel Techniques - Data Validation, Formula Auditing, Freeze Pane
Lab Activity - Excel Data Analysis Masterclass Harnessing Advanced Functions for Busin
Assessments
Assessment - Microsoft Excel Mastery Basics
Assessment - Functions Start
Assessment - Conditional Formatting
Assessment - Additional Functions
Assessment - Data
Assessment - Pivot Table
Assessment - Charts
Practice Sheets
Practice Sheet - 1
Practice Sheet - 2
Practice Sheet - 3
Practice Sheet - 4
Prepare your Linkedin profile
Linkedin Cheat Sheet
Prepare your Resume
Resume Cheat Sheet
Final Quiz
Test your Skills!
Teach online with
Resume Cheat Sheet
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock