Главная
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
18
Introduction
19
Date and Time Functions
20
Data Validation
21
VLOOKUP
22
INDEX and MATCH
23
XLOOKUP
24
Goal Seek and Scenario Manager
25
PV and FV
26
NPV
27
XNOV
28
IRR
29
Loan Schedule with PMT
30
PPMT
31
IPMT
32
CUMIPMT
33
Loan Schedule Templates
34
Conclusion
35
Introduction
36
Bar Charts
37
Area Charts
38
Pie and Donut Charts
39
Combo Charts
40
Waterfall Charts
41
Football Field Charts
42
Sparklines
43
Pivot Tables
44
Pivot Charts
45
Sorting and Filtering
46
Regression Analysis
47
Analyze Data
48
Stock Charts
49
Purchase Price Variance
50
Conclusion
51
Introduction
52
Building Data Rates
53
Calculating HPR Rates of Return
54
Statement Model
55
Income Statements
56
Operating Costs
57
Operating Expenses and Interest
58
Taxes
59
Net Income
60
Capital Expenditure and Depreciation Schedule
61
Setting Up Balance Sheets
62
Balance Sheet Forecasts
63
Cash Flow Statements
64
Statement Model Check
65
Conclusion
Description:
Dive into a comprehensive 4-hour tutorial designed for finance and accounting professionals looking to enhance their Excel skills. Learn essential functions like NPV, IRR, and IPMT, create various charts including stock and football field charts, and master tools such as Pivot Tables to streamline your workflow. Explore practical applications through exercises on income statements, balance sheets, and cash flow statements. Gain proficiency in data analysis, financial modeling, and advanced Excel techniques to boost productivity and effectiveness in handling financial data.

Excel for Finance and Accounting - Full Course Tutorial

Learnit Training
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Visualization #Accounting #Finance #Financial Analysis #Data Analysis #Spreadsheets #Pivot Tables #Financial Accounting #Financial Statements #Financial Modeling
0:00 / 0:00
1 of 65

Start