Who it's for: Professionals using Excel to tackle practical tasks around financial data.
What it is: Microsoft’s spreadsheet application used to clean, organize, and present data.
What you'll learn: This course begins with a brief Excel refresher before moving on to a series of Finance and Accounting tips to improve your day-to-day workflow. First, we’ll explore common functions like NPV, IRR, and IPMT. Then, you’ll learn how to create a variety of charts to visually represent your data like stock charts, area charts, and even football field charts. Next, you’ll refamiliarize yourself with some key Excel tools like Pivot Tables to maximize your time in the application. Finally, we’ll show you how all of this works in the real world with comprehensive exercises around income statements, balance sheets, cash flow statements, and much more.
- Introduction (1:00)
- Introduction to Excel (2:36)
- Data Entry Basics (2:57)
- Rows and Columns (2:22)
- Open, Save, and Print (3:02)
- Formatting Basics (3:57)
- Formatting in Cells (3:42)
- Conditional Formatting (3:20)
- Freeze Panes and Split Screen (3:38)
- Quick Access Toolbar and Keyboard Shortcuts (4:14)
- Basic Functions (5:32)
- IF Statements (4:03)
- SUMIF and AVERAGEIF (5:20)
- LEFT, RIGHT, MID, and Flash Fill (5:04)
- COUNTIF and COUNTIFS (4:35)
- Conclusion (0:39)