Главная
Study mode:
on
1
Start
2
Introduction
3
Introduction to Excel
4
Data Entry Basics
5
Rows and Columns
6
Open, Save, and Print
7
Formatting Basics
8
Formatting in Cells
9
Conditional Formatting
10
Freeze Panes and Split Screen
11
Quick Access Toolbar and Keyboard Shortcuts
12
Basic Functions
13
IF Statements
14
SUMIF and AVERAGEIF
15
LEFT, RIGHT, MID, and Flash Fill
16
COUNTIF and COUNTIFS
17
Conclusion
Description:
Master essential Excel skills for finance and accounting in this comprehensive 57-minute beginner tutorial. Begin with a quick Excel refresher before diving into finance-specific functions like NPV, IRR, and IPMT. Learn to create various charts including stock, area, and football field charts to visually represent financial data. Explore key Excel tools such as Pivot Tables to streamline your workflow. Apply your new skills to real-world scenarios involving income statements, balance sheets, and cash flow statements. Cover topics ranging from basic data entry and formatting to advanced functions like IF statements, SUMIF, AVERAGEIF, and COUNTIF. Gain practical knowledge on using LEFT, RIGHT, MID functions, and Flash Fill for efficient data manipulation. Perfect for professionals looking to enhance their Excel proficiency in finance and accounting tasks.

Excel for Finance and Accounting - Beginner Tutorial

Learnit Training
Add to list
0:00 / 0:00