Excel Formulas 101| The Ultimate guide for Total Beginners in Microsoft Excel

Hello and welcome to a thorough beginners' guide to Microsoft Excel Formulas! Follow me on: Instagram:   / tutelageek_yt   Twitter:   / tutelageek   00:00 Introduction 00:56 Initiate a calculation 01:58 Edit a cell (3 ways) 02:12 Calculation using other cells 03:05 Overwrite a cell 03:17 Cancel typing on a cell 03:27 Division & Multiplication 03:44 Power Calculation | Caret symbol Problem 04:50 Data Walkthrough 05:32 Addition Formula SUM() & Keyboard Shortcut 06:55 Quickly Replicate/ Extend Formulas & Calculate Profits 09:22 The AVERAGE() formula & Quickly Select a Column 11:10 The POWER() & SQRT() Square Root Formula 12:12 COUNT () & COUNTA() & COUNTBLANK() 14:10 MIN() & MAX() & MEDIAN() 15:44 Create a Discounted Sale Price. 16:45 Lock a Formula to a Specific Cell with $ 19:47 ROUND() & ROUNDDOWN() & ROUNDUP() 21:27 Formulas within Formulas & Common Mistakes 22:55 Formulas vs Filters This Video is not Sponsored