Most useful excel formulas for enterprise & financial professionals.
👉 Use my link https://bit.ly/KenjiExplainsMTMar22 and code KENJI15 to get 15% off MeisterTask PRO or enterprise and align your team like never before!
🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages/621fb532e4da3a4464c2fc1e
👉 Excel for enterprise & financial Course: https://www.careerprinciples.com/courses/excel-for-enterprise-financial
10 of the most useful excel formulas for enterprise and financial 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 financial & Valuation Course: https://www.careerprinciples.com/courses/financial-valuation-course
👉 Excel for enterprise & financial Course: https://www.careerprinciples.com/courses/excel-for-enterprise-financial
📊 Get 25% OFF Financial Edge Using Code KENJI25: https://bit.ly/3Ds47vS
SOCIALS:
📸 Instagram – https://www.instagram.com/kenji_explains/
🤳 TikTok – https://www.tiktok.com/@kenjiexplains?lang=en
GEAR:
📹 My Favorite Books & Gear: https://kit.co/kenjiexplains
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
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
Disclaimer:
If you own the YouTube channel related to this video and do not want it to be featured here, you can contact us through our contact page. We will gladly remove it without questioning your reasons.