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: [ Ссылка ]
➡️ Get Project Management Plan templates in PowerPoint and Word ready-made for you here: [ Ссылка ]
✅ The BEST PMP Course - get 35 PDUs plus 500 PMP Practice Questions: [ Ссылка ]
🚀 The BEST Agile Course - get 21 PDUs plus 200 Practice Questions: [ Ссылка ]
Ещё видео!