Transform numbers and data into business success.
Success depends on the ability to make the best business decisions. To do that, you must make the most of the numbers available to you.
This course will greatly enhance your ability to collect, analyse and forecast business and financial data to generate valuable insights from business data.
By the end of this course you’ll be able to:
• Make better business decisions for greater profits
• Understand the data that drives your business
• Impress stakeholders, clients and managers with your insight and presentation skills
• Maximise the value you get from your current tools and desktop systems
• Save time and money spent on data handling thanks to your elevated efficiency
In this course you will learn:
• How to turn buckets of data into sound business decisions
• Financial modelling theory
• Essential Excel analysis techniques such as Dynamic Ranges, and Advanced Charts
• How to effectively and clearly present your findings to relevant stakeholders
• Different forecasting techniques, including Moving Averages and Regression
More about us:
• We have nearly a million students
• Our training is personal. Use the filter to show you which parts of the course to skip.
• Our platform is award-winning and always improving. We work with our authors to ensure our courses are up to date.
• All of our courses are certificated on completion – most of our Business Courses are alsoCPD Accredited.
If you are not 100% happy with your EwB Business Analysis course, you have 30 days to exchange or refund.
About the author:
Harold Graycar is an experienced executive with a broad background in information technology, business development and general management.
His degrees are in Computer Science and Electrical Engineering from the University of Sydney, Australia. In addition to his numerate and analytical skills, Harold’s ability to communicate and work with personnel from non-technical backgrounds makes him a valuable contributor to multi-disciplinary projects, and an effective business trainer.
He has over 25 years’ experience in technical, commercial and general management roles: advising corporate and government clients on project funding, models and strategies for business development, procurement of equipment and services and outsourcing of systems and operations — all based around business analysis and numerate skills.
Harold has been a “power user” and developer of Excel applications since the product was launched, and has developed a number of Excel modelling tools for financial applications, workforce planning, HR profile analysis and transaction logging.
Harold has presented executive-level Financial Analysis, Forecasting and Business Modelling sessions for public groups and individual client organisations in Australia, Brunei, China, Malaysia, Macao, Philippines and Singapore. The focus is always on how to increase productivity with better hands-on numerate and information presentation skills.
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
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 Charting
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