YoVDO

Excel for Finance and Accounting - Advanced Tutorial

Offered By: Learnit Training via YouTube

Tags

Microsoft Excel Courses Data Analysis Courses Data Visualization Courses Accounting Courses Regression Analysis Courses Financial Analysis Courses Pivot Tables Courses Financial Reporting Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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.

Syllabus

Start
Introduction
Bar Charts
Area Charts
Pie and Donut Charts
Combo Charts
Waterfall Charts
Football Field Charts
Sparklines
Pivot Tables
Pivot Charts
Sorting and Filtering
Regression Analysis
Analyze Data
Stock Charts
Purchase Price Variance
Conclusion


Taught by

Learnit Training

Related Courses

Social Network Analysis
University of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX