POWER EXCEL TRAINING

POWER EXCEL TRAINING

DURATION: 5 DAYS  

Start Date: 26th Feb, 2018

End Date: 2nd March, 2018

Campus:  Accra

Course Overview

This training programme helps participants build sophisticated spreadsheets, perform “what-if” analyses, apply functions, manipulate Pivot Tables, present and interpret results in Microsoft Excel

Programme outcome

Participants will be able to:-

  • Leverage features of Microsoft Excel to facilitate business decisions
  • Develop intelligent worksheets to quickly identify Key Performance Indicators (KPIs)
  • Perform “what-if” analyses for developing budget and project plans
  • Summarize and analyze large amounts of data using PivotTables and Excel features
  • Automate Excel processes

Course outline

  • Analyzing Data with Functions
  • Controlling calculations and nested formulas
  • Quantifying variables in a workbook model
  • Organizing workbooks and links and consolidating ranges
  • Enhancing Excel Usage with Macros
  • Recognizing the code behind a Macro
  • Troubleshooting and Enhancing Professional Workbooks

Who Should Attend

Business and Technical Professionals, Business Decision Makers, Data Analysts, or any individual who wants to increase their knowledge in intermediate to advanced features in Power Excel.