### Microsoft Excel Data Analysis and Business Modeling

(XLS-DA-BM.AB1) / ISBN : 9781644593684

Get a hands-on experience in Microsoft Excel data analysis with uCertify's course Microsoft Excel Data Analysis and Business Modeling. This course is designed for candidates whose job role involves summarizing, reporting, and analyzing data. This course might also involve building analytic models to help your employer increase profits, reduce costs, or manage operations more efficiently. The course contains interactive objective-based lessons with quizzes, flashcards, and labs to give candidates a live experience of working with Excel data analysis and business modeling.

#### Lessons

97+ Lessons | 60+ Exercises | 189+ Quizzes | 111+ Flashcards | 111+ Glossary of terms

#### TestPrep

#### Hand on lab

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

# Here's what you will learn

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

- Answers to this lesson's questions
- Problems

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

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

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

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

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

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

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

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

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

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

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answer to this lesson’s question
- Problems

- Answers to this lesson’s questions
- Problems

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

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Questions answered in this lesson
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s question
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

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

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s question
- Problems

- Answer to this lesson’s question
- Problems

- Answer to this lesson’s question
- Problems

- Answers to this lesson’s questions
- Problems

- Answer to this lesson’s question
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

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

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

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

- Answers to this lesson’s questions
- Problems

- Answer to this lesson’s question
- Problem

- Answers to this lesson’s questions
- Problem

- Answers to this lesson’s questions
- Problems

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

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answer to this lesson’s question
- Problems

- Answer to this lesson’s question
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answer to this lesson’s question
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

- Answers to this lesson’s questions
- Problems

# Hands-on LAB Activities

- Performing Mathematical Calculations using Formulas

- Accumulating Data Using the VLOOKUP Function

- Extracting Data Using the INDEX Function

- Finding the Required Data Using the MATCH Function

- Creating Email Addresses Using the Excel Text Functions

- Calculating the Number of Workdays Using a Date Function

- Computing Annual Sales Using the IF Function

- Calculating Race Timings Using the Time Functions

- Calculating Net Present Value Using the NPV Function

- Determining Depreciation Using Excel Financial Functions

- Using the Paste Special Command to Convert Data

- Summarizing Data Using Three-Dimensional Formulas

- Counting Cells with Criteria Using COUNTIF and COUNTIFS Functions

- Calculating with Criteria Using the COUNTIF and SUMIF Functions

- Creating Bin Ranges Using Histograms

- Summarizing Data

- Consolidating Data

- Creating a Subtotal using the SUBTOTAL Function

- Using the OFFSET Function to Create Lagged Values

- Using the INDIRECT Function to Tabulate Data

- Using Excel Tables to Perform Calculations

- Creating a Scatter Chart

- Creating Sparklines

- Importing Data from a Text File

- Using the Power Query Editor to Transform Data

- Sorting Data

- Performing Calculations Using Array Functions and Formulas

- Creating a PivotTable and PivotChart

- Using the Distinct Count Option for Calculation

- Determining the Profit-Maximizing Product Mix Using Solver

- Finding an Optimal Solution Using Solver

- Obtaining Maximum NPV using Solver

- Determining the Monthly Payment Using Solver

- Solving the Traveling Salesperson Problem

- Creating a Scatter Chart and Adding a Trendline

- Creating an Exponential Trend Curve

- Creating a Power Curve

- Using Correlations to Find the Relationship Between Variables

- Using Multiple Regression to Find the Optimal Forecasting Equation

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

- Computing Binomial Probabilities

- Computing Poisson Distribution

- Calculating Z-Scores

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

- Determining Probability Using the Beta Random Variable

- Creating a Moving Average Graph

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

- Estimating Smoothing Constants

- Simulating the Values of a Normal Random Variable

- Determining the Optimal Bid using Simulation

- Determining Asset Allocation

- Simulating the Outcome of a Sporting Event

- Implementing Resampling

- Creating a Spider Plot

- Using Formula Protection in a Worksheet

- Determining Customer Value

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

- Plotting a Linear Demand Curve

- Finding the Optimal Price Using Subjectively Determined Demand