This is not a “cookie cutter” university Microsoft Excel course. Our online Excel training will teach you the most critical formulas and functions in Microsoft Excel to give you the skills to take on any spreadsheet or analysis.
Microsoft Excel is a cornerstone of finance and accounting. FP&A and Accounting employees use excel for many hours a day, yet most people are completely underutilizing this great tool. If you master you can save a lot of time and frustration, as well as differentiate yourself from your peers. In this course we will spend a lot of time learning keyboard shortcuts which are key to maximizing your efficiency.
After we get through keyboard shortcuts, we will move on to powerful functions like IF statements, VLOOKUPs, SUMIFS, Conditional Formatting and some other powerful formulas and tricks. We finish the course by learning how to create PivotTables. We have left out all the unimportant details and get right to the heart of Microsoft Excel. This will be the best Excel course you have taken!
Format: 3-6 minute videos, quizzes, and a final exam
Estimated Time: 4 hours
Field of study: Financial Tools & Software
Prerequisites: You should have a high-level knowledge of Excel (e.g. SUM, AVERAGE, Charts, etc.)