Summary
Keywords
Full Transcript
Most useful excel formulas for business & finance professionals. 👉 Use my link https://bit.ly/KenjiExplainsMTMar22 and code KENJI15 to get 15% off MeisterTask PRO or Business and align your team like never before! 🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/621fb532e4da3a4464c2fc1e 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance 10 of the most useful excel formulas for business and finance professionals. These excel formulas include xlookup, text to columns, concatenate, sumifs, data validation, find & replace, unique, transpose, conditional formatting, and date functions. To practice these, we will be using Apple's financials and their product line. Furthermore, to replicate a real-life example, we'll be interacting with our manager. These awesome formulas will help you increase your productivity and impress your colleagues and superiors. This video is suitable for all levels of excel.. 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 - Intro 0:33 - Find & Replace 1:20 - Unique Function 1:50 - Transpose 2:25 - SumIFs 4:30 - Conditional Formatting 6:35 - Data Validation 7:45 - Xlookup 10:00 - Text to Columns 10:45 - Concatenate Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you. This video was sponsored by MeisterTask
