Excel for Accountants: PivotTables, Power Query, IF, SUMIFS, VLOOKUP, Flash Fill, Charts…CWU Seminar HD

Download Files: Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/CWUDesMoines-StartFile-ExcelForAccountants-April.xlsx FinishedFile:https://people.highline.edu/mgirvin/YouTubeExcelIsFun/CWUDesMoines-FinishedFile-ExcelForAccountants-April.xlsx ZippedFolder: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/CWUAllExcelFiles.zip Page with all Excel files for all videos: http://people.highline.edu/mgirvin/excelisfun.htm 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 X-Y 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