Excel Data Analysis: Sort, Filter, PivotTable, Formulas (25 Examples): HCC Professional Day 2012

https://youtube.com/watch?v=i5WiYh2jmG8Download files: Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/HCC-PD-2012-Start%20File%20-%20Excel%202010%20Basics%20Data%20Analysis%20PDD.xlsm Excel Finished File (after video filmed): https://people.highline.edu/mgirvin/YouTubeExcelIsFun/HCC-PD-2012-Finished%20File%20-%20Excel%202010%20Basics%20Data%20Analysis%20PDD.xlsm Access file: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/HCC-PD-2012-StudentData.accdb Text File (Right-click, Save As): https://people.highline.edu/mgirvin/YouTubeExcelIsFun/HCC-PD-2012-StudentData.txt Learn the basics of Data Analysis at Highline…

Continue Reading

Excel for Accounting: Formulas, VLOOKUP & INDEX, PivotTables, Recorded Macros, Charts, Keyboards

https://youtube.com/watch?v=kNaxTNSAtLkDirect links to file: START FILE: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/E%20W%20T%20M%20Accounting%20Excel%20Seminar-StartFileSoYouCanFollowAlong.xlsx FINISHED FILE: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/E%20W%20T%20M%20Accounting%20Excel%20SeminarAllFinishedExamplesAfterVideoDone.xlsm Keyboards 0:01:47 Jump: Ctrl + Arrow 0:02:20 Go To Cell A1: Ctrl + Home 0:02:36 Format Cells dialog box or…

Continue Reading
Close Menu