Excel Pivot Tables | A Quick Start Guide – Free Udemy Courses

Excel Pivot Tables | A Quick Start Guide â€“ Free Udemy Courses

Learn Excel Pivot Tables in an easy-to-understand courseâ€¦

What youâ€™ll learn

Excel Pivot Tables | A Quick Start Guide â€“ Free Udemy Courses

• This course is designed as a launching pad for students who want to grasp the fundamentals of Excel Pivot Tables.
• Learn how to use many of the features Pivot Tables have to offer.
• How to analyze large lists of data quickly and easily with Pivot Tables.

Requirements

• No, not really. Some familiarity with excel helps, but overall not required. ????

Description

Pivot Tables are an extremely powerful tool in Excel

and a skill that employers crave

!

If you are brand new to Pivot Tables then this course is for you. And by chance youâ€™ve been working with them for a while, you may benefit as well.Â  ????

This course starts by giving you the fundamentals of pivot tables and presents the topics in short, fun, easy-to-follow videos. From there we move into working with calculations/ formulas, the ever-cool slicer, and charting, and conclude the class with some fun miscellaneous topics.

Please note: this course has been designed to provide as much information about Excel Pivot tables as the time constraints allow.Â  Granted many topics can be explained much more in-depth, yet that is

not

how this course was designed.Â  Rather the goal was to be as comprehensive and to cover as much ground as possible.Â  ????

By the way, did you know that only 5% of Excel users know how to make Pivot Tables?*Â  So you are about to join an exclusive club! ????

Who will benefit from this course?

If you use large lists of data and are interested in learning the story behind the data then Pivot Tables are the way to go! Excel Pivot Tables provide quick, accurate, and intuitive insight into your data and can provide answers to even the most complicated of analytics tasks.

Do you need previous experience with Excel to take this course?

Not really. Therefore if you have experienced great, if not as long as youâ€¦

1. Can select cells on a spreadsheet
2. Have a basic understanding of formulas in Excel
3. Able to navigate between sheets
4. Somewhat familiar with sorts and filters (if not, thatâ€™s okay since we give a brief explanation)

All things consideredâ€¦ youâ€™ll be just fine.Â  ????

Technical Requirements

• Mac users are welcome, but be aware your screen will be somewhat different

Course Progression

• Overview of source data and basic Pivot Table fundamentals
• Learning simple then advanced formulas used within Pivot Tables
• What are slicers and how to use them, including how to connect slicers to multiple Pivot Tables (yepâ€¦ you read that right.)

Pivot charts

• Concluding with some miscellaneous topics including filter reports and the GETPIVOTDATA function

Conclusion

So if youâ€™re looking for a Pivot Table fundamental class, want to broaden your existing skills in Excel, or have a need to develop your analytical skills- this class has something for you because knowing Pivot Tables can give you the extra advantage in developing your career.

*Â Source:Â  Power Pivot and Power BI: The Excel Userâ€™s Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016; Collie, Singh 2016

Who this course is for:

• Is anyone new to Pivot Tables
• This course is intended for anyone who wants to learn a very in-demand skill.
• Experienced Excel users who want to be more competent in data/ list analysis
• Anyone looking to begin a career in business intelligence/ data science

Udemy Free Courses