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

- Price: $279.99
- Delivery Method: eLearning

Name | Buy |
---|---|

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?

- Get assistance every step of the way from our Texas-based team, ensuring your training experience is hassle-free and aligned with your goals.
- Access an expansive range of over 3,000 training courses with a strong focus on Information Technology, Business Applications, and Leadership Development.
- Have confidence in an exceptional 95% approval rating from our students, reflecting outstanding satisfaction with our course content, program support, and overall customer service.
- Benefit from being taught by Professionally Certified Instructors with expertise in their fields and a strong commitment to making sure you learn and succeed.

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