25 Tips & Tricks to Make you an Excel WIZARD
Learn 25 Excel tips & tricks with me!
⏱️ TIMESTAMPS
0:00 Intro
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:
• SUMPRODUCT: The Most POWERFUL Excel F...
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.
⚡️ Check out my channel here: / @yourcfoguy
Don’t forget to subscribe!
🔎 FIND ME AT
https://www.yourcfoguy.com
➡️ Subscribe to my Newsletter!
https://www.yourcfoguy.com/newsletter
🔗 FOLLOW ME ON SOCIAL
Get updates or reach out to Get updates on our Social Media Profiles!
LinkedIn: / joshaharonoff
Twitter: / yourcfoguy
#Excel #ExcelExpert #MasterExcel #ExcelTips #Accounting #Finance #financials #accountingprofessionals #Tutorial #yourcfoguy
Смотрите видео 25 Tips & Tricks to Make you an Excel WIZARD онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Josh Aharonoff (Your CFO Guy) 23 Июль 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 9,548 раз и оно понравилось 377 людям.