This course covers essential Excel topics for accountants, including formulas, functions (IF, SUMIFS, VLOOKUP), PivotTables, Power Query, Flash Fill, and creating various charts. By the end of the course, learners will be able to effectively analyze and manipulate data in Excel, create insightful reports, and enhance their accounting skills. The teaching method involves a comprehensive 2-hour video tutorial with practical demonstrations and examples. This course is designed for accountants or individuals working in the accounting field who want to improve their Excel proficiency and efficiency in data analysis and reporting.
Excel for Accountants - PivotTables, Power Query, IF, SUMIFS, VLOOKUP, Flash Fill, Charts Seminar
ExcelIsFun via YouTube
Overview
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
-
Conditional Formatting, Tables and Charts in Microsoft Excel
-
Microsoft Excel Formulas You Need to Know in 30 Minutes!
-
Microsoft Excel for Beginners: Learn The Essentials in 50 Minutes
-
Create Charts and Dashboards Using Microsoft Excel
-
Excel PRO TIPS Part 1: Productivity
-
Excel at Microsoft Excel - The Complete Beginner to Advanced Excel Mastery Course -
