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

[@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.

[@user-fd2tr1ue1p]

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

[@lailajamal9522]

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

[@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!💪😁🌴🤙

[@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.

[@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!!

[@eyanaeeipa9541]

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

[@wayneedmondson1065]

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

[@zamba-lady5228]

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

[@cliffordcubian6680]

thank you for your tips. Really appreciated!!!

[@Smcouncil]

You are doing awesome job, love you man.

[@Mohammad-vw7sq]

This is the best channel that I saw on TH-cam.

[@mochehrzad9077]

Thanks for the great videos. It is very helpful.

[@jagbirjhajharia1115]

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

[@wilsonmoscoso4620]

Excellent!!! Thanks for these videos.

[@emadislam9590]

Great video learnt a lot!

[@stewartalexander158]

Your voice makes learning easy

[@tuainemarsters1523]

Thank you for the lesson

[@dating_life350]

Thanks! It is very helpful :)

[@kizongona]

This was helpful.. Thank you

[@Saad.PS2009]

Nice job thank you so much

[@hanyrahmy100]

Good and simplicity in explanation

[@Minhaz100]

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

[@brendamg7298]

amazing. Thank you.

[@gjaffar7308]

Totally Amazing😀

[@brendamartinez6955]

Very helpful.

[@rodneyoganga6693]

Very good tips Sir

[@florencioernestomiambo9300]

Nice! Thousands likes. Thanks, very helpful!

[@SeleTraining]

Glad you liked it!

[@Danecek26]

Great job :-)

[@cheryllin4079]

good excel tutorial for beginners

[@mochehrzad9077]

Excellent video

[@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 =)

[@nisarahmed5869]

Excellent

[@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.

[@romeshkirpalani848]

Very nice

[@RA-rh5lb]

Thanks

[@nokafisher2771]

just subscribed sir😎

[@excel2minutes]

Great

[@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?

[@firrstlasst3162]

👏👏👏

[@richardzuganda6054]

Wow

[@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.

[@lfpedraza]

Hello, Do you have a tutorial on Formulation.

[@GaminGBeaxT]

Excel ASMR Edition. Just kidding, great job 👍

[@adeolataiwo7486]

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

[@ubaidillahmuhammad20]

nice job. put link workbook download

[@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!

[@rithysokshare4820]

Hi teacher

[@PemberiSolusi]

hmmm,,, how

[@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.

[@rithysokshare4820]

How about your health?

[@SeleTraining]

?

[@yaseenmuhammad5624]

too basic tip not related to accountant

[@SeleTraining]

Check out my advanced Excel tips and tricks video.