Excel Crash Course: Master Excel for Financial Analysis
Excel Crash Course: Master Excel for Financial Analysis, available at $84.99, has an average rating of 4.59, with 40 lectures, based on 15069 reviews, and has 48963 subscribers.
You will learn about Perform professional level financial analysis in Excel At the end the course students will be able use industry best practices when building financial models in Excel This course is ideal for individuals who are This Excel course is meant for all levels from beginner to advanced. Power users should skip the earlier chapters. or The content is geared towards financial modeling and financial analysis used in investment banking, equity research, private equity and more. It is particularly useful for This Excel course is meant for all levels from beginner to advanced. Power users should skip the earlier chapters. or The content is geared towards financial modeling and financial analysis used in investment banking, equity research, private equity and more.
Enroll now: Excel Crash Course: Master Excel for Financial Analysis
Summary
Title: Excel Crash Course: Master Excel for Financial Analysis
Price: $84.99
Average Rating: 4.59
Number of Lectures: 40
Number of Published Lectures: 40
Number of Curriculum Items: 40
Number of Published Curriculum Objects: 40
Original Price: $34.99
Quality Status: approved
Status: Live
What You Will Learn
- Perform professional level financial analysis in Excel
- At the end the course students will be able use industry best practices when building financial models in Excel
Who Should Attend
- This Excel course is meant for all levels from beginner to advanced. Power users should skip the earlier chapters.
- The content is geared towards financial modeling and financial analysis used in investment banking, equity research, private equity and more.
Target Audiences
- This Excel course is meant for all levels from beginner to advanced. Power users should skip the earlier chapters.
- The content is geared towards financial modeling and financial analysis used in investment banking, equity research, private equity and more.
Course Description
Learn all the tips, tricks, shortcuts, functions and formulas you need to be an Excel power user. This course is designed specifically for Excel users who are performing professional financial analysis and financial modeling. We cover all levels – from beginner to advanced users.
Build a strong foundation in Excel for careers in:
- Investment banking
- Private equity
- Corporate development
- Equity research
- Financial Planning & Analysis (FP&A)
Learn industry leading best practices. This course is based on first-hand investment banking training programs at global banks. The quality of instruction you receive in this course will have you just as sharp as if you took an expensive, live Wall Street course.
Content and Overview This course starts with the basics and quickly progresses to a level where even experts will learn something new. We think it’s important to start at the bottom and build a solid base, which is why we review all the foundational skills you need.
In the second half of the course you’ll notice the functions and formulas getting more sophisticated and the quality of financial analysis and financial modeling becoming much higher.
What am I going to get from this course?
- Learn everything you need to know about Excel for a career in corporate finance
- Master shortcuts, functions, and formulas to save time speed up you modeling skills
- Follow industry leading best practices
- Stand out in an interview or move up the ladder at work by dramatically boosting your Excel skills and confidence
Course Curriculum
Chapter 1: Introduction
Lecture 1: CFI Intro
Lecture 2: Welcome
Lecture 3: Table of contents
Lecture 4: Instructor biography
Lecture 5: Key learning objectives
Chapter 2: Excel Layout
Lecture 1: Layout overview
Lecture 2: Workbooks, worksheets, cells, & formula bar
Lecture 3: The ribbon
Chapter 3: Excel Settings
Lecture 1: Settings overview
Lecture 2: Changing your settings
Chapter 4: Basic Financial Analysis Setup
Lecture 1: Objectives
Lecture 2: Format, background, special numbers, column width, freeze panes
Lecture 3: Paste special, font colors, format numbers, sum
Lecture 4: Percentages, fill right, font colors, borders, view gridlines
Chapter 5: Advanced Financial Analysis Setup
Lecture 1: Objectives
Lecture 2: Structure, organization, duplicate sheets, grouping
Lecture 3: Anchoring cells, grouping
Lecture 4: Naming cells, tracing precedents & dependents, auditing
Lecture 5: Go to special, conditional formatting
Lecture 6: Dynamic titles & headers
Chapter 6: Basic Functions & Formulas
Lecture 1: Objectives
Lecture 2: Date fuctions and time periods
Lecture 3: Sum, average, sumproduct, median
Lecture 4: IF statements
Lecture 5: Rounding and absolute fuctions
Lecture 6: Min, max, small, large
Lecture 7: IFerror, find and replace
Chapter 7: Advanced Functions & Formulas
Lecture 1: Objectives
Lecture 2: Scenarios, choose, data validation
Lecture 3: Vlookup, hlookup, index, match
Lecture 4: Data tables and goal seek
Lecture 5: Sumif, countif, if + and
Lecture 6: Xirr and xnpv
Chapter 8: Charts & Graphs
Lecture 1: Objectives
Lecture 2: Stacked column and line chart combined
Lecture 3: Waterfall chart (Excel 2016)
Lecture 4: Column, line, and pie charts
Chapter 9: Macros
Lecture 1: Objectives
Lecture 2: Recording and using macros to seed up modeling
Chapter 10: Wrap Up
Lecture 1: Download completed file and keep practicing
Instructors
-
Scott Powell
Corporate Finance Institute
Rating Distribution
- 1 stars: 60 votes
- 2 stars: 135 votes
- 3 stars: 1187 votes
- 4 stars: 5466 votes
- 5 stars: 8221 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024