Channel: Sele Training

Category: Science & Technology

Tags: excel tutorialsele trainingaccountingaccounting functionstotal sheetexcel for accountingquick analysis tooltrendlineexcel 2021accounting formulasoffice 365excel tips and trickssumifdate functionsexcel for accounting and financeforecastsumifsmicrosoft 365subtotalseletrainingaccounting and financeexcel 365drop-down listpmt functionslicers

Description: 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: amzn.to/2Kxp533 Dynamic Array Formulas Video: youtu.be/xwTUfU8PqCU Return Multiple Results With Filter Video: youtu.be/eqB2mklvWSg Excel Slicers Video: youtu.be/KBCd6Gvt2uI Drop-Down List Video: youtu.be/qGmgX27D1qM Top 25 Excel Shortcuts Video: youtu.be/urm3nl_a_wI Introduction to Excel Video: youtu.be/c2dcRy1X9AA 50 Ultimate Excel Tips and Tricks Video: youtu.be/FXs3WG7M-qk 20 Essential Excel Functions Video: 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