Advanced Excel Training Masterclass Course

Actions Panel

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

When and where

Date and time

Location

Online

Refund Policy

No Refunds

About this event

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: Customising Excel

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

You can get details of Launch Hub Certification Training Courses Here

or reach us at:

Email: info@projectcentered.com

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.

We also offer consultancy Services in Project Management get more info here: