Excel Pivot Table Reports: Beginner to Expert in 2 hr 30 min

Focused View

Ian Stables

2:28:46

84 View

1. Introduction

1. Introduction.mp4

06:10

2. Download the Excel spreadsheet to follow along

1.1 pivottablecourse.csv

1. Download the Excel spreadsheet to follow along.html

3. You must do these simple things first

1. What headings you need.mp4

02:33

2. What you must remove or it wont work.mp4

02:43

3. You must do this with blank cells.mp4

02:43

4. The formatting you must have.mp4

04:50

4. How to create Pivot tables in seconds

1. How to create a Pivot table in seconds.mp4

04:48

2. Understand the editor window #1.mp4

02:31

3. Understand the editor window #2.mp4

04:30

4. Understand the editor window #3.mp4

06:30

5. How to quickly get different calculation results

1. How to easily and quickly change calculations.mp4

06:31

2. How to show different calculations side by side.mp4

08:18

6. How to easily get any information needed

1. How to easily know what information you need.mp4

03:20

2. Best way to display your information.mp4

05:45

3. Special tool to answer more complex questions #1.mp4

05:51

4. Special tool to answer more complex questions #2.mp4

06:27

5. Special tool demonstration.mp4

04:57

6. Tool that quickly shows different time periods.mp4

05:19

7. How to easily create and use it.mp4

07:05

7. How to make reports easier to read

1. The best layout to use.mp4

06:20

2. Styles that make Pivot tables look professional.mp4

03:47

3. Quick way to make it much easier to read.mp4

03:17

4. Two more quick ways to make it more readable.mp4

05:31

5. How to format numbers.mp4

02:57

6. How to keep heading visible when you scroll.mp4

06:35

8. Use charts to instantly show needed information

1. Charts and graphs give needed information instantly.mp4

04:58

2. How to quickly create professional looking charts.mp4

04:02

3. Best way to remove limitation and use all Excel charts.mp4

06:55

4. How to quickly make charts look professional.mp4

06:48

9. Automatically keep Pivot tables up to date

1. Automatically keep Pivot tables up to date.mp4

04:30

10. Conclusion

1. Conclusion.mp4

02:15

Description

Learn easiest fastest way to create pivot table reports and graphs that calculate and present ANY information needed

What You'll Learn?

Create Pivot tables in seconds
Calculate anything you want
Get any information you need using Pivot tables
Presentation information so it's easily understable
Create professional looking Pivot table reports and graphs

Who is this for?

Ideal of people with little or no understanding of Pivot table

People who would benefit from getting useful information for their business

People in an occupation where analytical reports are needed

Individuals who use Excel and want to gain information that will help them

More details

Description
Have you seen courses that spend many hours teaching you how to use Pivot tables? Do you need to learn many different options that do the same thing? The truth is, you don't.
You don't need to know everything to become an expert with Pivot tables. You only need to know the easiest and fastest options to be a Pivot table expert.
That's why I've designed this course to be the fastest and easiest way for beginners to become experts in creating pivot table reports and graphs that calculate and present any information needed. I've spent almost a year researching and finding out what the easiest and fastest options are. You'll learn everything you need to know in just two and a half hours.
You'll be able to create Excel Pivot table reports and charts that give you ANY information in seconds... using my simple and easy process, taught in this course. This works for me... and it will work for you.
When I first heard about Pivot tables, I didn't have a clue what they were or why you should use them. I remember thinking they were something complicated, especially when I tried to create my first one.
I watched a few Youtube videos to find out what the benefit of these things were. The big one that stood out for me was you can easily get calculations that would be complicated and time consuming using Excel formulas.
I went on to learn how to create and use them. But all the books made it look very complicated.
I learned and tried everything I learned. Eventually, I knew enough to make the process super easy. So I created a step-by-step process for quickly and easily creating Pivot tables that could get any information, no matter how complicated.
You can learn the simple process in this course. Here are the steps you'll learn:
How to create a Pivot table in seconds. I really simplify everything for you
- Must Do Preparation... Four simple things to make sure your Pivot table will work properly
- The Two Click Creation Method... the fastest way to create a Pivot table
- The Editor Made Simple... the boxes that look complicate will be easy for you

How to quickly get any calculation result you want
- Calculation Fast Change... how to quickly change the calculation results you want.
- Side-by-side Calculations... find out how to show different calculations next to each other for easy comparison.

How to easily get whatever information you need to show, no matter how complicated
- Information Needed Finder... simple easy way to find out what information you need, no matter the question, and the best way to display it
- Special Complicated Questions Tool... this allows you to have many different elements and keep your Pivot table easy to read and fit on the screen
- The Time Tool... easily and quickly show different time periods

How to display information so you and others instantly see what you need to see
- Easy to Read Table Methods... make the pivot table easier to read and look more professional
- They Get Information Needed Instantly... how to show Pivot table information in a way you and others instantly get the info they want

Automatically update your Pivot table every time your Excel spreadsheet changes
- The Pivot Table Update Trick... How to easily make your Pivot table update when your Excel spreadsheet changes
I'm here to give you my personal help
If you need any help, just post your question in the Q&A section in the course.
I'll get back to you as soon as I can. I usually respond the same day. Sometimes it may be a few days. But I will definitely answer your qeustions.
So learn to be an Excel Pivot table expert. Just click on the enrol button now.

Who this course is for:
Ideal of people with little or no understanding of Pivot table
People who would benefit from getting useful information for their business
People in an occupation where analytical reports are needed
Individuals who use Excel and want to gain information that will help them

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Ian Stables

Instructor's Courses

"Always be learning."Teaching more than 100,000 students. "I love to find better, easier, faster, and more efficient ways to do things. I then like to help others by sharing my discoveries.""You can do anything, within reason. You just need to know how."I want to help as many people as possible with what they want to improve in their lives. I have done that through my writing since 2001.Would you like to make nonfiction book writing easy? This is what my first course, Write In Steps, does.More courses to come.My history:I gave my first talk when I was aged twelve. This was in front of over one hundred people. I followed a program designed to improve public speaking and teaching.I learned computing and went on to develop a computer system to run a business in herbs and spices. This was designed to allow complete novices to generate customer orders and delivery notes. It then allows the finished order to be processed and then invoiced. I'm telling you this because I want you to understand something. I have always been keen on learning new things. Not only that, but I like to make things work better. So when I found writing books hard, I started to improve my system. The result is that I now have a system that is streamlined and far more efficient. It allows me to produce quality books that readers gain great benefit.Part of my innovative mentality means that I am always reading about new ideas. I have also learned a lot by viewing instructional videos on Udemy, Youtube, and the like. There's always something new to learn. I take the best from everything and re-assemble it into a better improved process. I temper it with my own personal experience. Continue to make further improvements. Finally, as I like to help others, I teach this knowledge on via books and now video. I started writing content for the internet in 2001. In 2012 I wrote my first Kindle book, which was published on Amazon.I have had several best-sellers. My first one was The Easy Way To Clean. It remained my best-selling title for around two years. I currently have more than fifty titles published.My aim is to help as many people as possible with my experience and knowledge. I also aim to encourage many others to share their knowledge.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.