Get a hands-on experience in Microsoft Excel data analysis with Seven Learning’s course Microsoft Excel Data Analysis and Business Modelling. This course is designed for candidates whose job role involves summarising, reporting and analysing data. This course might also involve building analytic models to help 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 modelling.
Lessons 1: Introduction
- How to use this course?
Lessons 2: Basic worksheet modelling
- Problems
Lessons 3: Range names
- How can I create named ranges?
- Answers to this lesson’s questions
Lessons 4: Lookup functions
- Syntax of the lookup functions
- Answers to this lesson’s questions
Lessons 5: The INDEX function
- Syntax of the INDEX function
Lessons 6: The MATCH function
- Syntax of the MATCH function
Lessons 7: Text functions and Flash Fill
- Text function syntax
Lessons 8: Dates and date functions
Lessons 9: IF, IFERROR, IFS, CHOOSE, SWITCH, and the IS functions
Lessons 10: Time and time functions
Lessons 11: The net present value functions: NPV and XNPV
Lessons 12: The internal rate of return: IRR, XIRR, and MIRR functions
Lessons 13: More Excel financial functions
Lessons 14: Circular references
Lessons 15: The Paste Special command
Lessons 16: Three-dimensional formulas and hyperlinks
Lessons 17: The auditing tool and the Inquire add-in
- Excel auditing options
Lessons 18: Sensitivity analysis with data tables
Lessons 19: The Goal Seek command
Lessons 20: Using the Scenario Manager for sensitivity analysis
Lessons 21: The COUNTIF, COUNTIFS, COUNT, COUNTA and COUNTBLANK functions
Lessons 22: The SUMIF, AVERAGEIF, SUMIFS, AVERAGEIFS, MAXIFS and MINIFS functions
Lessons 23: Summarising data with histograms and Pareto charts
Lessons 24: Summarising data with descriptive statistics
Lessons 25: Summarising data with database statistical functions
Lessons 26: Consolidating data
Lessons 27: Creating subtotals
Lessons 28: The OFFSET function
Lessons 29: The INDIRECT function
Lessons 30: Spin buttons, scrollbars, option buttons, check boxes, combo boxes and group list boxes
Lessons 31: Conditional formatting
Lessons 32: Excel tables and table slicers
Lessons 33: Basic charting
Lessons 34: Advanced charting
Lessons 35: Filled and 3D Maps
Lessons 36: Sparklines
Lessons 37: Importing data from a text file or document
Lessons 38: The Power Query Editor
Lessons 39: Excel’s new data types
Lessons 40: Sorting in Excel
Lessons 41: Filtering data and removing duplicates
Lessons 42: Array formulas and functions
Lessons 43: Excel’s new dynamic array functions
Lessons 44: Validating data
Lessons 45: Importing past stock prices, exchange rates, and cryptocurrency prices with the STOCKHISTORY function
Lessons 46: Using PivotTables and slicers to describe data
Lessons 47: The Data Model
Lessons 48: Power Pivot
Lessons 49: Use Analyse Data to find patterns in your data
Lessons 50: An introduction to optimisation with Excel Solver
Lessons 51: Using Solver to determine the optimal product mix
Lessons 52: Using Solver to schedule your workforce
Lessons 53: Using Solver to solve transportation or distribution problems
Lessons 54: Using Solver for capital budgeting
Lessons 55: Using Solver for financial planning
Lessons 56: Using Solver to rate sports teams
Lessons 57: Warehouse location and the GRG Multistart and Evolutionary Solver engines
Lessons 58: Penalties and the Evolutionary Solver
Lessons 59: The traveling salesperson problem
Lessons 60: Estimating straight-line relationships
Exam FAQs
FAQ's are not Available for this course.Summary
Standard:
MS Excel Data Analysis
Lessons:
97+ Lessons
Delivery Method:
Online
Language:
English