Excel Crash Course – Wall street prep
Original price was: $39.00.$7.00Current price is: $7.00.
Excel Crash Course – Wall street prep Download. For finance professionals, proficiency in Excel is a fundamental part of the job description. Whether you d…
Salepage link: At HERE. Archive: http://archive.is/6n0WS
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
Here's an overview of the prominent keywords and a list of famous authors:
Business and Sales: Explore business strategies, sales skills, entrepreneurship, and brand-building from authors like Joe Wicks, Jillian Michaels, and Tony Horton.
Sports and Fitness: Enhance athleticism, improve health and fitness with guidance from experts like Shaun T, Kayla Itsines, and Yoga with Adriene.
Personal Development: Develop communication skills, time management, creative thinking, and enhance self-awareness from authors like Gretchen Rubin, Simon Sinek, and Marie Kondo.
Technology and Coding: Learn about artificial intelligence, data analytics, programming, and blockchain technology from thought leaders like Neil deGrasse Tyson, Amy Cuddy, and Malcolm Gladwell.
Lifestyle and Wellness: Discover courses on holistic health, yoga, and healthy living from authors like Elizabeth Gilbert, Bill Nye, and Tracy Anderson.
Art and Creativity: Explore the world of art, creativity, and painting with guidance from renowned artists like Bob Ross and others.
All the courses on WSOlib are led by top authors and experts in their respective fields. Rest assured that the knowledge and skills you acquire are reliable and highly applicable.
Specification: Excel Crash Course – Wall street prep
|
User Reviews
Only logged in customers who have purchased this product may leave a review.
Original price was: $39.00.$7.00Current price is: $7.00.
There are no reviews yet.