July 22, 2017
Products Excel Wiz

Excel Wiz: Spreadsheet Modeling Course

Excel Wiz introduces the tools and techniques for data analysis, reporting, and presentation. The course begins with an in-depth overview of Microsoft Excel 2010 and concludes by demonstrating how to formulate robust spreadsheet models for managerial decision-making. A broad range of tools such as Charts, Excel Solver, Goal Seek, Pivot Table, and Monte Carlo Simulation are covered. 

logo-login

The course prepares MBA students and business managers to move beyond basic “point and click skills” to leverage the full potential of Excel for solving day-to-day business problems.

Topics are explained with the help of narrated video exercises that keep learners engaged in the course and help them grasp difficult concepts quickly. Downloadable Excel worksheets are included to assist students as they work through the subject matter. The seat time of this course is 16 to 20 hours, depending on the learner’s experience with the material. Excel Wiz is a SaaS based course hosted on SCORM Cloud. It provides detailed analytics for tracking learner progress. 

See complete overview | Contact This e-mail address is being protected from spambots. You need JavaScript enabled to view it for a demo. 


Course Overview

Excel Environment (Basic)
Excel Workbooks | Tabs and Ribbons | Quick Access Toolbar | Manipulating Worksheets | Backstage View & Excel Options | Shortcuts | Printing and Saving
Basic Data Manipulation (Basic)
Cells and Ranges | Moving Around and Selecting | Range Names | Go To Options | Cut, Copy, Paste, and Undo | Status Bar | Filling Series
Increasing Spreadsheet Readability (Basic)
Working with Rows and Columns | Basic Cell Formatting | Number Formatting | Custom Formatting | Date Formatting | Other Formatting Options
Excel Formulas (Basic)
Entering and Viewing a Formula | Entering Formulas by Pointing | Basic Arithmetic Operations | Using Functions in Formulas | Using Range Names in Formulas | AutoComplete Feature | External Formula References | Copying Formulas | AutoSum | Absolute and Mixed Cell References | F4 Key & Array Formulas | Viewing All Formulas | Order of Mathematical Operations
Excel Functions (Advanced)
Summary Functions (SUM, PRODUCT, COUNT etc.) | IF Function | Conditional Summary Functions (COUNTIF, SUMIF, etc.) | Lookup Functions | Reference Functions (INDEX, MATCH) | Math Functions (INT, ROUND, ABS etc.) | Random Functions | Text Functions | Date and Time Functions | Financial Functions | Statistical Functions 
Other Useful Features (Basic)
3-Dimensional Formulas | Sorting, Filtering, & Removing Duplicates | Error Handling
Conditional Formatting (Advanced)
Using Cell Values | Identifying Duplicates | Top/Bottom Rules | Using Formulas | Using Icon Sets | Using Bars and Scales | Managing Rules
Tools for Analyzing Data (Advanced)
Excel Tables | Pivot Tables and Charts | Subtotals 
Importing External Data (Advanced)
From Text Files | From Word Documents | Using Web Queries | Dynamic Web Queries  
Excel Charts (Basic)
Creating A Chart | Basic Chart Formatting | Formatting Axes and Data Series | Customizing Charts
Spreadsheet Modeling (Advanced)
Simple Calculations vs. Models | Types of Models | Approach to Spreadsheet Modeling | Model Building Blocks | Relationship Tree | Setting up a Spreadsheet Model: New Mall Construction | Sensitivity Analysis using Data Tables & Goal Seek | Evaluate Formula Feature (F9) | Scenario Analysis | Spinners | Model Limitations | Good Practices 
Excel Solver (Advanced)
Parts of an Optimization Model | Types of Constraints | Defining the Objective | Solver Add-in | Developing the Model | Configuring and Running Solver | Feasible Solution
Monte Carlo Simulation (Advanced)
Deterministic vs. Stochastic Risk Analysis | Probability Distributions | Choosing the Right Distribution | Example: Launching a New Product | Monte Carlo Simulation using @RISK Add-in | Output Analysis