Channel | Publish Date | Thumbnail & View Count | Download Video |
---|---|---|---|
Publish Date not found | 0 Views |
Benefit from ad-free training by becoming a member today!
https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join
Exercise files: https://learnitanytime.com/p/exercise-files-excel-for-finance-and-accounting-beginner-tutorial
Who is it for: Professionals using Excel to accomplish practical tasks around financial data.
What it is: Microsoft's spreadsheet used to clean, organize and present data.
What you'll learn: This course begins with a brief refresher on Excel before moving on to a series of financial and accounting tips to improve your daily workflow. First, we'll explore common functions like NPV, IRR, and IPMT. Next, you'll learn how to create a variety of charts to visually represent your data, such as stock charts, area charts, and even soccer field charts. Next, you'll become familiar with some key Excel tools such as pivot tables to maximize your time in the application. Finally, we'll show you how it all works in the real world with comprehensive exercises around income statements, balance sheets, cash flow tables and much more.
Join Learnit Anytime for ad-free training, exams, certificates and exclusive content:
https://www.learnitanytime.com
For private group training, please visit:
https://www.learnit.com/private-group-classes-workshops
Manuals: https://bit.ly/30xZb59
Username: manuals
Password: password
Start 0:00
Presentation 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 share screen 23:38
Quick Access Toolbar and Keyboard Shortcuts 27:16
Basic Functions 31:31
IF Statements 37:03
SUMIF and MOYENNEIF 41:06
LEFT, RIGHT, MIDDLE and Flash Fill 46:26
COUNTIF and COUNTIFS 51:31
Conclusion 56:07
#excel #exceltutorial #exceltips #exceltricks
(C) 2024 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.
Please take the opportunity to connect and share this video with your friends and family if you find it useful.