MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

# Business Analytics Certification Training with Excel

### 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 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

Course Fee:
USD 299

Self-Study

### Course Status:

Active

1 - 4 hours / week

Related Posts:

## Maintain

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software