Excel for Financing and Accountancy Complete Program Tutorial (3+ Hours).
Get Ad-Free Training by becoming a participant today!
https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join.
Join Learnit Anytime for ad-free training, examinations, certificates, and special content:.
https://www.learnitanytime.com.
Exercise Files: https://tinyurl.com/rxvb4utb.
Who it’s for: Professionals using Excel to tackle functional tasks around economic information.
What it is: Microsoft’s spreadsheet application made use of to clean, arrange, and existing information.
What you’ll discover: This course begins with a quick Excel refresher course prior to going on to a series of Finance and Accounting ideas to boost your daily operations. First, we’ll explore typical features like NPV, IRR, and IPMT. You’ll learn how to develop a variety of charts to aesthetically represent your information like stock graphes, area graphes, and even football field graphes. Next off, you’ll refamiliarize yourself with some essential Excel tools like Pivot Tables to maximize your time in the application. Lastly, we’ll show you just how every one of this operates in the real life with extensive workouts around earnings statements, annual report, cash money circulation statements, and much more.
Beginning 0:00.
Intro 0:09.
Intro 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.
Standard 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.
Intro 56:46.
Date and Time Functions 57:59.
Data Validation 1:01:35.
VLOOKUP 1:05:52.
INDEX and MATCH 1:10:42.
XLOOKUP 1:17:03.
Objective Seek and Scenario Manager 1:20:58.
PV and FV 1:26:33.
NPV 1:31:26.
XNOV 1:33:01.
IRR 1:35:12.
Car Loan Schedule with PMT 1:38:01.
PPMT 1:40:27.
IPMT 1:43:21.
CUMIPMT 1:46:32.
Car Loan Schedule Templates 1:50:17.
Final thought 1:53:57.
Intro 1:54:58.
Bar Charts 1:55:47.
Area Charts 1:58:38.
Pie and Donut Charts 2:01:38.
Combination Charts 2:04:02.
Waterfall Charts 2:06:20.
Football Field Charts 2:08:43.
Sparklines 2:18:00.
Pivot Tables 2:21:17.
Pivot Charts 2:27:40.
Sorting and Filtering 2:31:26.
Regression Analysis 2:36:30.
Analyze Data 2:44:03.
Supply Charts 2:46:54.
Acquisition Price Variance 2:49:31.
Conclusion 2:51:39.
Intro 2:52:25.
Building Data Rates 2:53:06.
Determining HPR Rates of Return 2:56:10.
Declaration Model 3:02:26.
Earnings Statements 3:04:16.
Running Costs 3:12:53.
Running Expenses and Interest 3:16:44.
Tax obligations 3:18:34.
Earnings 3:20:34.
Capital Investment and Depreciation Schedule 3:23:14.
Setting Up Balance Sheets 3:28:58.
Equilibrium Sheet Forecasts 3:32:20.
Capital Statements 3:46:02.
Statement Model Check 3:56:08.
Final thought 3:58:09.
#excel #exceltutorial #exceltips #exceltricks.
Learnit is no more connected with this channel/video.
( C) 2025 Bomberry Productions.
Any illegal reproduction of this content will result in instant lawsuit.