25 Tips & Tricks to Make you an Excel WIZARD

Показать описание

Learn 25 Excel tips & tricks with me!

⏱️ 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

Learn about the SUMPRODUCT function:

ABOUT THIS CHANNEL
Looking to level up your career in Finance & Accounting? You're in the right place. Each week I upload videos around Accounting, FP&A, and Excel to help you grow in your career and learn something new.

Don’t forget to subscribe!

🔎 FIND ME AT

➡️ Subscribe to my Newsletter!

🔗 FOLLOW ME ON SOCIAL
Get updates or reach out to Get updates on our Social Media Profiles!

#Excel #ExcelExpert #MasterExcel #ExcelTips #Accounting #Finance #financials #accountingprofessionals #Tutorial #yourcfoguy