Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Advance Excel Training
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
Assessment - Basics of Excel, Worksheet, Workbook, Data Type
Assessment - Session 1 - Basics of Excel, Worksheet, Workbook, Data Type.pdf
Complete and Continue