Excel for Finance & Accounting Beginners 📊
Learn Excel basics for finance and accounting in this beginner-friendly tutorial. Join our ad-free training today!

Learn Skills Daily
343.7K views • Mar 1, 2024

About this video
Excel for Finance and Accounting Beginner Tutorial
Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join
Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com
Exercise Files: https://tinyurl.com/rxvb4utb
Who it's for: Professionals using Excel to tackle practical tasks around financial data.
What it is: Microsoft’s spreadsheet application used to clean, organize, and present data.
What you'll learn: This course begins with a brief Excel refresher before moving on to a series of Finance and Accounting tips to improve your day-to-day workflow. First, we’ll explore common functions like NPV, IRR, and IPMT. Then, you’ll learn how to create a variety of charts to visually represent your data like stock charts, area charts, and even football field charts. Next, you’ll refamiliarize yourself with some key Excel tools like Pivot Tables to maximize your time in the application. Finally, we’ll show you how all of this works in the real world with comprehensive exercises around income statements, balance sheets, cash flow statements, and much more.
Start 0:00
Introduction 0:09
Introduction to Excel 1:38
Data Entry Basics 4:14
Rows and Columns 7:12
Open, Save, and Print 9:34
Formatting Basics 12:37
Formatting in Cells 16:35
Conditional Formatting 20:17
Freeze Panes and Split Screen 23:38
Quick Access Toolbar and Keyboard Shortcuts 27:16
Basic Functions 31:31
IF Statements 37:03
SUMIF and AVERAGEIF 41:06
LEFT, RIGHT, MID, and Flash Fill 46:26
COUNTIF and COUNTIFS 51:31
Conclusion 56:07
#excel #exceltutorial #exceltips #exceltricks
Learnit is no longer associated with this channel/video.
(C) 2025 Bomberry Productions
Any illegal reproduction of this content will result in immediate legal action.
Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join
Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com
Exercise Files: https://tinyurl.com/rxvb4utb
Who it's for: Professionals using Excel to tackle practical tasks around financial data.
What it is: Microsoft’s spreadsheet application used to clean, organize, and present data.
What you'll learn: This course begins with a brief Excel refresher before moving on to a series of Finance and Accounting tips to improve your day-to-day workflow. First, we’ll explore common functions like NPV, IRR, and IPMT. Then, you’ll learn how to create a variety of charts to visually represent your data like stock charts, area charts, and even football field charts. Next, you’ll refamiliarize yourself with some key Excel tools like Pivot Tables to maximize your time in the application. Finally, we’ll show you how all of this works in the real world with comprehensive exercises around income statements, balance sheets, cash flow statements, and much more.
Start 0:00
Introduction 0:09
Introduction to Excel 1:38
Data Entry Basics 4:14
Rows and Columns 7:12
Open, Save, and Print 9:34
Formatting Basics 12:37
Formatting in Cells 16:35
Conditional Formatting 20:17
Freeze Panes and Split Screen 23:38
Quick Access Toolbar and Keyboard Shortcuts 27:16
Basic Functions 31:31
IF Statements 37:03
SUMIF and AVERAGEIF 41:06
LEFT, RIGHT, MID, and Flash Fill 46:26
COUNTIF and COUNTIFS 51:31
Conclusion 56:07
#excel #exceltutorial #exceltips #exceltricks
Learnit is no longer associated with this channel/video.
(C) 2025 Bomberry Productions
Any illegal reproduction of this content will result in immediate legal action.
Tags and Topics
Browse our collection to discover more content in these categories.
Video Information
Views
343.7K
Likes
7.5K
Duration
57:06
Published
Mar 1, 2024
User Reviews
4.8
(68)