Microsoft Excel Data Analysis and Business Modeling
(XLSDABM.AB1)
/ ISBN: 9781644593684
Microsoft Excel Data Analysis and Business Modeling
Get a handson 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 objectivebased lessons with quizzes, flashcards, and labs to give candidates a live experience of working with Excel data analysis and business modeling.
Lessons

97+ Lessons

300+ Exercises

189+ Quizzes

111+ Flashcards

111+ Glossary of terms
TestPrep

60+ Pre Assessment Questions

4+ Full Length Tests

240+ Practice Test Questions
LiveLab

60+ LiveLab

60+ Video tutorials

02:12+ Hours
 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 Activities (Live Labs)
 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 ThreeDimensional 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 ProfitMaximizing 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 ZScores
 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 RatiotoMovingAverage 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
×