Advanced Microsoft Excel

From Mid-Level to Advanced Proficiency

Overview

Advanced Microsoft Excel offers the best software for data processing and analysis because of its vast capabilities in simplifying and streamlining tasks - but grasping the multitude of features it provides can be overwhelming. This training unveils Excel's most sophisticated features and functions, elevating proficiency from a mid-level to an advanced stage, empowering participants with mastery over Excel's most advanced tools in just a few days.

Expected Learning Outcomes

  • Import and export data from the Internet into Excel, and share worksheets online
  • Develop templates for intricate worksheets and workbooks, and employ named ranges and lists
  • Transfer data to and from Excel and other Office applications
  • Refine lists using pivot tables and pivot table charts
  • Scrutinize and validate worksheets and workbooks for errors, and effectively manage and personalize workbooks
  • Apply advanced budgeting functions for loan analysis, and utilize data tables and scenario management
  • Employ case studies to formulate worksheets and workbooks

Curriculum

  • Advanced data sorting, filtering, validation and cleaning
  • Functions such as IF, SUMIF, COUNTIF, AVERAGEIF, plus text and date functions
  • Advanced filtering techniques - AutoFilter, Advanced Filter, and Slicers

  • Creating and customizing PivotTables with calculated fields and items
  • Creating PivotCharts for visual data analysis
  • Using slicers, timelines, and PivotTable styles

  • Advanced charts - waterfall charts, combo charts, and sparklines
  • Customizing chart elements and formatting
  • Conditional formatting with data bars, colour scales, and icon sets, and building interactive dashboards

  • Array formulas and functions
  • Lookup and reference functions - VLOOKUP, HLOOKUP, INDEX, MATCH
  • Logical functions (IF, AND, OR) and dynamic named ranges, plus auditing and error-checking tools

  • Importing data from external sources and managing data connections
  • Exporting Excel data to PDF, CSV and other formats
  • Recording and editing macros, and using VBA for automation

  • Goal Seek and Solver for optimization problems; What-If Analysis with Data Tables and Scenario Manager
  • Custom data validation rules and workbook/worksheet protection
  • Sharing workbooks, track changes, merging workbooks, and co-authoring in Excel Online

Delivery

A hands-on, example-driven course working through real worksheets and case studies to build advanced Excel mastery.
ModeVirtual
Duration5 Days
FeeKsh. 92,800 (VAT Inc.)
ScheduleOpen Enrolment - No fixed dates

Who Should Attend
  • Professionals who use Excel for data processing, reporting, and analysis
  • Finance, administration, and operations staff seeking advanced spreadsheet skills