Here are more than 7 amazing shortcuts and ideas to showcase your Excel data in meetings and impress your boss! See filtered data easily, find formula errors, auto-sum, find the top or bottom most data.

Timestamps:
00:00 Excel Intro
00:07 Select entire table (Ctrl a)
00:18 Convert to Table (Ctrl t)
00:29 Add Filters (Ctrl Shift L)
00:39 Add Filter Slicer
01:23 Autosum (Alt =)
01:35 Top 3 and Lowest 3 in a range (=LARGE or =SMALL)
02:04 F4 to add dollar signs $ so the range doesn't move
03:07 Tracing formulas (Ctrl [ and Ctrl ])
03:36 Show all formulas (Ctrl ` )
03:54 Trace Formulas with arrows (Alt t u t)
04:22 Create Pivot Table (Alt n v t)


AMAZING 52 Project TOOL Templates in Excel and PowerPoint ready-made and ready to use here: https://www.etsy.com/listing/1199800561/50-project-management-templates-in-excel

Get Project Management Plan templates in PowerPoint and Word ready-made for you here: https://www.etsy.com/listing/1658006489/the-best-project-management-plan

The BEST PMP Course - get 35 PDUs plus 500 PMP Practice Questions: https://www.udemy.com/course/ultimate-project-management-pmp-35-pdus/?referralCode=304F47999BDAF3A4BEBE

The BEST Agile Course - get 21 PDUs plus 200 Practice Questions: https://www.udemy.com/course/the-greatest-agile-course-ever-pmi-acp/?referralCode=FFEDDD9C64F8DB8605AB