Thursday, July 25, 2024

25 Tips & Tricks to Make you an Excel WIZARD


⏱️ TIMESTAMPS 0:16 Adding a Dynamic Dropdown 4:53 Unpivotting Data 7:38 Add a Slicer to a Table 8:48 Text to Column 9:32 Transposing Data 10:07 Remove Duplicates 11:11 Duplicating a Window 11:59 The Watch Window 12:31 Camera Tool 13:30 Create Different Scenarios 14:47 Analyze the output of Multiple Scenarios in One View 16:51 Finding an Exact Value With Goal Seek 17:23 Insert Cut Cells 18:23 Sumproduct 20:09 Evaluating Your Formula 20:40 How to Create Conditional Formatting 22:31 Custom Formatting 24:07 Create a Combo Chart 25:12 Centering Across Selection 25:50 Vertical Headers 26:09 Insert a Timeline to a Pivot 26:39 Create a Table Of Contents 27:17 Insert Icon into Cell 28:23 Create Bulk Named Ranges 28:59 Create a Custom Sort


No comments:

Post a Comment