$11 $
This course is divided in to seven parts alongside with 25 Short on-demand video.
PDFs/eBook downloadable resources
Quis
Assignments
Full lifetime access 
Access on mobile and TV 
Certificate of Completion

Level

All Levels

Level

Time to Complete

5 hours 0 minute

Lessons

10 Lessons

Language

English

Rating

(

0 Review

)

Updated:

Oct 21, 2025

Excel Crash Course for Financial Professionals

Excel Crash Course for Financial Professionals

Remember, practice is key to mastering Excel. Apply these concepts to real financial data to enhance your skills. Additionally, explore online resources and tutorials for deeper understanding and advanced techniques.

This course is broken in to seven parts:

1. Introduction to Excel in Financial Analysis

  • Introduction
  • Key Learning Objectives
  • Course Objectives
  • Keyboard Over Mouse

2. Excel Layout

  • Introduction to Excel layout (Objectives)
  • Excel Workbook
  • Excel Layout Canvas (Inserts & Keyboard Shortcuts

3. Excel Settings

  • Introduction (Objectives)
  • General Settings
  • Formulas Settings
  • Data Settings
  • Advance Settings
  • Add-ins

4. Basic Financial Analysis Setup

  • Key Learning Objectives (Introduction)
  • Page Layout
  • Financial Analysis
  • Formatting
  • Assumptions and Forecast

5. Advance Financial Analysis Setup

  • Introduction (Objectives)
  • Financial Analysis Setup
  • Income Statement Analysis
  • Trace Precedents Dependents
  • Audit a Model
  • Dynamic Headings

6. Functions and Formulas in Excel

  • Introduction (Session Overview)
  • Today Function
  • Cost Analysis
  • If Statements
  • Rounding Numbers
  • Handling Error Messages
  • Find and Replace Functions

7. Summary

8. Final Quiz

Enrolled by

0 student

What You’ll Learn?

Remember, practice is key to mastering Excel. Apply these concepts to real financial data to enhance your skills. Additionally, explore online resources and tutorials for deeper understanding and advanced techniques.
What you will Learn;
Introduction to Excel in Financial Analysis
Introduction
Key Learning Objectives
Course Objectives
Keyboard Over Mouse
Excel Layout
Introduction to Excel layout (Objectives)
Excel Workbook
Excel Layout Canvas (Inserts & Keyboard Shortcuts
Excel Settings
Introduction (Objectives)
General Settings
Formulas Settings
Data Settings
Advance Settings
Addins
Basic Financial Analysis Setup
Key Learning Objectives (Introduction)
Page Layout
Financial Analysis
Formatting
Assumptions and Forecast
Advance Financial Analysis Setup
Introduction (Objectives)
Financial Analysis Setup
Income Statement Analysis
Trace Precedents Dependents
Audit a Model
Dynamic Headings
Functions and Formulas in Excel
Introduction (Session Overview)
Today Function
Cost Analysis
If Statements
Rounding Numbers
Handling Error Messages
Find and Replace Functions
Summary
Final Quiz
BONUS RESOURCES (PDFs and eBooks)

Course Syllabus

Introduction to Excel in Financial Analysis

3 min 1 Lesson 0 Quiz

Excel Layout

13 min 3 Lessons 1 Quiz

Excel Settings

10 min 1 Lesson 0 Quiz

Basic Financial Analysis Setup in Excel

18 min 5 Lessons 0 Quiz

Certification

Choose from a list of project topics or create your own project idea that incorporates all skills learned (e.g., a mini-banking system, personal expense tracker, or inventory manager).

Meet Your Instructor

G-Designs Academy
0.0
G-Designs Academy

Student Review

0

(

0 review

)

5 stars
0 Rating
4 stars
0 Rating
3 stars
0 Rating
2 stars
0 Rating
1 star
0 Rating

Similar Courses

10 $15 $
11 $18 $
10 $16 $
$11 $
This course is divided in to seven parts alongside with 25 Short on-demand video.
PDFs/eBook downloadable resources
Quis
Assignments
Full lifetime access 
Access on mobile and TV 
Certificate of Completion

Level

All Levels

Time to Complete

5 hours 0 minute

Lessons

10 Lessons

Language

English

Rating

(

0 Review

)

0
trial

Start your journey with free trial

Interactive courses designed to take your skills to the next level, anytime, anywhere

Want to receive push notifications for all major on-site activities?