Excel Crash Course | Introduction (Part 1)

Video Statistics and Information

Video
Captions Word Cloud
Reddit Comments
Captions
great financial analysts are masters at Excel in this course we're going to teach you the formulas functions and shortcuts you need to become super confident at working with spreadsheets as an analyst you'll spend so much of your time working with Excel and financial models so we're gonna make sure you have the confidence you need to jump into any financial model or build one from scratch and build it to a world-class standard this course is designed for anyone who works with Excel models and performs financial analysis we're gonna run through a case study where we start with the lay out the structure and the formatting of a piece of financial analysis and then we work through functions and formulas in a natural way where we start layering in if statements choose functions conditional formatting and all sorts of tools that you're going to need as an analyst building financial models the expectation for this course is that you complete all the video lectures that you follow along and watch the instructor show you how to build each formula and function then you'll try it on your own you'll work through the exercises you'll complete the quizzes and a qualified assessment at the end to make sure you've got a thorough understanding of it Excel skills are one of the most important topics in CF is financial modeling and valuation analyst designation this course is perfect for beginners or intermediate level analysts we've got a lot of important things to cover in this course it's one of the optional prerequisites for the program so let's jump into Excel now and get going you let's meet the global team of CFI instructors this course is delivered by myself Tim Vipond our CEO and lead instructor based in Vancouver all of our courses are designed by the entire team which includes Lisa durian in New York Justin Saunders in London Ryan's glendalough in Hong Kong and Scott Powell in Vancouver as a team we've delivered courses to some of the world's largest global investment banks including Deutsche Bank JP Morgan Citigroup and many more you can be sure that the instruction you're getting in this course and all other CFI courses is of the same caliber you would receive at a training program out of global investment bank let's review the key learning objectives for this course this course is designed for financial analysts you could be working in investment banking equity research financial planning and analysis or corporate development just to name a few of our most common types of financial analysts that take our courses we're gonna focus on Excel 2016 but also cover shortcuts and functions from 2013 and 2010 as well we begin with the basics we assume no prior knowledge in taking this course but don't worry we're also going to get into some advanced functions so experts and power users can learn a lot from this course too in terms of the objectives of the course we want you to be able to follow industry leading best practices when it comes to building models this will dramatically speed up your financial modeling skills and make you more effective in the office this course will make your analysis more powerful and more dynamic which in turn will make you a better financial analyst in this course we're gonna focus on using the keyboard over the mouse professionals use the keyboard instead of the mouse for several reasons it does a few things it helps you save time it enables you to move around a spreadsheet much more quickly and with more precision and it's actually kind of fun too once you get used to using the keyboard it becomes addictive to see how much you can just restrain from using the mouse if you were hired as an investment banking analyst many of the training programs would require you to disconnect your mouse if you really want to challenge yourself try disconnecting your mouse and forcing yourself to only use the keyboard for the whole course we should point out though that in the short term it may seem slower and it will be but then in the long run it will become much faster for you so stick with it practice your shortcuts as much as you can and in the end you'll be a much faster and more effective financial modeler
Info
Channel: Corporate Finance Institute
Views: 110,527
Rating: 4.9460373 out of 5
Keywords: excel crash course for finance professionals, excel crash course, free excel crash course, how to use excel formulas, excel formulas and functions in finance, excel shortcuts, excel training, excel tutorial, excel for financial modeling, corporate finance, finance training, finance education, excel formulas and functions
Id: 3oZC3cuaZvQ
Channel Id: undefined
Length: 4min 25sec (265 seconds)
Published: Tue Mar 26 2019
Related Videos
Note
Please note that this website is currently a work in progress! Lots of interesting data and statistics to come.