Excel for Accountants: PivotTables, Power Query, IF, SUMIFS, VLOOKUP, Flash Fill, Charts…CWU Seminar

Download Files:
This is a complete 2 ½ hour video about all the Excel topics you need to become awesome with Excel in the Accounting Field. Here is the list of topics:
1. (00:01) Introduction
2. (01:45) Formulas, Cell Reference and Number Formatting Basics
3. (09:50) ROUND Function
4. (16:34) IF Function
5. (29:19) SUMIFS and COUNTIFS Functions
6. (40:15) VLOOKUP Function
7. (56:47) VLOOKUP & SUMIFS to create Payroll Report
8. (01:00:11) Define Data Analysis and Business Intelligence
9. (01:04:24) PivotTables
10. (01:28:46) Excel 2016 Data Model PivotTable from Two Different Tables
11. (01:36:18) Flash Fill
12. (01:42:29) Charts: Column, Bar, Line and X-Y Scatter Charts
13. (02:03:00) Power Query to Clean, Transform and Import Data into Excel to we can build a PivotTable Report with Calculated Columns
14. (02:20:58) Summary

[chewcatherine]

This is the best ever excel course I've ever had so far.

Something I like:

1. All excel files are provided by instructor for us to get the hands on experience on the new function,
2. Very practical, easy to be understood,
3. Simple and precise, every words spoken is not redundant.



I've taken course on power query before but only fully feel the power of this "new" function in this marvelous course. Thank you Mike!

[LeilaGharani]

This is an amazing course you've put together! Just the hours of preparation and editing and on top explaining everything so simply and clearly. You are truly amazing Mike & I have learnt so much from you! Thank you for all that you do!

[antoniovalero]

Hi, I just created a YouTube account with the only purpose of thanking you. Amazing seminar and perfectly explained, certainly Excell is fun! Thanks so much.

[rafayahmed]

SIR I encountered a lot of Problems, and was wondering from almost a month, you really did an awesome job. Thanks for that.

[DarkGolbez]

Phenomenal breakdown of practical tools that you can use in Excel, presented in a clear and easy-to-follow manner.

1. Thank you so much to the channel for putting this out there for free! It's really helpful!

2. For anyone out there watching to try and better themselves, hold your heads up high. It's hard to work at something that might seem daunting or frustrating. Remember, it's only difficult until you learn it!

Keep at it and don't give up! There are a ton of free classes on here that can make all of us much better at what we do.

[xiangloria]

I started watching your videos when I was a student in Uni, and now they continue helping me in workplace as a CPA...Time flies...Thank you so much for all the videos in these years, Mike.

[furahamwalongo]

i have never meet an amaizing trainer like you before. keep it up. From Tanzania

[samdanu]

Mike Girvin, You are my Mentor!!!! I have acquired in-depth knowledge on MS Excel from you. You are truly God sent to teach the world how to use Excel to solve business task and problems. God Bless you!!!

[alexrosen]

Just amazing Mike. I will never forget that you were the one who inspired me to become an advanced excel user. with your amazing tutorials. You also provide workbooks with your tutorials which make it easier to learn because then I could follow along instead of just watching the tutorials. Loads of thanks, really appreciate it :-)

[margaretcairns]

Thank you so much for giving of your knowledge. Not many do! I appreciate your every effort, the way you continue on to make each concept easier to understand. You strive for perfection. For every good turn ... and I hope you get back a thousand fold! Thank you.

[redcherry]

this is the best course i have ever had, thank you so much for your amazing effort.

[jenniferantonio]

Thank you for providing such thorough lessons, Mike ! Much appreciated🙏 this is the best Excel lesson I've ever had on Youtube

[roderickmose]

Awesome as always Mike! This is how my spend my days....just soaking in the knowledge and passing it on. Went to a formal training class a few weeks ago just to get the certification, and having my superior ExcelisFun training under my belt the school owner being so impressed with my knowledge skill offered me a job. Now I'm an Excel Tutor and Consultant. Couldn't have done it without you Mike. BIG cheers!!!!

[Al-Ahdal]

Mike Girvin is a guru to Excel lovers all over the world. His upbeat videos on Youtube are becoming classics. Thanks for this video too.

[platinglyyours]

You are amazing Mike. We do appreciate your great contribution to our learning excel. Hope we could give back something to you for all your generosity. God bless you more and more.

[philthomas]

Great video. You explain everything so well it's actually a pleasure to learn

[hiddaalbeik]

you are truly amazing Mike and I have learned so much from you! Thank you for all that you
do and God bless you

[elDeMISe]

That FlashFill... Wow Microsoft have done well with that, extremely powerful tool. Been watching your video's on and off for the past three and a half years and they are fantastic, I have learned so much please don't stop anytime soon! I am the Excel geek at work now, they thought INDEX and MATCH with conditional formatting was amazing, tI'm like "tip of the iceberg". You're a very good teacher, clear and concise. Keep it up. :)

[adewaleoke]

You are the man! My excel knowledge has been improving since I knew you. Thanks a million and making us awesome in excel

[ljubicar]

This video is a genuine treasure! Thanks a lot!