Excel for Finance and Accounting Full Course Tutorial (3+ Hours)
ฝัง
- เผยแพร่เมื่อ 2 มิ.ย. 2024
- Excel for Finance and Accounting Full Course Tutorial (3+ Hours)
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Exercise Files: learnitanytime.com/p/exercise...
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.
Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
www.learnitanytime.com
For Private Group Trainings please visit:
www.learnit.com/private-group...
Manuals: bit.ly/30xZb59
Username: manuals
Password: password
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
Introduction 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
Goal 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
Loan Schedule with PMT 1:38:01
PPMT 1:40:27
IPMT 1:43:21
CUMIPMT 1:46:32
Loan Schedule Templates 1:50:17
Conclusion 1:53:57
Introduction 1:54:58
Bar Charts 1:55:47
Area Charts 1:58:38
Pie and Donut Charts 2:01:38
Combo 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
Stock Charts 2:46:54
Purchase Price Variance 2:49:31
Conclusion 2:51:39
Introduction 2:52:25
Building Data Rates 2:53:06
Calculating HPR Rates of Return 2:56:10
Statement Model 3:02:26
Income Statements 3:04:16
Operating Costs 3:12:53
Operating Expenses and Interest 3:16:44
Taxes 3:18:34
Net Income 3:20:34
Capital Expenditure and Depreciation Schedule 3:23:14
Setting Up Balance Sheets 3:28:58
Balance Sheet Forecasts 3:32:20
Cash Flow Statements 3:46:02
Statement Model Check 3:56:08
Conclusion 3:58:09
#excel #exceltutorial #exceltips #exceltricks
(C) 2024 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.
![[TH] 2024 PMSL SEA GF D2 | Summer | ร่วมส่งแรงใจ เชียร์ไทยไปพร้อมกัน](http://i.ytimg.com/vi/dN2gLsCJ0T0/mqdefault.jpg)
Exercise Files: learnitanytime.com/p/exercise-files-excel-for-finance-and-accounting-full-course-tutorial
Good
This course only of 3 hours but it took me 2days to complete every topic is explained in detail and easy manner
Congrats on finishing the course!
Thank you so much for your generosity. I'm refreshing my Excel knowledge and this helped me a lot. God bless.
You're very welcome!
It's absolutely amazing. Thank you!
You are very welcome!
You are awesome, guys! Can you make tutorials for Excel data analysis?
Here you go: th-cam.com/video/UeJWCqJysKI/w-d-xo.html
@@LearnitTraining Thank youuu 🤗
Great video, thanks for sharing!
Thanks for watching!
Thank you.
You're welcome!
Thank you so much for the free course, please can you please make a video on bookkeeping course? Thank you and God bless
We will look into it!
Question. Based on 1st year Accounts receivable assumptions it should be 1,522,500@5%= P76,125 but it became 130,000 in the final. What happened? Thanks.
The Great course to be free my God🎉
You are welcome!
Just started and learning so much, can you provide more playlist regarding excel formulas and how to insert exchange rates conversion
I'm looking for a way to creat a sheet that calculates landing cost and calculate currencies, Thanks,
Great suggestion!
@@LearnitTraining pls tag me once you do a video. I really I’m eager to learn the formulas
Can u make budget
Dear Sir/madam how may I get worksheets in Excel on my computer from internet?
learnitanytime.com/p/exercise-files-excel-for-finance-and-accounting-full-course-tutorial
any after effect coure availabe in your channel sir
We are working on it!
@@LearnitTraining ok
How is this all free!? crazy!!!
You are welcome!
2:58
These are not full lecture, isn't it ?
This is the full course for Excel for Finance and Accounting.
The Great course to be free my God🎉