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: https://youtu.be/xwTUfU8PqCU
Return Multiple Results With Filter Video: https://youtu.be/eqB2mklvWSg
Excel Slicers Video: https://youtu.be/KBCd6Gvt2uI
Drop-Down List Video: https://youtu.be/qGmgX27D1qM
Top 25 Excel Shortcuts Video: https://youtu.be/urm3nl_a_wI
Introduction to Excel Video: https://youtu.be/c2dcRy1X9AA
50 Ultimate Excel Tips and Tricks Video: https://youtu.be/FXs3WG7M-qk
20 Essential Excel Functions Video: https://youtu.be/8P4-jOoYBjo
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 Drop-Down List
18:25 PMT
#seletraining #excel #accounting