Generic filters
Exact matches only
Search in title
Search in content
Search in excerpt

Microsoft Excel Data Analysis and Business Modeling

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.
NameBuy
Microsoft Excel Data Analysis and Business Modeling
Test Prep
60+ Pre Assessment Questions | 2+ Full Length Tests | 60+ Post Assessment Questions | 120+ Practice Test Questions
Features
60+ LiveLab | 60+ Video tutorials | 02:12+ Hours

Why choose TOPTALENT?

Outline

Lessons 1:
Introduction

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

Lessons 2:
Basic worksheet modeling

  • Answers to this lesson’s questions
  • Problems

Lessons 3:
Range names

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

Lessons 4:
Lookup functions

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

Lessons 5:
The INDEX function

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

Lessons 6:
The MATCH function

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

Lessons 7:
Text functions and Flash Fill

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

Lessons 8:
Dates and date functions

  • Answers to this lesson’s questions
  • Problems

Lessons 9:
IF, IFERROR, IFS, CHOOSE, SWITCH, and the IS functions

  • Answers to this lesson’s questions
  • Problems

Lessons 10:
Time and time functions

  • Answers to this lesson’s questions
  • Problems

Lessons 11:
The net present value functions: NPV and XNPV

  • Answers to this lesson’s questions
  • Problems

Lessons 12:
The internal rate of return: IRR, XIRR, and MIRR functions

  • Answers to this lesson’s questions
  • Problems

Lessons 13:
More Excel financial functions

  • Answers to this lesson’s questions
  • Problems

Lessons 14:
Circular references

  • Answers to this lesson’s questions
  • Problems

Lessons 15:
The Paste Special command

  • Answers to this lesson’s questions
  • Problems

Lessons 16:
Three-dimensional formulas and hyperlinks

  • Answers to this lesson’s questions
  • Problems

Lessons 17:
The auditing tool and the Inquire add-in

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

Lessons 18:
Sensitivity analysis with data tables

  • Answers to this lesson’s questions
  • Problems

Lessons 19:
The Goal Seek command

  • Answers to this lesson’s questions
  • Problems

Lessons 20:
Using the Scenario Manager for sensitivity analysis

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

Lessons 21:
The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions

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

Lessons 22:
The SUMIF, AVERAGEIF, SUMIFS, AVERAGEIFS, MAXIFS, and MINIFS functions

  • Answers to this lesson’s questions
  • Problems

Lessons 23:
Summarizing data with histograms and Pareto charts

  • Answers to this lesson’s questions
  • Problems

Lessons 24:
Summarizing data with descriptive statistics

  • Answers to this lesson’s questions
  • Problems

Lessons 25:
Summarizing data with database statistical functions

  • Answers to this lesson’s questions
  • Problems

Lessons 26:
Consolidating data

  • Answer to this lesson’s question
  • Problems

Lessons 27:
Creating subtotals

  • Answers to this lesson’s questions
  • Problems

Lessons 28:
The OFFSET function

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

Lessons 29:
The INDIRECT function

  • Answers to this lesson’s questions
  • Problems

Lessons 30:
Spin buttons, scrollbars, option buttons, check boxes, combo boxes, and group list boxes

  • Answers to this lesson’s questions
  • Problems

Lessons 31:
Conditional formatting

  • Answers to this lesson’s questions
  • Problems

Lessons 32:
Excel tables and table slicers

  • Answers to this lesson’s questions
  • Problems

Lessons 33:
Basic charting

  • Answers to this lesson’s questions
  • Problems

Lessons 34:
Advanced charting

  • Answers to this lesson’s questions
  • Problems

Lessons 35:
Filled and 3D Maps

  • Questions answered in this lesson
  • Problems

Lessons 36:
Sparklines

  • Answers to this lesson’s questions
  • Problems

Lessons 37:
Importing data from a text file or document

  • Answers to this lesson’s question
  • Problems

Lessons 38:
The Power Query Editor

  • Answers to this lesson’s questions
  • Problems

Lessons 39:
Excel’s new data types

  • Answers to this lesson’s questions
  • Problems

Lessons 40:
Sorting in Excel

  • Answers to this lesson’s questions
  • Problems

Lessons 41:
Filtering data and removing duplicates

  • Answers to this lesson’s questions
  • Problems

Lessons 42:
Array formulas and functions

  • Answers to this lesson’s questions
  • Problems

Lessons 43:
Excel’s new dynamic array functions

  • Answers to this lesson’s questions
  • Problems

Lessons 44:
Validating data

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

Lessons 45:
Importing past stock prices, exchange rates, and…tocurrency prices with the STOCKHISTORY function

  • Answers to this lesson’s questions
  • Problems

Lessons 46:
Using PivotTables and slicers to describe data

  • Answers to this lesson’s questions
  • Problems

Lessons 47:
The Data Model

  • Answers to this lesson’s questions
  • Problems

Lessons 48:
Power Pivot

  • Answers to this lesson’s questions
  • Problems

Lessons 49:
Use Analyze Data to find patterns in your data

  • Answers to this lesson’s questions
  • Problems

Lessons 50:
An introduction to optimization with Excel Solver

  • Answers to this lesson’s questions
  • Problems

Lessons 51:
Using Solver to determine the optimal product mix

  • Answers to this lesson’s questions
  • Problems

Lessons 52:
Using Solver to schedule your workforce

  • Answers to this lesson’s question
  • Problems

Lessons 53:
Using Solver to solve transportation or distribution problems

© 2024 TOPTALENT LEARNING.