Business Analytics Certification Training with Excel
Simplilearn Americas LLC
Course Summary
The Business Analytics with Excel training will boost your analytics career with powerful new Microsoft® Excel skills. You'll learn the basic concepts of data analysis and statistics, helping promote data-driven decision making. You will also become trained in Power BI, so you can better visually represent and present your data analysis findings. Your new knowledge of these two commonly used tools combined with official business analytics certification is guaranteed to ensure career success.
-
+
Course Description
What are the System Requirements?
Microsoft Excel 2016 recommended
Power BI (Download free version @ https://powerbi.microsoft.com/en-us/)
Who are the trainers?
Highly qualified and certified instructors with industry relevant experience deliver trainings.Can I cancel my enrollment? Do I get a refund?
Yes, you can cancel your enrollment. We provide a complete refund after deducting the administration fee. To know more, please review our refund policy.Who provides the certification?
The certification is provided by Simplilearn.What are the payment options?
Payments can be made using any of the following options and a receipt will be issued to you automatically via email.Visa debit/credit card
American Express and Diners Club card
MasterCard
PayPal
Who are the instructors and how are they selected?
All of our highly-qualified trainers are certified, with more than 15 years of experience in training and working professionally in the field. Each of them has gone through a rigorous selection process that includes profile screening, technical evaluation and live training demonstration before they are certified to train for us. We also ensure that only those trainers who maintain a high alumni rating continue to train for us.What is Global Teaching Assistance?
Our teaching assistants are a dedicated team of subject matter experts here to help you get certified in your first attempt. They engage students proactively to ensure the course path is being followed and help you enrich your learning experience, from class onboarding to project mentoring and job assistance. Teaching Assistance is available during business hours.What is covered under the 24/7 Support promise?
We offer 24/7 support through email, chat, and calls. We also have a dedicated team that provides on-demand assistance through our community forum. What’s more, you will have lifetime access to the community forum, even after completion of your course with us.
-
+
Course Syllabus
Course preview
Business Analytics with Excel
Lesson 00 - Introduction 05:27
0.1 Course Introduction 05:27
Lesson 01 - Introduction to Business Analytics 09:52
1.1 Introduction 02:15
1.2 What Is in It for Me 00:10
1.3 Types of Analytics 02:18
1.4 Areas of Analytics 04:06
1.5 Quiz
1.6 Key Takeaways 00:52
1.7 Conclusion 00:11
Lesson 02 - Formatting Conditional Formatting and Important Fuctions 38:29
2.1 Introduction 02:12
2.2 What Is in It for Me 00:21
2.3 Custom Formatting Introduction 00:55
2.4 Custom Formatting Example 03:24
2.5 Conditional Formatting Introduction 00:44
2.6 Conditional Formatting Example1 01:47
2.7 Conditional Formatting Example2 02:43
2.8 Conditional Formatting Example3 01:37
2.9 Logical Functions 04:00
2.10 Lookup and Reference Functions 00:28
2.11 VLOOKUP Function 02:14
2.12 HLOOKUP Function 01:19
2.13 MATCH Function 03:13
2.14 INDEX and OFFSET Function 03:50
2.15 Statistical Function 00:24
2.16 SUMIFS Function 01:27
2.17 COUNTIFS Function 01:13
2.18 PERCENTILE and QUARTILE 01:59
2.19 STDEV, MEDIAN and RANK Function 03:02
2.20 Exercise Intro 00:35
2.21 Exercise
2.22 Quiz
2.23 Key Takeaways 00:53
2.24 Conclusion 00:09
Lesson 03 - Analyzing Data with Pivot Tables 19:32
3.1 Introduction 01:47
3.2 What Is in It for Me 00:22
3.3 Pivot Table Introduction 01:03
3.4 Concept Video of Creating a Pivot Table 02:47
3.5 Grouping in Pivot Table Introduction 00:24
3.6 Grouping in Pivot Table Example 1 01:42
3.7 Grouping in Pivot Table Example 2 01:57
3.8 Custom Calculation 01:14
3.9 Calculated Field and Calculated Item 00:25
3.10 Calculated Field Example 01:22
3.11 Calculated Item Example 02:52
3.12 Slicer Intro 00:35
3.13 Creating a Slicer 01:22
3.14 Exercise Intro 00:58
3.15 Exercise
3.16 Quiz
3.17 Key Takeaways 00:35
3.18 Conclusion 00:07
Lesson 04 - Dashboarding 32:07
4.1 Introduction 01:18
4.2 What Is in It for Me 00:18
4.3 What is a Dashboard 00:45
4.4 Principles of Great Dashboard Design 02:16
4.5 How to Create Chart in Excel 02:26
4.6 Chart Formatting 01:45
4.7 Thermometer Chart 03:32
4.8 Pareto Chart 02:26
4.9 Form Controls in Excel 01:08
4.10 Interactive Dashboard with Form Controls 04:13
4.11 Chart with Checkbox 05:48
4.12 Interactive Chart 04:37
4.13 Exercise Intro 00:55
4.14 Exercise1
4.15 Exercise2
4.16 Quiz
4.17 Key Takeaways 00:34
4.18 Conclusion 00:06
Lesson 05 - Business Analytics With Excel 25:48
5.1 Introduction 02:12
5.2 What Is in It for Me 00:24
5.3 Concept Video Histogram 05:18
5.4 Concept Video Solver Addin 05:00
5.5 Concept Video Goal Seek 02:57
5.6 Concept Video Scenario Manager 04:16
5.7 Concept Video Data Table 02:03
5.8 Concept Video Descriptive Statistics 01:58
5.9 Exercise Intro 00:52
5.10 Exercise
5.11 Quiz
5.12 Key Takeaways 00:39
5.13 Conclusion 00:09
Lesson 06 - Data Analysis Using Statistics 31:57
6.1 Introduction 01:51
6.2 What Is in It for Me 00:21
6.3 Moving Average 02:50
6.4 Hypothesis Testing 04:20
6.5 ANOVA 02:47
6.6 Covariance 01:56
6.7 Correlation 03:38
6.8 Regression 05:15
6.9 Normal Distribution 06:49
6.10 Exercise1 Intro 00:34
6.11 Exercise 1
6.12 Exercise2 Intro 00:17
6.13 Exercise 2
6.14 Exercise3 Intro 00:19
6.15 Exercise 3
6.16 Quiz
6.17 Key Takeaways 00:52
6.18 Conclusion 00:08
Lesson 07 - Power BI 14:01
7.1 Introduction 01:17
7.2 What Is in It for Me 00:18
7.3 Power Pivot 04:16
7.4 Power View 02:36
7.5 Power Query 02:45
7.6 Power Map 02:06
7.7 Quiz
7.8 Key Takeaways 00:32
7.9 Conclusion 00:11
That was just a sneak-peak into the lesson.
Enroll for this course and get full access.
Enroll now
