Главная
Study mode:
on
1
Start
2
Introduction
3
Bar Charts
4
Area Charts
5
Pie and Donut Charts
6
Combo Charts
7
Waterfall Charts
8
Football Field Charts
9
Sparklines
10
Pivot Tables
11
Pivot Charts
12
Sorting and Filtering
13
Regression Analysis
14
Analyze Data
15
Stock Charts
16
Purchase Price Variance
17
Conclusion
Description:
Master advanced Excel techniques for finance and accounting in this comprehensive 58-minute tutorial. Dive into creating various chart types, including bar, area, pie, donut, combo, waterfall, football field, and stock charts. Learn to leverage powerful tools like Sparklines, Pivot Tables, and Pivot Charts for efficient data analysis. Explore sorting, filtering, regression analysis, and data analysis features to enhance financial reporting capabilities. Apply these skills to real-world scenarios, such as income statements, balance sheets, and cash flow statements. Gain proficiency in essential financial functions like NPV, IRR, and IPMT. Perfect for professionals seeking to optimize their Excel workflow and elevate their financial data presentation skills.

Excel for Finance and Accounting - Advanced Tutorial

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