Microsoft Excel Data Analysis and Business Modelling

This Course Includes:

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



MS Excel Data Analysis


97+ Lessons

Delivery Method:




Scroll to Top