Are you still making these “Tables” with little borders in EXCEL?
👩💻 ?? QUESTION: Are you still making those little tables where you select the data, add borders, then apply a filter, and then, since you need the TOTAL, you use autosum? 🤔
If your answer is yes, RUN to see this TIP! I'll show you how to make tables "Now" in Excel, and I say "Now" because these tables have been around since 2007 😅, so it's time to catch up and start enjoying all the spectacular BENEFITS of these Table Formatting features.
👍😁
-----------------------------------------------------------
👨💻 If you'd like to download the video file to practice, you can download it at the following link:
https://smartprosoluciones.com/todavi...
-----------------------------------------------------------
✍️ Would you like to know your current Excel level? Take our free test and discover how much you're really getting out of Excel 😏👇:
https://maraton.smartprosoluciones.co...
-----------------------------------------------------------
👨👨👧 LET'S STAY CONNECTED! 😁:
Instagram and Facebook: @SMARTpro Academy
► Instagram: / smartproacademy
► Facebook: / smartproacademy
► TikTok: / smartproacademy
-----------------------------------------------------------------------
0:00 Intro
00:56 How are these tables created with table formats?
01:54 Benefit #1: Quickly change the format.
02:09 Benefit #2: Easily add new information.
02:37 Benefit #3: The fabulous TOTALS ROW (...and it doesn't just add up).
03:57 Benefit #4: Create new columns.
04:24 Benefit #5: Move columns or rows super easily.
04:48 Benefit #6: Easy to Delete Column(s)
05:16 Benefit #7: More INTUITIVE Formulas
06:00 Benefit #8: Automatically Fills the Formula in the Entire Column
06:39 Benefit #9: Select Data from One or More Columns with One Click
07:07 Benefit #10: Create Button Filters (Slices)
08:02 BONUS: Place Buttons Horizontally
09:58 Benefit #11: Remove Duplicates
10:55 Benefit #12: Dynamic Ranges
12:36 Benefit #13: Automatically Updates the Range of PivotTables