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

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.