Advanced Excel Training Masterclass Course


Advanced Excel Training Masterclass Course


The advanced Excel course helps you to automate spreadsheets, work with advanced functions and reports using pivot tables and pivot charts

SKU: 003-1 Category:


This practical, 4 day Advanced Excel Training Masterclass focuses on the MS Excel skills that the typical business user would require.

This Online Advanced Excel Training Course is Instructor-led live, interactive online training with certificate of completion.

Course Content

Module 1: Customizing Excel

  • Customizing the Ribbon
  • Changing defaults

Module 2: Database Essentials

  • What is a Database
  • Correct Data Input
  • Using the Get and Transform Data
  • Sorting a list
  • Filtering a list
  • Data Forms
  • Setting Data Validation
  • Custom Number formats

Module 3: Excel tools

  • Linking Worksheets
  • Data Consolidation
  • Using hyperlinks
  • Protecting Worksheets, Workbooks and Files

Module 4: Advanced functions

  • Creating and using Range Names
  • =And, =Or
  • =If and Nested IF statements
  • =iferror
  • =Sumif and =Countif
  • =Sumifs and =Countifs
  • =Vlookup among other functions

Module 5: Pivot Table Reports

  • Creating a pivot table
  • Filter/Show and Hide Pivot Table data
  • Using slicers
  • Rearranging Pivot Tables:
  • Grouping fields
  • Moving fields
  • Collapsing and Expanding fields
  • Refreshing data
  • Using Show Value As
  • Adding Subtotals and Grand Totals
  • Formatting field settings
  • Applying a Pivot Table Style
  • Creating a new custom Pivot table style
  • Creating a PivotChart

Module 6: Macros

  • Recording a macro
  • Relative and Absolute References
  • Editing and Deleting macros
  • Running a macro
  • Assigning macros to objects
  • Assigning macros to a toolbar

Enroll now for a discounted price Advanced Excel Masterclass


Call us – +254 707 260 205

Advanced Excel Classroom Training, Live Online Training and Weekend special classes are also offered,

To know about the dates, prices, and offers, chat with us now or send a query

Other Trainings offered include: Advanced Excel Training Masterclass Course; Ms. Project Masterclass; Project Management Professional; Product Management Masterclass; Ultimate Startup Guide for successful Startups.