Business Analytics with Excel
Course Overview
Enhance your Microsoft Excel skills with this introduction to business analytics with excel for beginners, learn business analytics fundamentals and statistics to build practical data-driven decision-making skills with the help of data analysis and statistics. In this business analytics course, you will learn how to use the most common office tools available – Excel to make sophisticated data analytics to arrive at business decisions.
Who is this course for?
- Managers, Departmental Heads, Functional Heads, Junior Data Scientists, IT Developers & Testers who are responsible for managing and improving functional operations
- Anyone who aspires to take up managerial role and be responsible for managing and improving functional operations
- Anyone with a passion to data and data interpretation towards operational excellence
Duration: 2 days (15 hrs)
Mode of Delivery: Trainer led Virtual session
Prerequisite: Basic Excel Knowledge
Learning Outcome
Upon completion of the course, participants will be able to,
- understand and learn the formulae, functions, and tools in excel to conduct basic to advanced data analysis and model building
- understand modelling, forecasting and simulation using excel
- discover multiple ways to visualize data to transform information into actionable insights
Course Outline
- Introduction to Business Analytics
- Types of Business Analytics
- Data Wrangling & Visualization
- Data Intelligence using Pivot Table Analysis
- Probability Theory and Bayes Theorem
- Probability Distributions and Simulation Modeling
- Decision Tree
- Linear Optimization and Sensitivity Analysis
- Discrete Optimization
- Application of Optimization
The training comprises presentations Highly participative and interactive, group discussions, practical exercise, critique sessions, handouts, course templates and case studies to provide hands-on understanding of the process audit approach and its application.