Session 1 - Basics of Excel, Worksheet, Workbook, Data Type
Session 2 - Math Functions, Statistical Functions
Session 3 - Basics of Excel Merge Across, Wrap Text, Multiline Text
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
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
