???? Try Granola in your next meeting: https://go.granola.ai/kenji-farre
In this video, you’ll learn 10 mind blowing Excel tricks I wish I knew sooner.
???? DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/u5bsq7bjhe
In this video, I cover 10 of the best Excel features you probably didn’t know. These include 3D references that automatically include new tabs, double dashes for counting multiple conditions, custom number formats for displaying values in millions, and the AGGREGATE function for ignoring errors in calculations.
You’ll also learn how to create reusable named formulas, simplify formulas with curly brackets, use cell names for clearer calculations, apply the new dot operator to remove unwanted zeros, add custom arrows to highlight positive and negative changes, and navigate large workbooks using a clickable table of contents.
Thanks to Granola for sponsoring this video.
LEARN:
???? Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
???? The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
???? AI for Business & Finance: https://www.careerprinciples.com/courses/ai-for-business-finance
???? All our courses: https://www.careerprinciples.com/all-courses
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - 3D Trick
1:50 – Dash Feature
3:50 – Format Trick
5:03 – Granola — AI meeting notepad
6:07 – Formula Trick (Underrated)
7:37 – Naming Trick
8:55 – Bracket Trick
10:06 – Combination
10:59 – My Favorite Trick
12:22 – Arrow Feature
13:38 – Navigation Trick
