Course Content
Module 1: Learn to Use Excel Efficiently
Lesson 3: Functions, Relative Addressing and Absolute Addressing, Formulas
0/2
Module 2 : IF Functions and Text Manipulation
Learn how to use IF functions, and to import data from other sources.
0/3
Lesson 7 : Text Manipulations
Learn how to separate continuous data into columns.
0/3
Module 3: Statistical Tools
Lesson 8: Descriptive Statistics
0/1
Lesson 11: Data Analysis Using Statistics Add – In
0/2
Quiz on Module 3
0/1
Module 4: What- if Analysis
Lesson 12 : Naming Cells for Decision Making and Modeling
0/1
Lesson 13: What – if Analysis – Goal Seek
0/2
Lesson 14: What – if Analysis – Data Tables
0/3
Lesson 15: What – if Analysis – Scroll Bars
0/2
Quiz on Module 4
0/1
Module 5: Multipage Systems and Lookups
Module 6: The Data Menu and Ribbon
Lesson 19:Auto Filter
0/1
Lesson 23: Pivot Tables
0/1
Lesson 24: Data Mining using Pivot Tables
0/2
Module 7: Excel Financial Tools
Lesson 25: NPV and IRR – Evaluating Capital Investment
0/2
Lesson 26 : Unconventional Financial Functions – XNPV and XIRR
0/2
Lesson 27: Frequently used Financial Functions
0/4
Lesson 29: Accounting Depreciation Functions
0/1
Quiz on Module 7
0/1
Module 8: Using the Solver Add-In
Lesson 30: Using Solver to go beyond Goal Seek
0/1
Quiz on Module 8
0/1
23091_EXCEL for Business and Finance
0% Complete
×
×

Cart