Excel Basics 4: PivotTables & SUMIFS Function to Create Summary Reports (Intro Excel #4)

Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
Topics in this video:
1. (00:01) Introduction
2. (01:22) What Excel can do: 1) Calculations, Data Analysis
3. (01:58 and 03:22) What is Data Analysis?
4. (04:00) What is a Proper Data Set?
5. (06:26) SUMIFS for Regional Sales Report, Daily Sales Report and Sales Rep Report
6. (18:32) PivotTable for Regional Sales Report, Daily Sales Report and Sales Rep Report
7. (21:31) Format PivotTable with Tabular Layout
8. (22:18) Add Number Formatting to Values area
9. (30:00) Compare SUMIFS and PivotTable
10. (32:40) Summary - Conclusion
PivotTable Basics, PivotTables 101, PivotTable Lessons, Free PivotTable Lessons, Learn PivotTables Quickly, Efficient PivotTables, PivotTables Are Easy!

[sirishavalluri]

They say life changing stuff is priceless. Here is an unsung hero changing lives who does not even look for a monetary benefit in it. Passion personified. I was losing interest in learning and then I stumbled upon your videos. Thank you, a big salute to you from an Indian.

[Niteshkumar-ncbh]

I am big fan of your lectures. It is very difficult to find good teacher who can guide to achieve your dream. I am very lucky to find you. Thanks for your amazing lectures.

[ScooterMcGraw]

Simply the best on YouTube. The Earl of Excel. The Duke of Data. The Marquis of Microsoft. Well, you get the idea.

[andreacarr]

I absolutely LOVE how you explain WHY things are done in a certain way. So many tutorials simply tell you WHAT to do but don't explain WHY it's done that way. Knowing why is what makes me understand and remember it.

[The_Mercenary_Sigma]

Thank You very much. Even in 2024, your lectures are the best.

[ekaterinaelos]

Many people have an exceptional IT knowledge nowadays, but not many can have such an amazing, clear, non-arrogant way of teaching and spreading knowledge around! TAKES A MASTER TO DO THIS! THANK

[AakashSawant]

That's certainly the first time I clearly understood the idea of using Pivot tables and comparing it with the tables created using formulae.

[mhf]

I wished I learned Excel from Michael. My long journey started from Lotus 1-2-3, (pre YouTube) and self-taught from the dummy book. ExcelsFun channel is not only educational, but seriously fun just listening Michael talking.

[bravo]

This is hands down the best excel course available in YouTube. If I could sub more than once I would.

[willjones]

You are an absolute GOAT, first paycheck i get im donating some money to you or a charity of your choice!

[AoiTodo]

man you are not normal human, you are genius, and the Written notes for this course is amazing !!

[miguelangelsanchezperez]

I've been using EXCEL for a long time, and there are some points that I didn't know about until I started watching this video list. Great work!

[MrLnkry]

I'm 16 and my dad told me learning excel is probably something i should do because of how useful it is, i searched a bit to see which would be the best resource to learn (paid or free) and saw you listed everywhere, and now i can see why, i have done a lot of courses on a lot of different subjects, and this is by far the best course i've ever seen on any topic, thanks for everything.

[heitchgeeeeeee]

I've been watching your videos to prepare for a Business Analyst job which I start next week, and I must say, your videos are by far the best learning tool I've come across for excel. I've previously done paid courses at the advice of employers (at my own cost, and they are hundreds of dollars!) which have been slow and ineffective as I end up forgetting half of the things I learn because I didn't use it in work. Basically, THANKYOU!!! I will be forever recommending your channel to anyone who needs it. You are doing a huge public service by providing your material for free and providing interesting and clear lessons. You are changing the game!!

[mosesruharo]

When I think of Microsoft tutorials, I look no further than ExcelisFun!!! You're one heck of a teacher!

[noblefrend]

Have always wanted to learn Excel, but felt reluctant because I thought it was too daunting. However, these videos and the mode of delivery, make it look like a walk in the park. I'm impressed and indeed, thankful.

[karadanae]

I can't believe you actually made excel interesting.

[sharonhanany]

I have been trying to locate an online Excel course which uses the correct terminology, keeps it interactive and I can actually practice it during the class. Mr. Girvin's class covers all the criteria and I am finally starting to understand and practice this VERY important skill. This instructor rocks it!

[jonathancastro]

Never thought my jaw would be dropping learning what a pivot table does but here I am. For years I’ve been wanting to learn how to use Excel and these videos have made that incredibly easy. Thank you for making these videos!

[SK-bvyd]

Seriously, you are the best one ever! I was literally a computer illiterate, then I got covid, which gave me a hard time for a long time, and while in bed, I decided to learn Excel. I watched other Excel videos from Youtube, then I stumbled upon yours, and I'm just beyond impressed!! Hopefully I can succed in career transition:)(I"m a nurse with lots of health issues)