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
- DIR Discount: 20%
Submit form to obtain discount
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