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

  • 07
    OCT     Certificate in Graphic Design Production
    9:00 am-2:00 pm     | GCTU main Campus, Tesano.
    See Details
  • 29
    JUL     3 Months Certificate In Mobile Phone Assembling And Repairs
    9:00 AM-2:00 PM     | GCTU-Tesano And Brich Hub
    See Details
  • 24
    JUL     Invitation To A Three Day Front Desk Competency Training
    9:00 am- 4:00 pm     | PDU
    See Details
  • 17
    JUL     Invitation To A Five Day Training In Strategic Marketing, Brand Management And Public Relations
    9:00 am- 3:00 pm     | PDU
    See Details