- CFI Intro
- Welcome
- Table of contents
- Instructor biography
- Key learning objectives
Online
₹ 449 1,999
Quick facts
particular | details | |
---|---|---|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course and certificate fees
Fees information
₹ 449 ₹1,999
certificate availability
Yes
certificate providing authority
Udemy
The syllabus
Introduction
Excel Layout
- Layout overview
- Workbooks, worksheets, cells, & formula bar
- The ribbon
Excel Settings
- Settings overview
- Changing your settings
Basic Financial Analysis Setup
- Objectives
- Format, background, special numbers, column width, freeze panes
- Paste special, font colors, format numbers, sum
- Percentages, fill right, font colors, borders, view gridlines
Advanced Financial Analysis Setup
- Objectives
- Structure, organization, duplicate sheets, grouping
- Anchoring cells, grouping
- Naming cells, tracing precedents & dependents, auditing
- Go to special, conditional formatting
- Dynamic titles & headers
Basic Functions & Formulas
- Objectives
- Date fuctions and time periods
- Sum, average, sumproduct, median
- IF statements
- Rounding and absolute fuctions
- Min, max, small, large
- IFerror, find and replace
Advanced Functions & Formulas
- Objectives
- Scenarios, choose, data validation
- Vlookup, hlookup, index, match
- Data tables and goal seek
- Sumif, countif, if + and
- Xirr and xnpv
Charts & Graphs
- Objectives
- Stacked column and line chart combined
- Waterfall chart (Excel 2016)
- Column, line, and pie charts
Macros
- Objectives
- Recording and using macros to seed up modeling
Wrap Up
- Download completed file and keep practicing