Overview
The course will take you through a proven, structured process to improve your ability to collect, analyse and Forecast information to generate valuable insights and make well-supported business decisions.Employing exercises and solutions easily adaptable for your own workplace, this course employs a combination Of written materials, screenshots, videos and over 60 professional spreadsheet models (especially developed for Excel 2007/2010/2013).
Learning Outcomes
- Understand what drives change and predict future performance.
- Communicate information to colleagues, clients and stakeholders effectively.
- Understand your audience and present data using Excel.
Audience
- Financial and business analysts, managers, planners, customer-service staff, operations staff and information-management personnel.
- Professionals, team leaders and junior to intermediate Business Analysts would also benefit.
Syllabus
Section 1: Introduction
- Unit 1.1 - Turning Numbers into Better Business Decisions
Section 2: The Business Analyst's Excel Toolbox
- Unit 2.1 - Essential Excel for Business Analysis : Introduces four essential Excel techniques that differentiate good spreadsheets from average ones: using range names, conditional formatting, data validation and matching and ranking data.
- Unit 2.2 - Professional Tools for Business Analysts
Section 3: Collecting and Managing Business Data
- Unit 3.1 - Importing and Exporting Data
- Unit 3.2 - Power Functions for Managing Business Data
Section 4: Communicating Your Message
- Unit 4.1 - Your Stakeholders and Their Needs
- Unit 4.2 - Data Presentation Formats That Work
Section 5: Winning Charts for Business Communication
- Unit 5.1 - Professional Chartin
- Unit 5.2 - Dynamic Charts
- Unit 5.3 - Some Special Charts for Business Analysis
Section 6: Looking Inside Your Data (Analysis)
- Unit 6.1 - Analysing Data with Pivot Tables
- Unit 6.2 - Managing Pivot Tables Output
Section 7: Comparing Business Scenarios
- Unit 7.1 - Decision Making with Compared Scenarios
- Unit 7.2 - The Scenario Manager
Section 8: Looking Outside Your Data (Forecasting)
- Unit 8.1 - Time Series and Forecasting
- Unit 8.2 - Working with Moving Averages
- Unit 8.3 - Introduction to Regression
Section 9: Ending
-
Unit 9.1 - Ending
Duration
12 Hours