Assessment - Additional Functions

Microsoft Advance Excel Training

Session 1 - Basics of Excel, Worksheet, Workbook, Data Type

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 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 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 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

Practice Sheets

Prepare your Linkedin profile

Prepare your Resume

Final Quiz

Lesson content locked

If you're already enrolled, you'll need to login.