YoVDO

Excel for Accountants - PivotTables, Power Query, IF, SUMIFS, VLOOKUP, Flash Fill, Charts Seminar

Offered By: ExcelIsFun via YouTube

Tags

Microsoft Excel Courses Data Analysis Courses Power Query Courses PivotTables Courses Flash Fill Courses

Course Description

Overview

Dive into a comprehensive seminar tailored for accountants looking to master essential Excel skills. Learn to create powerful formulas, utilize functions like ROUND, IF, SUMIFS, COUNTIFS, and VLOOKUP, and generate insightful reports. Explore data analysis techniques through PivotTables, including multi-table analysis with Excel 2016's Data Model. Discover time-saving features like Flash Fill, create impactful charts, and harness the power of Power Query for data cleaning and transformation. Perfect your Excel proficiency with hands-on examples and downloadable files to practice and reinforce your learning.

Syllabus

) Introduction.
) Formulas, Cell Reference and Number Formatting Basics.
) ROUND Function.
) IF Function.
) SUMIFS and COUNTIFS Functions.
) VLOOKUP Function.
) VLOOKUP & SUMIFS to create Payroll Report.
) Define Data Analysis and Business Intelligence.
) PivotTables.
) Excel 2016 Data Model PivotTable from Two Different Tables.
) Flash Fill.
) Charts: Column, Bar, Line and X-Y Scatter Charts.
) Power Query to Clean, Transform and Import Data into Excel to we can build a PivotTable Report with Calculated Columns.
) Summary.


Taught by

ExcelIsFun

Related Courses

Introduction to Computational Finance and Financial Econometrics
University of Washington via Coursera
Excel 2010
Miríadax
The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd
Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity
Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard