Advanced Excel Formulas & Functions offered by Corporate Finance Institute
4.7 /5Advanced Excel Formulas & Functions at CFI Overview
Duration | 6 hours |
Mode of learning | Online |
Credential | Certificate |
Advanced Excel Formulas & Functions at CFI Course details
- INDEX and MATCH
- IF with AND / OR
- OFFSET combined with other functions
- CHOOSE for creating scenarios
- INDIRECT combined with other functions
- XNPV and XIRR
- CELL, COUNTA, and MID functions combined together
- PMT, IPMT, and principal payment calculations
- This advanced Excel course is designed to take Excel users to the next level by illustrating advanced functions and formulas
- Understand how to reference data using INDEX and MATCH
- Manipulate text-string data using functions like RIGHT, CELL, LEN, and FIND
- Apply data analysis tools, like data tables and PivotTables
- Master charting features like creating a gauge chart
Advanced Excel Formulas & Functions at CFI Curriculum
Introduction
Course introduction Free Preview
Learning objectives Free Preview
Download Excel files and course notes
Excel Template Setup
Template setup learning objectives Free Preview
Dynamic dates and time periods with IF statements Free Preview
IF statement exercise Free Preview
Dynamic totals and averages with the OFFSET function Free Preview
OFFSET function exercise
Scenarios with the VLOOKUP and CHOOSE functions
Dynamic outputs with IF statements
Template formatting
Interactive exercise 1
Financial Statements
Financial statements learning objectives
Debt schedule with PMT, IPMT, and IF functions
PMT and IPMT function exercise
XNPV and XIRR with DATE and IF functions
Adding OFFSET to XNPV and XIRR
XNPV and XIRR function exercise
Formatting with sections and grouping
Financial Analysis
Financial analysis learning objectives
Summary data with VLOOKUP
INDEX function
MATCH function
INDEX MATCH MATCH
Goal seek (what-if analysis)
Dynamic totals with INDIRECT and SUM functions
Interactive exercise 2
CELL function
COUNT and COUNTA functions
Creating table of contents with CELL function
RIGHT, CELL, LEN, and FIND functions
Combining RIGHT, CELL, LEN, and FIND
Combining IF with AND, OR formulas
Interactive exercise 3
Tables
Tables in Excel learning objectives
Download pivot table files
Setting up a data table
Linking and formatting the data table
Setting up a pivot table
Pivot table field settings
Pivot table filters
Pivot table calculated fields
Pivot table slicer and timeline
Interactive exercise 4
Charts
Charts in Excel learning objectives
Combination column and line charts
Stacked column chart
IFERROR function
Dynamic charts
Dynamic charts continued
Learn more about charts
Additional Resource: Waterfall chart template download
Interactive exercise 5
Macros
Macros learning objectives
Recording macros
Form control
Interactive exercise 6
Final Product
Review of the final product
Download the final product
Summary
Qualified Assessment
Qualified assessment
Other courses offered by CFI
Student Forum
Anything you would want to ask experts?
Advanced Excel Formulas & Functions at CFI Contact Information
2E/25, Jhandewalan Extension, Block E 2, Jhandewalan, Delhi,
New Delhi
Delhi - Other ( Delhi)