Double Dash: The Secret to Smarter Excel Formulas

Use the Double Dash feature in Excel to create smarter formulas. 🚀 Check out all our courses here: https://www.careerprinciples.com/all-... 🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.co... Most Excel users have no idea the double dash feature even exists in Excel. But it can fix broken formulas, convert text to numbers, and even unlock calculations you normally can't do in Excel. So in this video, we’ll break down exactly what the double-dash does — with 6 practical examples from easy to advanced. We’ll start with a simple example showing how the double-dash converts TRUE/FALSE into 1s and 0s. Then we’ll show how it instantly converts text numbers into real numbers. Next, we’ll apply it to dates — like counting how many fall on weekends. After that, you’ll see how it works with LEN, SUMPRODUCT, and other functions to create powerful calculations. We’ll also cover multi-criteria counting, such as finding employees who meet two conditions at the same time. And finally, we’ll tackle the most advanced example: calculating total overtime costs for employees in the Sales department only on weekends. By the end, you’ll understand exactly when to use the double-dash — and why it’s one of Excel’s most underrated tricks. LEARN: 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/cour... 📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/cour... 🔥 Power BI for Business Analytics: https://www.careerprinciples.com/cour... ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Chapters: 0:00​ -​ Basic Double Dash Example 1:43​ - Double Dash with TEXT 3:28​ - Double Dash with Dates 5:52​ - Double Dash with Length 6:53​ - Multiple Criteria 8:24​ - Advanced Example