Course Content
Preview
0/3
Module 1 : Lesson 1 – Autofill Options and Right Drag Autofill
08:05
Module 1 : Lesson 2 – Selection Shortcuts
09:09
Module 1 : Lesson 5 – Working with 3D Charts
03:30
Module 1: Learn to Use Excel Efficiently
Lesson 1: AutoFill
0/4
Introduction to AutoFill and Customs List
05:19
Illustration For AutoFill
06:18
Create Customs List
05:24
AutoFill Options and Right Drag AutoFill
08:05
Lesson 2: How to make a selection in Excel
0/4
Selecting an Entire Sheet
05:26
Selecting a Section
01:53
Selection Shortcuts
09:10
Extend and Add Mode
10:58
Lesson 3: Functions, Relative Addressing and Absolute Addressing, Formulas
0/2
Formulas, Relative and Absolute Addressing
17:19
Other Functions
08:08
Lesson 4: Naming Cells
0/4
Naming a Single Cell
06:34
Naming a Range of Cells
07:36
Naming a Range of Cells – Example
07:22
Name Menu and Name Manager
12:13
Lesson 5:Charts
0/3
Creation of Charts
08:58
Formatting of Charts
03:36
Working with 3D Charts
05:22
Quiz on Module 1
0/1
Learn to Use Excel Efficiently
51:00
Module 2 : IF Functions and Text Manipulation
Learn how to use IF functions, and to import data from other sources.
0/3
Draft Lesson
Draft Lesson
Draft Lesson
Lesson 6: IF Functions
0/4
Simple IF Functions
14:03
Simple IF Function Example
12:24
Nested IF Functions
07:52
Nested IF Function Example
08:47
Lesson 7 : Text Manipulations
Learn how to separate continuous data into columns.
0/3
Text to Column Wizard
06:59
Opening Text Files
05:45
Example
05:33
Quiz on Module 2
0/1
IF Functions and Text Manipulation
21:00
Module 3: Statistical Tools
Lesson 8: Descriptive Statistics
0/1
Calculating Descriptive Statistics
14:18
Lesson 9: Frequency Distributions
0/2
Frequency Distribution Tables
09:00
Frequency Distribution Charts
06:00
Lesson 10: Statistical Regression
0/2
Regression Using Scatter Chart
04:29
Linear Regression using Excel Functions
07:17
Lesson 11: Data Analysis Using Statistics Add – In
0/2
Descriptive Statistics
08:30
Frequency Distribution using Histogram
03:35
Quiz on Module 3
0/1
Statistical Tools
24:00
Module 4: What- if Analysis
Lesson 12 : Naming Cells for Decision Making and Modeling
0/1
Naming Cells – for Decision Making and Modeling
13:00
Lesson 13: What – if Analysis – Goal Seek
0/2
Goal Seek
17:38
Goal Seek – Example
17:37
Lesson 14: What – if Analysis – Data Tables
0/3
One way Data Table
10:25
Two way Data Table
03:54
Example
06:45
Lesson 15: What – if Analysis – Scroll Bars
0/2
Scroll Bars
16:31
Scroll Bars (Continuation)
02:27
Quiz on Module 4
0/1
What-if Analysis
24:00
Module 5: Multipage Systems and Lookups
Lesson 16: Multi-Page Budgets
0/2
Multidimensional Excel Workbook
06:11
Summary Sheet
03:37
Lesson 17: Lookup Tables
0/2
Exact Match Lookup
04:04
Approximate Match Lookup
04:54
Quiz on Module 5
0/1
Multi-Page Budgets and Lookup Tables
12:00
Module 6: The Data Menu and Ribbon
Lesson 18: Sorting Data
0/2
Sorting Data
10:41
Custom List for Sorting Data
03:26
Lesson 19:Auto Filter
0/1
Auto Filter
10:07
Lesson 20: Data Forms
0/2
Data Form Activation
03:38
Working with Data Forms
03:17
Lesson 21: Group and Outline Data
0/2
Grouping and Outlining Data
06:13
Clearing Outline
01:18
Lesson 22: Subtotals
0/3
Applying Subtotal to Single Data
06:53
Applying Subtotal to Multiple Categories
06:53
Copying Grouped Data
06:53
Lesson 23: Pivot Tables
0/1
Pivot Tables
06:53
Lesson 24: Data Mining using Pivot Tables
0/2
3D Column Chart in Pivot Table
06:53
Grouping Data
06:53
Quiz on Module 6
0/1
The Data Menu and Ribbon
39:00
Module 7: Excel Financial Tools
Lesson 25: NPV and IRR – Evaluating Capital Investment
0/2
NPV
09:21
IRR
04:58
Lesson 26 : Unconventional Financial Functions – XNPV and XIRR
0/2
XNPV
06:49
XIRR
03:27
Lesson 27: Frequently used Financial Functions
0/4
PMT
04:34
PV & FV
04:34
NPER
04:21
RATE
03:04
Lesson 28: Amortization Tables
0/4
Monthly Payment Loan – PMT
03:36
Amortization date – Month and Payment Date
04:39
PPMT – Principal
04:34
Amortization Table – Balance, CUMIPMT, CUMPRINC
04:34
Lesson 29: Accounting Depreciation Functions
0/1
Depreciation
11:28
Quiz on Module 7
0/1
Excel Financial Tools
30:00
Module 8: Using the Solver Add-In
Lesson 30: Using Solver to go beyond Goal Seek
0/1
Using Solver to overcome the limitations of Goal Seek
19:42
Lesson 31: The Solve Add-In Optimizer
0/2
Solver Add-In – Optimizer (Linear Example)
17:55
Solver Add-In – Optimizer (Non-Linear Example)
12:40
Quiz on Module 8
0/1
Using Solver Add-In
12:00
Final Assessment
0/6
Final Assessment (Read the description here before attempting quiz)
Part 1 (10 Questions)
36:00
Part 2 (10 Questions)
36:00
Part 3 (10 Questions)
36:00
Part 4 (10 Questions)
36:00
Part 5 (10 Questions)
36:00
Course Evaluation
0/3
Feedback
M.Com (Finance and Analytics)
01:55
Share
Certificate
0/1
How to download certificate?
EXCEL for Business and Finance – Batch 2
Previous
Next
0% Complete
×
×

Cart