Главная
Study mode:
on
1
) Introduction
2
) Formulas, Cell Reference and Number Formatting Basics
3
) ROUND Function
4
) IF Function
5
) SUMIFS and COUNTIFS Functions
6
) VLOOKUP Function
7
) VLOOKUP & SUMIFS to create Payroll Report
8
) Define Data Analysis and Business Intelligence
9
) PivotTables
10
) Excel 2016 Data Model PivotTable from Two Different Tables
11
) Flash Fill
12
) Charts: Column, Bar, Line and X-Y Scatter Charts
13
) Power Query to Clean, Transform and Import Data into Excel to we can build a PivotTable Report with Calculated Columns
14
) Summary
Description:
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.

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

ExcelIsFun
Add to list
#Business #Business Software #Microsoft Office 365 #Microsoft Excel #Data Science #Data Analysis #Business Intelligence #Power Query #Spreadsheets #PivotTables #Flash Fill
0:00 / 0:00
1 of 14

) Introduction