3Days03Hrs43Mins46Secs
Jan 21 2025

Business Analysis Using Excel(Jan. 21-23) Virtual

  • 9:00am
  • National Banking College

Background

In this excel data analysis course, you will use advanced Excel techniques to build sophisticated spreadsheets. You learn to perform “what if” analyses, leverage features and apply functions, manipulate Pivot Tables to analyse large amounts of data, and present your results to make better business decisions for planning and budgeting. You also learn how to automate processes and enhance worksheet models.

Programme Objectives

  • Leverage features of Microsoft Excel to facilitate business decisions
  • Develop intelligent worksheets to quickly identify 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

Optimizing Workbook Models with “What-If” Analysis’
Quantifying variables in a workbook model
Organizing workbooks and links.
Consolidating ranges
Formulating Decisions from Database Information
Distilling data sets for data analysis.
Interpreting and refining data with PivotTables
Visualizing and exploring PivotTable reports
Enhancing Excel Usage with Macros
Automating repetitive tasks.

Target Group

  • All those who have knowledge of excel at the intermediate level

CostGHC0.00

To register, contact the programmes secretariat now !

+233 (0) 302 760006