Top 30 *Advanced* Excel Tips to make you awesome ⚡💡
#ExcelTips
Time to celebrate the beauty and versatility of Excel with 30 of my favourite Excel tips for advanced uses. You will be amazed and satisfied for sure. Watch the whole thing & share the video with a friend. Use below timestamps if you need to see a specific tip.
⏱ Video timestamps
==================
0:00 - Introduction
0:55 - New FILTER function *
1:51 - CHAR(10) Trick
2:46 - CTRL SHIFT 4 - quick currency format
3:06 - Using SUBTOTAL function
3:34 - Slicers on Table
4:25 - Mini charts with REPT() trick
5:19 - Finding 2nd largest value
5:58 - CTRL SHIFT 3 - quick date format
6:17 - Quick number formats in pivots
6:46 - Easy interactive chart trick
7:20 - ☝ Slicer ✌ Charts
7:57 - Year to date totals in Pivots
8:45 - CTRL F1 - Collapse / expand ribbon
9:06 - Adding subtitle (caption) to charts
9:52 - NEW Treemap chart *
10:37 - Tiny charts, big impact
11:24 - Free ICONS to spice up your reports *
11:51 - Lookup from bottom *
12:45 - CTRL G - Go anywhere
13:28 - Quick Age grouping in pivots
14:18 - Rearrange pivot row labels in any order
14:46 - Make sense of large pivots easily
15:45 - Fix date formats with this trick
16:38 - Emojis in your formulas 😀😂🤩
17:30 - Get live stock (share) prices in Excel *
18:36 - Printing trick 🖨📰⚡
19:24 - Databars, but not too long
20:24 - F7 - Sepllcehck
20:43 - Smart chart titles
21:19 - Hide away charts temporarily
indicates that you need Excel 365 to use the tip. All other tips should work in any modern version of Excel.
💡 More Excel tips for you 👉
========================
10 data cleaning tricks experts use all the time - • Data cleaning in Excel - 10 tricks *P...
10 formatting tricks only Pro users know - • 10 Excel formatting tricks *ONLY* exp...
10 awesome things you can do in Excel without formulas - • 10 awesome things you can do in Excel...
10 copy paste tricks that you are not using - • 10 *SURPRISING* Copy Paste Secrets fo...
10 of my favourite Excel keyboard shortcuts - • The *ONLY* 10 Excel keyboard shortcut...
🔴 NEW - My course on Lookup Formulas
==================================
👉 https://skl.sh/3pR8ISG
I recently launched a complete short course on Excel lookup functions. You will learn all about XLOOKUP, VLOOKUP, FILTER, HLOOKUP, INDEX+MATCH and how to combine these functions to solve business problems. You will also learn advanced lookup techniques like 2-way lookups, all matching results, multiple criteria lookups in the course.
Join for this class on Skillshare - You will also get 1 month premium membership to the platform for when you use my link.
Click here 👉 https://skl.sh/3pR8ISG
~
🐦🦜🦃 Bird songs
=================
Recorded on a recent walk around my neighbourhood in Wellington, NZ.
Thank you and happy learning 😀
Смотрите видео Top 30 *Advanced* Excel Tips to make you awesome ⚡💡 онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Chandoo 29 Июнь 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 345,73 раз и оно понравилось 13 тысяч людям.