Download Files:
Start File: https://people.highline.edu/mgirvin/Y...
FinishedFile:https://people.highline.edu/mgirvin/Y...
ZippedFolder: https://people.highline.edu/mgirvin/Y...
Page with all Excel files for all videos: http://people.highline.edu/mgirvin/ex...
This is a complete 2 ½ hour video about all the Excel topics you need to become awesome with Excel in the Accounting Field. Here is the list of topics:
1. (00:01) Introduction
2. (01:45) Formulas, Cell Reference and Number Formatting Basics
3. (09:50) ROUND Function
4. (16:34) IF Function
5. (29:19) SUMIFS and COUNTIFS Functions
6. (40:15) VLOOKUP Function
7. (56:47) VLOOKUP & SUMIFS to create Payroll Report
8. (01:00:11) Define Data Analysis and Business Intelligence
9. (01:04:24) PivotTables
10. (01:28:46) Excel 2016 Data Model PivotTable from Two Different Tables
11. (01:36:18) Flash Fill
12. (01:42:29) Charts: Column, Bar, Line and XY Scatter Charts
13. (02:03:00) Power Query to Clean, Transform and Import Data into Excel to we can build a PivotTable Report with Calculated Columns
14. (02:20:58) Summary