10 Genius Excel Tricks I Wish I Knew Sooner

👉 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