Business AnalyticsFundamentals with Excel
Supercharge your analytics career with powerful new Excel skills. You'll learn the basic concepts of data analysis and statistics, helping promote data-driven decision making.
Supercharge your analytics career with powerful new Excel skills. You'll learn the basic concepts of data analysis and statistics, helping promote data-driven decision making.
365 days of access to high-quality, self-paced learning content designed by industry experts
Business Analytics with excel training has been designed to help initiate you to the world of analytics. For this we use the most commonly used analytics tool i.e. Microsoft Excel. The training will equip you with all the concepts and hard skills required to kick start your analytics career. If you already have some experience in the IT or any core industry, this course will quickly teach you how to understand data and take data driven decisions relative to your domain using Microsoft excel. For a new-comer to the analytics field, this course provides the best required foundation.
With Certs-school’s training on Business Analytics with Excel, you will be able to:
✔ Understand what business analytics means and its importance in industry
✔ Grasp fundamentals of excel analytics functions and conditional formatting
✔ Learn how to analyse with complex datasets using pivot tables and slicers
✔ Solve stochastic and deterministic analytical problems using tools like scenario manager, solver and goal seek
✔ Apply statistical tools and concepts like moving average, hypothesis testing, ANOVA and regression to data sets using excel
✔ Represent your findings using charts and dashboards
✔ Get introduced to the latest Microsoft analytic and visualization tools i.e. Power BI
The Business Analytics with excel is a great course for both beginners and experienced professionals who are uninitiated to or have recently stepped into the field of analytics. This course is beneficial for
✔ IT developers & testers
✔ Data analysts
✔ Junior Data scientists
✔ Analytics Professionals
✔ BI and reporting professionals
✔ Project managers
✔ Students
✔ Professionals working with data in any industry
There are no prerequisites for this course other than an analytical bent of mind. We do expect the participants to have a basic knowledge of working with Microsoft Excel.
✔ 12 hours of High Quality e-Learning content
✔ A project to provide hands-on experience
✔ Latest Excel 2016 and MS Power BI training
✔ 8 chapter-end exercises and 45 concept videos
✔ Downloadable e-book
0.1 - Introduction05:27
0.2 - Course Introduction05:27
1.1 - IntroductionPreview02:15
1.2 - What Is in It for MePreview00:10
1.3 - Types of Analytics02:18
1.4 - Areas of Analytics04:06
1.5 - Quiz
1.6 - Key Takeaways00:52
1.7 - Conclusion00:11
2.1 - Introduction02:12
2.2 - What Is in It for Me00:21
2.3 - Custom Formatting Introduction00:55
2.4 - Custom Formatting Example03:24
2.5 - Conditional Formatting Introduction00:44
2.6 - Conditional Formatting Example101:47
2.7 - Conditional Formatting Example202:43
2.8 - Conditional Formatting Example301:37
2.9 - Logical Functions04:00
2.10 - Lookup and Reference Functions00:28
2.11 - VLOOKUP Function02:14
2.12 - HLOOKUP Function01:19
2.13 - MATCH Function03:13
2.14 - INDEX and OFFSET Function03:50
2.15 - Statistical Function00:24
2.16 - SUMIFS Function01:27
2.17 - COUNTIFS Function01:13
2.18 - PERCENTILE and QUARTILE01:59
2.19 - STDEV, MEDIAN and RANK Function03:02
2.20 - Exercise Intro00:35
2.21 - Exercise
2.22 - Quiz
2.23 - Key Takeaways00:53
2.24- Conclusion00:09
3.1 - Introduction01:47
3.2 - What Is in It for Me00:22
3.3 - Pivot Table Introduction01:03
3.4 - Concept Video of Creating a Pivot Table02:47
3.5 - Grouping in Pivot Table Introduction00:24
3.6 - Grouping in Pivot Table Example 101:42
3.7 - Grouping in Pivot Table Example 201:57
3.8 - Custom Calculation01:14
3.9 - Calculated Field and Calculated Item00:25
3.10 - Calculated Field Example01:22
3.11 - Calculated Item Example02:52
3.12 - Slicer Intro00:35
3.13 - Creating a Slicer01:22
3.14 - Exercise Intro00:58
3.15 - Exercise
3.16 - Quiz
3.17 - Key Takeaways00:35
3.18 - Conclusion00:07
4.1 - Introduction01:18
4.2 - What Is in It for Me00:18
4.3 - What is a Dashboard00:45
4.4 - Principles of Great Dashboard Design02:16
4.5 - How to Create Chart in Excel02:26
4.6 - Chart Formatting01:45
4.7 - Thermometer Chart03:32
4.8 - Pareto Chart02:26
4.9 - Form Controls in Excel01:08
4.10 - Interactive Dashboard with Form Controls04:13
4.11 - Chart with Checkbox05:48
4.12 - Interactive Chart04:37
4.13 - Exercise Intro00:55
4.14 - Exercise1
4.15 - Exercise2
4.16 - Quiz
4.17 - Key Takeaways00:34
4.17 - Conclusion00:06
5.1 - Introduction02:12
5.2 - What Is in It for Me00:24
5.3 - Concept Video Histogram05:18
5.4 - Concept Video Solver Addin05:00
5.5 - Concept Video Goal Seek02:57
5.6 - Concept Video Scenario Manager04:16
5.7 - Concept Video Data Table00:03
5.8 - Concept Video Descriptive Statistics01:58
5.9 - Exercise Intro00:52
5.10 - Exercise
5.11 - Quiz
5.12 - Key Takeaways00:39
5.13 - Conclusion00:09
6.1 - Introduction01:51
6.2 - What Is in It for Me00:21
6.3 - Moving Average02:50
6.4 - Hypothesis Testing04:20
6.5 - ANOVA02:47
6.6 - Covariance01:56
6.7 - Correlation03:38
6.8 - Regression05:15
6.9 - Normal Distribution06:49
6.10 - Exercise1 Intro00:34
6.11 - Exercise 1
6.12 - Exercise2 Intro00:17
6.13 - Exercise2
6.14 - Exercise3 Intro00:19
6.15 - Exercise 3
6.16 - Quiz
6.17 - Key Takeaways00:52
6.18 - Conclusion00:08
7.1 - Introduction01:17
7.2 - What Is in It for Me00:18
7.3 - Power Pivot04:16
7.4 - Power View02:36
7.7 - Power Query02:45
7.6 - Power Map02:06
7.7 - Quiz
7.8 - Key Takeaways00:32
7.9 - Conclusion00:11
The Analytics team of an Online E-Commerce Company wants to design a Sales dashboard to analyze the sales based on various product categories. The company wants to add user control for product category, so users can select a category and can see the trend month-wise and product-wise accordingly. The Analytics team also wants to create a histogram to analyze number of shipping days.
The Analytics team of a pharmaceutical company wants to design a dashboard to analyze the sales of products across various regions and brands. It wants to create a chart with User control functionality, so users can easily see the total Sales and “commission of external agents” categorized by brands and region.
In order to get certified in Business Analytics with excel the participant must complete and sumbit the evaluation project. On successful evaluation the participant will receive the certification.
✔ Problem statements along with Data points are provided in the Learning Management System.
✔ On the completion of the course, you have to submit the project which will be evaluated by the trainer. On successful evaluation of the project and completion of the online exam you will get a certification in Business Analytics using Excel from Certs-School. You can submit your project through LMS.
Microsoft Excel 2016 recommended
Power BI (Download free version @ https://powerbi.microsoft.com/en-us/)
Highly qualified and certified instructors with industry relevant experience deliver trainings.
