Preview
0/3
Module 1: Learn to Use Excel Efficiently
Lesson 1: AutoFill
0/4
Lesson 2: How to make a selection in Excel
0/4
Lesson 3: Functions, Relative Addressing and Absolute Addressing, Formulas
0/2
Lesson 4: Naming Cells
0/4
Lesson 5:Charts
0/3
Quiz 1 (25 Marks)
0/1
Module 2 : IF Functions and Text Manipulation
Learn how to use IF functions, and to import data from other sources.
0/3
Lesson 6: IF Functions
0/4
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 9: Frequency Distributions
0/2
Lesson 10: Statistical Regression
0/2
Lesson 11: Data Analysis Using Statistics Add – In
0/2
Quiz on Module 2
0/1
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
Lesson 16: Multi-Page Budgets
0/2
Lesson 17: Lookup Tables
0/2
Quiz on Module 5
0/1
Module 6: The Data Menu and Ribbon
Lesson 18: Sorting Data
0/2
Lesson 19:Auto Filter
0/1
Lesson 20: Data Forms
0/2
Lesson 21: Group and Outline Data
0/2
Lesson 22: Subtotals
0/3
Lesson 23: Pivot Tables
0/1
Lesson 24: Data Mining using Pivot Tables
0/2
Quiz on Module 6
0/1
Module 7: Excel Financial Tools
Lesson 26 : Unconventional Financial Functions – XNPV and XIRR
0/2
Lesson 27: Frequently used Financial Functions
0/4
Lesson 28: Amortization Tables
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
Lesson 31: The Solve Add-In Optimizer
0/2
Quiz on Module 8
0/1
Final Assessment
0/6
Course Evaluation
0/3
Certificate
0/1