Advanced/Power Excel

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

Learning Outcomes

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 analyse large amounts of data using PivotTables and Excel features
• Automate Excel Processes

Course Outline

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

Upcoming Training

  • 15
    APR     Grant Proposal Writing
    9:00am-3:00pm     | CSBPD
    See Details
  • 20
    APR     Media Engineering Training
    9:00am-2:00pm     | CSBPD
    See Details
  • 15
    APR     EXCEL VBA Training
    9:00am - 3:00pm     | CSBPD
    See Details
  • 20
    APR     Mobile Phone Assembling and Repairs
    9:00am (Saturdays Only)     | CSBPD
    See Details