Master Microsoft Excel Pivot Tables

Pivot Tables: Learn to create a stunning Microsoft Excel 2013 Pivot Table and become prepared for your next job!
4.4 (4 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,073 students enrolled
$19
$70
73% off
Take This Course
  • Lectures 28
  • Length 1 hour
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 10/2015 English

Course Description

This course is a crash course on Excel 2013 Pivot Tables. It is intended for people who want to master Excel reports at work and want to learn how to create amazing professional reports using an Excel Pivot Table.

I focused to include in just 1 hour the essentials of creating a pivot table, formatting, customizing it and make it look great by adding advanced slicers and pivot charts.

By taking it, you will be able to understand in the step by step demonstrations and master by yourself everything you need to confidently create your own pivot tables and present the Excel data you manipulate at work in a profesional way.

My name is Florin Rosoga, I started working with Excel and pivot tables with the '95 version, almost 20 years ago.

In all the companies I was later involved, managing data was essential. I learned how to manage, manipulate and present it in a way easy to understand that synthesize the essential of it and make it easy to understand in seconds.

In this course you will get step by step video explanations to help you understand in a comfortable way all about pivot tables in less than 1 hour.

The entire ourse can be downloaded as a video training and also as audio files to watch or listen it in your own pace and whenever it suits you better... just like a podcast.

To start mastering a pivot table, here's what you need to do next... click the Take this Course button top right and you'll be taken to our secure payment page.

Just Enter Your Regular Details and complete your investment to have immediate access.

Stop struggling with your pivot tables and start mastering Excel's most advanced features now!

Thank you for reading this and learning about my course ... I hope what I will teach you when you will start the course will help you make a huge performance leap! Click now on TAKE THIS COURSE to get started!

What are the requirements?

  • Microsoft Excel 2013, which is used in this course. In most cases, a previous version of Excel will work fine.

What am I going to get from this course?

  • Create pivot tables, customize them, create advanced reports from an Excel table using a Pivot Table.

What is the target audience?

  • People that work with Excel and need to master Pivot Tables at job.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Introduction
Preview
02:18
Welcome
Article
Used Workbooks
Article
Section 1: Pivot Tables Essentials
Creating a Pivot Table
Preview
02:03
Creating Pivot Tables by Using Excel's Recommended
Preview
01:01
Formatting Pivot Tables
Preview
02:18
04:18

Filter the pivot table to show only the data you are interested in

Sorting Pivot Tables
01:15
How are you?
Article
Summarize Values
01:31
Grouping
02:21
Section 2: Pivot Tables Advanced Features - Learn to Work With a Pivot Table Like a Pro!
02:20

Let's see how to add custom calculated fields using any Excel formula

Slicers
02:22
Pivot Charts
01:37
Section 3: Bonus
11:49

Comlete description of available pivot tables options and customizations

Still Having Questions?
Article
Section 4: Bonus Resources & Downloads
Creating a Pivot Table
02:03
Using Recommended Pivot Tables
01:01
Formatting Pivot Tables
02:18
Filtering a Pivot Table
04:18
Sorting Pivot Tables
01:15
Summarizing a Pivot Table
01:31
Using Calculated Fields
02:20
Grouping
02:21
Using Slicers
02:22
Pivot Charts
01:37
Pivot Tables WalkThrough
11:49
Finished? Great! Here's how to Get Your Personal Certificate of Completion...
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Florin Rosoga, Udemy Instructor Teaching 17K+ Students

Florin is an online business consultant, coach and author. His personal development blogging has won him over 3 million hits in 2015 and his drive to inspire and educate others on how to succeed online is his passion.

With more than 5 years of experience in the online marketing world, Florin has made a big impact on the self-help and blogging movement in Romania. He is the author of several bestselling books on how to use personal development to grow your business.

With expertise in Wordpress blogging, podcasting, social media and email marketing, Florin works as consultant, with a range of clients from trainers, coaches, instructors, consultants and bloggers to authors and small business owners.

His current focus is helping his clients develop and promote their coaching programs and online products. Living in a peaceful city located in Transylvania, Florin is a member of several business mastermind groups around the world and loves nothing more than to share his expertise and share in other's success.

Ready to start learning?
Take This Course