These Excel tips and tricks are invaluable if you are in Finance or Accounting. Here are 10 solutions that can make your job much more efficient.
Support me with your Amazon purchases, click here: https://amzn.to/2Kxp533
Dynamic Array Formulas Video: • Excel Dynamic Array Formulas
Return Multiple Results With Filter Video: • Return Multiple Results from an Excel...
Excel Slicers Video: • Excel Slicers The Cool Way to Filte...
DropDown List Video: • Excel Drop Down List Tips and Tricks
Top 25 Excel Shortcuts Video: • Top 25 Excel Shortcut Tips and Tricks
Introduction to Excel Video: • Introduction to Excel
50 Ultimate Excel Tips and Tricks Video: • 50 Ultimate Excel Tips and Tricks for...
20 Essential Excel Functions Video: • 20 Essential Excel Functions with Dow...
00:00 Contents
00:37 Create a Total Sheet
03:04 Trendline & Forecast
05:39 Quick Analysis Tool
07:05 SUMIF & SUMIFS
08:51 Slicers
10:35 Date Functions
13:33 Subtotals
15:08 FILTER
17:08 DropDown List
18:25 PMT
#seletraining #excel #accounting