###### CCNA 200-301 Pearson uCertify Network Simulator

ISBN: 978-1-61691-837-8Cisco 200-301-SIMULATOR.AB1

Learn the core concepts of MS data analysis and business modeling to develop the right skills for transforming worksheet data into actionable insights.

(XLS-DA-BM.AB1) / ISBN : 978-1-64459-368-4This course includes

Lessons

TestPrep

Hands-On Labs

AI Tutor (Add-on)

313
Review

In today’s data-driven world, every business (big or small) thrives on its ability to transform data into action items. This Excel Business Modeling and Data Analysis course teaches you how to use MS Excel for analyzing data and building financial models that help businesses make informed decisions. Other than learning basic excel formulas, functions, data manipulation and chart creation, you’ll also learn how to use data analysis tools like PivotTables, data tables, scenario analysis (what-if situations), and data consolidation. Use of analytical techniques for building financial models like budgets and forecasts is also covered in the Excel data analysis training course. To make it a fun learning experience for you, we have also included interactive activities like hand-on labs, flashcards, and quizzes along with the course content.

- Translating Excel basics to relatable analytics
- Using Power Query for cleaning and connecting data
- Create custom functions with LAMBDA (without VBA)
- Utilizing new charts and data types for visualizing data like a pro
- Utilizing data manipulation techniques like advanced XLOOKUP function
- Using 3D Maps for highlighting geographical trends
- Confidently building powerful business data models

Get the support you need. Enroll in our Instructor-Led Course.

97+ Interactive Lessons | 180+ Exercises | 188+ Quizzes | 111+ Flashcards | 111+ Glossary of terms

60+ Pre Assessment Questions | 60+ Post Assessment Questions |

60+ LiveLab | 60+ Video tutorials | 02:12+ Hours

1

- What you should know before reading this course?
- How to use this course?

2

- Answers to this lesson's questions
- Problems

3

- How can I create named ranges?
- Answers to this lesson’s questions
- Remarks
- Problems

4

- Syntax of the lookup functions
- Answers to this lesson’s questions
- Problems

5

- Syntax of the INDEX function
- Answers to this lesson’s questions
- Problems

6

- Syntax of the MATCH function
- Answers to this lesson’s questions
- Problems

7

- Text function syntax
- Answers to this lesson’s questions
- Problems

8

- Answers to this lesson’s questions
- Problems

9

- Answers to this lesson’s questions
- Problems

10

- Answers to this lesson’s questions
- Problems

11

- Answers to this lesson’s questions
- Problems

12

- Answers to this lesson’s questions
- Problems

13

- Answers to this lesson’s questions
- Problems

14

- Answers to this lesson’s questions
- Problems

15

- Answers to this lesson’s questions
- Problems

16

- Answers to this lesson’s questions
- Problems

17

- Excel auditing options
- Answers to this lesson’s questions
- Problems

18

- Answers to this lesson’s questions
- Problems

19

- Answers to this lesson’s questions
- Problems

20

- Answer to this lesson’s question
- Remarks
- Problems

21

- Answers to this lesson’s questions
- Remarks
- Problems

22

- Answers to this lesson’s questions
- Problems

23

- Answers to this lesson’s questions
- Problems

24

- Answers to this lesson’s questions
- Problems

25

- Answers to this lesson’s questions
- Problems

26

- Answer to this lesson’s question
- Problems

27

- Answers to this lesson’s questions
- Problems

28

- Answers to this lesson’s questions
- Remarks
- Problems

29

- Answers to this lesson’s questions
- Problems

30

- Answers to this lesson’s questions
- Problems

31

- Answers to this lesson’s questions
- Problems

32

- Answers to this lesson’s questions
- Problems

33

- Answers to this lesson’s questions
- Problems

34

- Answers to this lesson’s questions
- Problems

35

- Questions answered in this lesson
- Problems

36

- Answers to this lesson’s questions
- Problems

37

- Answers to this lesson’s question
- Problems

38

- Answers to this lesson’s questions
- Problems

39

- Answers to this lesson’s questions
- Problems

40

- Answers to this lesson’s questions
- Problems

41

- Answers to this lesson’s questions
- Problems

42

- Answers to this lesson’s questions
- Problems

43

- Answers to this lesson’s questions
- Problems

44

- Answers to this lesson’s questions
- Remarks
- Problems

45

- Answers to this lesson’s questions
- Problems

46

- Answers to this lesson’s questions
- Problems

47

- Answers to this lesson’s questions
- Problems

48

- Answers to this lesson’s questions
- Problems

49

- Answers to this lesson’s questions
- Problems

50

- Answers to this lesson’s questions
- Problems

51

- Answers to this lesson’s questions
- Problems

52

- Answers to this lesson’s question
- Problems

53

- Answer to this lesson’s question
- Problems

54

- Answer to this lesson’s question
- Problems

55

- Answers to this lesson’s questions
- Problems

56

- Answer to this lesson’s question
- Problems

57

- Answers to this lesson’s questions
- Problems

58

- Answers to this lesson’s questions
- Problems

59

- Answers to this lesson’s questions
- Problems

60

- Answers to this lesson’s questions
- Problems

61

- Answers to this lesson’s questions
- Problems

62

- Answers to this lesson’s questions
- Problems

63

- Answers to this lesson’s questions
- Problems

64

- Answers to this lesson’s questions
- Problems

65

- Answers to this lesson’s questions
- Problems

66

- Answers to this lesson’s questions
- Problems for Lessons 51–53

67

- Answers to this lesson’s questions
- Problems

68

- Answers to this lesson’s questions
- Problems

69

- Answers to this lesson’s questions
- Problems

70

- Answers to this lesson’s questions
- Problems

71

- Answers to this lesson’s questions
- Problems

72

- Answers to this lesson’s questions
- Problems

73

- Answers to this lesson’s questions
- Problems

74

- Answers to this lesson’s questions
- Remarks
- Problems

75

- Answers to this lesson’s questions
- Problems

76

- Answer to this lesson’s question
- Problem

77

- Answers to this lesson’s questions
- Problem

78

- Answers to this lesson’s questions
- Problems

79

- Answers to this lesson’s questions
- Remarks
- Problems

80

- Answers to this lesson’s questions
- Problems

81

- Answers to this lesson’s questions
- Problems

82

- Answers to this lesson’s questions
- Problems

83

- Answers to this lesson’s questions
- Problems

84

- Answers to this lesson’s questions
- Problems

85

- Answer to this lesson’s question
- Problems

86

- Answer to this lesson’s question
- Problems

87

- Answers to this lesson’s questions
- Problems

88

- Answers to this lesson’s questions
- Problems

89

- Answers to this lesson’s questions
- Problems

90

- Answers to this lesson’s questions
- Problems

91

- Answers to this lesson’s questions
- Problems

92

- Answers to this lesson’s questions
- Problems

93

- Answer to this lesson’s question
- Problems

94

- Answers to this lesson’s questions
- Problems

95

- Answers to this lesson’s questions
- Problems

96

- Answers to this lesson’s questions
- Problems

97

- Answers to this lesson’s questions
- Problems

2

- Performing Mathematical Calculations using Formulas

4

- Accumulating Data Using the VLOOKUP Function

5

- Extracting Data Using the INDEX Function

6

- Finding the Required Data Using the MATCH Function

7

- Creating Email Addresses Using the Excel Text Functions

8

- Calculating the Number of Workdays Using a Date Function

9

- Computing Annual Sales Using the IF Function

10

- Calculating Race Timings Using the Time Functions

11

- Calculating Net Present Value Using the NPV Function

13

- Determining Depreciation Using Excel Financial Functions

15

- Using the Paste Special Command to Convert Data

16

- Summarizing Data Using Three-Dimensional Formulas

21

- Counting Cells with Criteria Using COUNTIF and COUNTIFS Functions

22

- Calculating with Criteria Using the COUNTIF and SUMIF Functions

23

- Creating Bin Ranges Using Histograms

25

- Summarizing Data

26

- Consolidating Data

27

- Creating a Subtotal using the SUBTOTAL Function

28

- Using the OFFSET Function to Create Lagged Values

29

- Using the INDIRECT Function to Tabulate Data

32

- Using Excel Tables to Perform Calculations

33

- Creating a Scatter Chart

36

- Creating Sparklines

37

- Importing Data from a Text File

38

- Using the Power Query Editor to Transform Data

40

- Sorting Data

42

- Performing Calculations Using Array Functions and Formulas

46

- Creating a PivotTable and PivotChart

47

- Using the Distinct Count Option for Calculation

51

- Determining the Profit-Maximizing Product Mix Using Solver

53

- Finding an Optimal Solution Using Solver

54

- Obtaining Maximum NPV using Solver

55

- Determining the Monthly Payment Using Solver

59

- Solving the Traveling Salesperson Problem

60

- Creating a Scatter Chart and Adding a Trendline

61

- Creating an Exponential Trend Curve

62

- Creating a Power Curve

63

- Using Correlations to Find the Relationship Between Variables

64

- Using Multiple Regression to Find the Optimal Forecasting Equation

70

- Using Variance and Standard Deviation to Measure the Spread of Data

71

- Computing Binomial Probabilities

72

- Computing Poisson Distribution

73

- Calculating Z-Scores

74

- Calculating the Future Price of a Stock Using a Lognormal Variable

75

- Determining Probability Using the Beta Random Variable

76

- Creating a Moving Average Graph

77

- Using the Ratio-to-Moving-Average Forecasting Method

79

- Estimating Smoothing Constants

81

- Simulating the Values of a Normal Random Variable

82

- Determining the Optimal Bid using Simulation

83

- Determining Asset Allocation

84

- Simulating the Outcome of a Sporting Event

85

- Implementing Resampling

86

- Creating a Spider Plot

87

- Using Formula Protection in a Worksheet

88

- Determining Customer Value

90

- Determining the Economic Order Quantity (EOQ)
- Determining the Reorder Point

92

- Plotting a Linear Demand Curve

94

- Finding the Optimal Price Using Subjectively Determined Demand

Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us NowAt uCertify, we provide 24/7 tech support to the users for all of our courses.