ADVANCED EXCEL

 

 

COURSE DESCRIPTION
In today’s fast-paced business climate, it is vital that decisions are made quickly and accurately. In this course,
participant will use Excel techniques to build sophisticated spread sheets. You learn to perform "what-if"
analysis, apply functions, manipulate PivotTables and present your results to make better decisions for
planning, budgeting and more.
COURSE OBJECTIVES
• Leverage features of Microsoft Excel to facilitate business decisions
• Develop intelligent worksheets to quickly identify Key Point Indicators (KPIs)
• Perform "what-if" analysis for developing budget and project plans
• Consolidate and process multidimensional worksheets
• Summarize and analyze large amounts of data using PivotTables and Excel features
• Automate Excel processes and enhance worksheet models
• Create stories, and dashboards
COURSE OUTLINE
• Common tasks in excel
• Creating powerful formulas
• Getting visual
• Security proofing
• Business Solutions and Excel
• Performing repetitive tasks more efficiently
• Enhancing Excel Usage with Macros o Recording macros and editing macro
• Analyzing and Deciphering Data
• Working with Pivot Tables o Sorting and filtering data o Using charts
• Summarizing Business Information
• Formulating Decisions from Database Information
• Scenario based modeling o Advanced excel modelling tools (This section of the course helps
delegates with the planning and development of a robust excel model template that can be used
many times over)

Cost: GH¢ 500.00

Duration: 4 days