Description
The course: Excel Crash Course by Wall street prep
- Archive: http://archive.is/6n0WS;
- Total sizes: 1.1 GB (Format files: mp4, html)
- Course language: English
For finance professionals, proficiency in Excel is a fundamental part of the job description. Whether you describe yourself as a beginner or proficient in Excel, this course will take you to the next level and turn you into an advanced “power” user.
Course Objective
We’ll start with the basics before we quickly introduce you to lesser known time-saving keyboard shortcuts and powerful Excel functions and features that you can immediately put to use on the job. The only way to learn Excel is by doing, so you’ll be completing Excel exercises every step of the way.
What You Will Learn
- Accelerate the internalization of the key time-saving shortcuts via exercise-based internalization drills and video-driven guidance.
- Learn how to incorporate and take advantage of the most popular and helpful Excel functions and table features for financial analysis.
- Learn to quickly create macro-based shortcuts.
- Build data tables and perform sensitivity analysis.
- Enhance the presentation of financial and valuation models by adding forms and toggles to your spreadsheets.
Wall Street Prep’s Accounting Crash Course is used at top financial institutions and business schools.
Full Course Agenda
Chapter 1: Introduction to Accounting open
- Introduction
- Basic Accounting Principles
- Financial Reportings & Important Filings
- Reading the 10K
Chapter 2: The Income Statement open
- Revenue
- Revenue Recognition
- Revenue Manipulation
- COGS & Gross Profit
- Selling, General & Administrative, Research & Development
- Expenses
- Depreciation
- Amortization
- Non-Operating Items & Taxes
- Net Income, EPS & Dividends
- EBIT, EBITDA & Income Statement Summary
- The Lemonade Stand, Part 1
- The Lemonade Stand, Part 2
Chapter 3: The Balance Sheet open
- An Introduction to Assets
- An Introduction to Liabilities
- Double Entry Accounting
- How the Income Statement Connects to the Balance Sheet
- The Lemonade Stand Revisited
- How Assets & Liabilities are Presented
Chapter 4: Assets open
- Cash, Receivables & Prepaid Expenses
- Inventory
- Property, Plant & Equipment, Part 1
- Property, Plant & Equipment, Part 2
- Intangible Assets & Goodwill
Chapter 5: Liabilities & Equity open
- Payable, Accrued Expenses, Deferred Revenue & Debt
- Operating & Capital Leases
- Equity
- The Lemonade Stand, Part 3
Chapter 6: The Cash Flow Statement open
- The Cash Flow Statement
- Cash From Operations
- Cash From Financing & Cash From Investing
- The Lemonade Stand, Part 4
Chapter 7: Financial Statement Analysis open
- Financial Statement Analysis
Reviews
There are no reviews yet.