Excel for Finance and Accounting

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: • Excel Dynamic Array Fo...
Return Multiple Results With Filter Video: • Return Multiple Result...
Excel Slicers Video: • Excel Slicers - The Co...
Drop-Down List Video: • Excel Drop Down List T...
Top 25 Excel Shortcuts Video: • Top 25 Excel Shortcut ...
Introduction to Excel Video: • Introduction to Excel
50 Ultimate Excel Tips and Tricks Video: • 50 Ultimate Excel Tips...
20 Essential Excel Functions Video: • 20 Essential Excel Fun...
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

[@MrAloha]

Your vids always show up right before I lead a workshop or a live class. I gotta tell the folk I train about you. Looks like I'll be mentioning you, Chandoo, Leila, and Bill J. Thanks for the great work! Aloha Friday!💪😁🌴🤙

[@user-fd2tr1ue1p]

Hi there, accounting student here thanks so much for your content!!! I know it'll be much needed!!

[@lfpedraza]

By the way. Thank you for taking time from your life to make it easier for us who what to learn. You sure know your Stuff.

[@lailajamal9522]

My only favorite channel to learn Excel! Thank you very much 🌹

[@harishagicha2915]

Video was really amazing, that 3d formula, quick analysis, filter and table slicer, I really loved it, that's definitely gonna help me, thank you so much!!

[@wayneedmondson1065]

Thanks Jason. Good tips.. as always :)) Thumbs up!!

[@cliffordcubian6680]

thank you for your tips. Really appreciated!!!

[@hobbitlovr]

Nice tips! Clearly explained, and your voice is calming and pleasant, unlike some other tutorial videos. Also, thank you for not having background music.

[@eyanaeeipa9541]

I had the accounting knowledge, now thanks to you I now posses excel pro knowledge

[@Smcouncil]

You are doing awesome job, love you man.

[@Mohammad-vw7sq]

This is the best channel that I saw on CZcams.

[@zamba-lady5228]

Your videos are truly amazing. Thank you. I just wish I'd come across them before I did my microteach presentation yesterday

[@emadislam9590]

Great video learnt a lot!

[@wilsonmoscoso4620]

Excellent!!! Thanks for these videos.

[@mochehrzad9077]

Thanks for the great videos. It is very helpful.

[@dating_life350]

Thanks! It is very helpful :)

[@jagbirjhajharia1115]

It's amazing a lot of thanks for this video 👏👏👏 waiting for another videos related accounts and finance

[@tuainemarsters1523]

Thank you for the lesson

[@kizongona]

This was helpful.. Thank you

[@Saad.PS2009]

Nice job thank you so much

[@stewartalexander158]

Your voice makes learning easy

[@brendamg7298]

amazing. Thank you.

[@gjaffar7308]

Totally Amazing😀

[@Minhaz100]

Good evening... Sir... your vedio is the best for me

[@hanyrahmy100]

Good and simplicity in explanation

[@brendamartinez6955]

Very helpful.

[@Danecek26]

Great job :-)

[@rodneyoganga6693]

Very good tips Sir

[@cheryllin4079]

good excel tutorial for beginners

[@mochehrzad9077]

Excellent video

[@florencioernestomiambo9300]

Nice! Thousands likes. Thanks, very helpful!

[@SeleTraining]

Glad you liked it!

[@nisarahmed5869]

Excellent

[@RA-rh5lb]

Thanks

[@harmanvi]

Sir I am 44 and I am switching from sales to data entry . I am learning from your tips only but sometimes I get so confused from where to start which is the first class( from basics ).for people like me who know nothing about excel .I am writing to you coz your videos are I think super helpful foe people don't want to spend money in institutions.. ooh an my desktop is very old I just checked I have ms 2007 in it

[@SeleTraining]

Make sure to check out my intro to Excel videos as well.

[@m1ilann50]

I'd like to ask you about the 6X6 rule in powerpoint, Can I use or write 5 words rather than 6 in this rule?

[@romeshkirpalani848]

Very nice

[@excel2minutes]

Great

[@nokafisher2771]

just subscribed sir😎

[@lfpedraza]

Hello, Do you have a tutorial on Formulation.

[@richardzuganda6054]

Wow

[@firrstlasst3162]

👏👏👏

[@adeolataiwo7486]

Please can I get suggestions on where I can get database materials to practice with?

[@andreasandoval5039]

Hi Mr. Sele, I wanted to reach out to thank you for all of your videos. You’ve been a tremendous resource and I hope you will continue uploading ms excel tutorials. Do you conduct any online training courses? If so, please provide that information so I can sign up! :-)

[@SeleTraining]

Thanks. I don’t have any training courses. Just these videos.

[@andreasandoval5039]

@@SeleTraining Understood, just please don’t ever stop making these videos =)

[@GaminGBeaxT]

Excel ASMR Edition. Just kidding, great job 👍

[@taoufikelmiri]

Nice explanation 👌👍👍
One question, when can consumers get the new refreshed UI of Office 2021?

[@SeleTraining]

Office 2021 was just released and is available for purchase. It includes the new UI.

[@ubaidillahmuhammad20]

nice job. put link workbook download

[@rithysokshare4820]

Hi teacher

[@arifuzzamansumon6865]

Could you please tell me where the location of practice is file?

[@SeleTraining]

There is no practice file for this video. The samples are small so it's meant for you to enter those yourself.

[@Tesnobay]

Do you do any Mac related training for Office products?

[@SeleTraining]

I’m mainly a PC user.

[@Tesnobay]

@@SeleTraining Ok thanks. I will still watch. Good stuff!

[@PemberiSolusi]

hmmm,,, how

[@rithysokshare4820]

How about your health?

[@SeleTraining]

?

[@yaseenmuhammad5624]

too basic tip not related to accountant

[@SeleTraining]

Check out my advanced Excel tips and tricks video.