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

This course teaches Excel skills for accounting workflows, including formulas, conditional and lookup functions, payroll reporting, PivotTables, charts, and Power Query for cleaning and transforming data. It also introduces Data Model PivotTables built from two tables.

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.