Module 1: Learn to Use Excel Efficiently

Lesson 1: AutoFill

Lesson 2: How to make a selection in Excel

Lesson 3: Functions, Relative Addressing and Absolute Addressing, Formulas

Lesson 4: Naming Cells

Lesson 5:Charts

Quiz on Module 1

Module 2 : IF Functions and Text Manipulation?

Learn how to use IF functions, and to import data from other sources.

Lesson 6: IF Functions

Lesson 7 : Text Manipulations?

Learn how to separate continuous data into columns.

Quiz on Module 2

Module 3: Statistical Tools

Lesson 8: Descriptive Statistics

Lesson 9: Frequency Distributions

Lesson 10: Statistical Regression

Lesson 11: Data Analysis Using Statistics Add – In

Quiz on Module 3

Module 4: What- if Analysis

Lesson 12 : Naming Cells for Decision Making and Modeling

Lesson 13: What – if Analysis – Goal Seek

Lesson 14: What – if Analysis – Data Tables

Lesson 15: What – if Analysis – Scroll Bars

Quiz on Module 4

Module 5: Multipage Systems and Lookups

Lesson 16: Multi-Page Budgets

Lesson 17: Lookup Tables

Quiz on Module 5

Module 6: The Data Menu and Ribbon

Lesson 18: Sorting Data

Lesson 19:Auto Filter

Lesson 20: Data Forms

Lesson 21: Group and Outline Data

Lesson 22: Subtotals

Lesson 23: Pivot Tables

Lesson 24: Data Mining using Pivot Tables

Quiz on Module 6

Module 7: Excel Financial Tools

Lesson 25: NPV and IRR – Evaluating Capital Investment

Lesson 26 : Unconventional Financial Functions – XNPV and XIRR

Lesson 27: Frequently used Financial Functions

Lesson 28: Amortization Tables

Lesson 29: Accounting Depreciation Functions

Quiz on Module 7

Module 8: Using the Solver Add-In

Lesson 30: Using Solver to go beyond Goal Seek

Lesson 31: The Solve Add-In Optimizer

Quiz on Module 8

Final Assessment

Course Evaluation

Certificate

Module 1 : Lesson 2 – Selection Shortcuts
×
×

Cart