Learn the top 10 most useful Excel formulas using real-life examples.
👉 Take our Excel Course: https://www.careerprinciples.com/courses/excel-for-business-finance
🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/62ac88cfc133f442c4f6831a
In this video you'll learn all of the essential excel formulas ranked from easiest to hardest.
In level 1 we'll look at the sequence formula, follow by string functions such as left, mid, and right.
In level 2 we'll go over date functions like weekday, weeknum, or today, alongside an IF statement.
In level 3 we'll go over advanced IF statement formulas such as the SUMIF and the SUMIFS
In level 4 we'll go over vlookup (part of the lookup family) and the IFERROR
In level 5 we'll go over the most complex formulas which are going to be the xlookup, and the index match.
To follow along, you can download the free excel file above!
LEARN:
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
🏦 The Investment Banking Program: https://www.careerprinciples.com/career-track/the-investment-banking-program
🚀 All our courses: https://www.careerprinciples.com/all-courses
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Level 1
2:27 - Level 2
5:37 - Level 3
9:29 - Level 4
12:15 - Level 5
Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.