Excel with Excel Pivot Tables: Beginners

Get Up To Speed With Using Excel Pivot Tables In Less Than 3 Hours for Pivot Table newbies!
4.3 (28 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.
3,644 students enrolled
$19
$90
79% off
Take This Course
  • Lectures 67
  • Length 4 hours
  • 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 7/2014 English

Course Description

***** COURSE UPDATED: March 2015 ~ 12 extra tutorials plus 13 Quizzes! *****

If you are a Pivot Table beginner/newbie/virgin, then you are sure to benefit from this course which goes through the most important features & tools available in an Excel Pivot Table. The course is designed for Excel 2007, 2010 or 2013.

In no time you will be able to analyze lots of data and tell a story in a quick and interactive way, learn how to build stunning Dashboards and get noticed by top management & prospective employers.


There are 14 different chapters which includes over 60 short tutorials so you can work on your weaknesses and enhance your strengths whenever you have a spare moment. Each chapter was designed to improve your Pivot Table skills with extra time saving Tips and real life business Case Studies.

This course is a prequel to my popular Udemy course Excel with Excel Pivot Tables!

I have been helping thousands of people further their careers by teaching them Excel the easiest and most comfortable way. These tutorials will give you career-building skills that you can use to become better and more efficient at your job.

If you really want to stand out from your colleagues and improve your professional development to achieve greater opportunities like promotions, a higher salary, knowledge that you can take to another job, etc.....then this is the course for YOU!

You'll have lifetime online access to watch the videos whenever you like, and there's a Q&A forum right here on Udemy where you can post questions - and I'll answer them personally within the day!

I am so confident that you will get lots of value from this course that you can take it for the full 30 days, study it and apply it to your work to see the results. If you're not 100% satisfied, I am more than happy to refund the full purchase amount!

So go ahead and learn from the following Pivot Table subjects and click the TAKE THIS COURSE button, top right, NOW... every hour you delay is delaying your professional progress ...

1 CUSTOMISE YOUR PIVOT TABLE 2 VALUE FIELD SETTINGS > SUMMARIZE VALUES BY 3 VALUE FIELD SETTINGS > SHOW VALUES AS 4 GROUPING 5 SORT 6 FILTER 7 SLICERS (NEW IN EXCEL 2010) 8 CALCULATED FIELDS & ITEMS 9 PIVOT CHARTS 10 CONDITIONAL FORMATTING PIVOT TABLES 11 GETPIVOTDATA formula 12 MACROS 13 DATA MANAGEMENT 14 BONUS VIDEOS

What are the requirements?

  • Excel 2007, 2010 & 2013. This course was recorded using Excel 2010 but all the concepts taught are compatible with Excel 2013 and 2007.
  • Some concepts are not available in Excel 2007, like Slicers and some Pivot table calculations, but this is highlighted in the Course Outline
  • Microsoft & Apple compatible

What am I going to get from this course?

  • Analyze thousands of rows of data in to a simple one page table
  • Build interactive Dashboards with Slicers & Charts
  • Inform your business management of key financial trends & metrics

What is the target audience?

  • New users, beginners and intermediates Excel users

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

Section 1: DOWNLOADABLE WORKBOOKS
Article

Download all workbooks from this course. The link is located on the top right hand section of this page (second icon from the left).

BONUS: EXCEL RESOURCE BLOG
Preview
1 page
Section 2: CUSTOMISE YOUR PIVOT TABLE
Tabular Format
Preview
02:25
Excel Tables
02:46
Inserting a Pivot Table
Preview
03:22
Drill down to audit
01:42
Sort Field List from A to Z
00:45
Refresh
01:20
Customising a Pivot Table Style
04:13
Change Sum views in Label areas
00:52
Show report filter on multiple pages
02:23
Recognize which button is used to update a Pivot Table
1 question
Section 3: VALUE FIELD SETTINGS > SUMMARIZE VALUES BY
Create multiple subtotals
Preview
01:44
Count
02:27
Average
02:43
Show various Grand Totals
02:36
Shortcuts to Field & Value Field Settings
Preview
02:19
Recognize the shortcuts to show the Summarize Values By option
1 question
Section 4: VALUE FIELD SETTINGS > SHOW VALUES AS
% of Column Total
02:15
% of Row Total
01:55
% Of
04:03
Difference From
04:54
Running Total In (Year To Date)
Preview
02:20
CASE STUDY ~ FINANCIAL: Actual v Plan Variance Report
04:43
Identify the steps to showing the values as a Year to Date accumulation
1 question
Section 5: GROUPING
Group by Date
02:45
Group by Quarters & Years
Preview
01:48
Grouping by a Sales ranges
03:19
Group by Text fields
02:16
Grouping by a custom date
01:49
CASE STUDY ~ ACCOUNTING: Quarterly Comparative Report
06:45
State which command is used to group a PivotTable report by weeks
1 question
Section 6: SORTING
Sorting by Largest or Smallest
01:59
Sort manually (drag, write, right click)
02:01
Sort using a Custom List
03:20
Identify the steps to creating a Custom List
1 question
Section 7: FILTERING
Filter by Dates
Preview
06:48
Filter by Labels - Text
02:43
Filter by Values
03:58
Filter by Values - Top or Bottom %
01:46
Filter by Text wildcards * and ?
03:27
Recall the command to search for a wildcard entry
1 question
Section 8: SLICERS (NEW IN EXCEL 2010)
Insert a Slicer
Preview
04:01
Slicer Connections for multiple pivot tables
03:24
Different ways to filter a Slicer
01:23
CASE STUDY ~ ACCOUNTING: Select a Monthly P&L report with a Slicer
04:20
Recall how to connect multiple Pivot Tables to a Slicer
1 question
Section 9: CALCULATED FIELDS & ITEMS
Creating a Calculated Field
Preview
04:06
Excel formulas & Calculated Fields
03:07
Creating a Calculated Item
04:12
CASE STUDY ~ ACCOUNTING: Creating a P&L Pivot Table Report
08:25
State the steps to creating a Calculated Item
1 question
Section 10: PIVOT CHARTS
Insert a Pivot Chart
Preview
03:24
Insert a Slicer with a Pivot Chart
02:00
Saving a Pivot Chart template
01:36
Include a Sparkline with your pivot table
01:24
CASE STUDY ~ FINANCIAL: Pivot Table Slicer & Chart Dashboard
15:55
State the button to format a Pivot Chart
1 question
Section 11: CONDITIONAL FORMATTING PIVOT TABLES
Intro to Conditional Formatting
02:43
Top & Bottom Rules
03:32
Data Bars, Color Scales & Icon Sets (NEW IN EXCEL 2010)
Preview
05:49
Control Conditional Formatting with Slicers
02:54
CASE STUDY ~ FINANCIAL: Conditionally Format your sales results
03:32
Identify the step to insert a Color Scale
1 question
Section 12: GETPIVOTDATA Formula
Intro to GETPIVOTDATA
Preview
04:59
Create a custom report with GETPIVOTDATA
05:24
CASE STUDY ~ ACCOUNTING: Live forecasting with GETPIVOTDATA
07:24
Define when to use the GETPIVOTDATA function
1 question
Section 13: MACROS & PIVOT TABLES
Different pivot table views macro
04:43
Top 10 macro
03:30
Recall how to assign a macro
1 question
Section 14: DATA MANAGEMENT
Compatibility Issues with Excel 2007 and Excel 2010
01:19
Sharing a Pivot Table via OneDrive
02:49
State the steps to share a Pivot Table via Microsofts OneDrive
1 question
Section 15: BONUS VIDEOS
Consolidate with a Pivot Table
04:46
Break Even Model
03:04
Interactive Balance Sheet Pivot Table
12:21
Monthly Sales Manager Performance Report
04:35
Section 16: BONUS: MY COMPREHENSIVE EXCEL PIVOT TABLE COURSE
08:28

Dear Valued Student,

First of all I would like to thank you for purchasing the  Excel With Excel Pivot Table Beginners.

I know that you have learned some new tricks that will make you better at Excel, so you can show off to your colleagues and boss!

With this course you have only just scratched the tip of the iceberg!

The next step in advancing your Excel skills and taking your Pivot Table analysis to the next level is the Xtreme Pivot Table Online Course!

This is an AWESOME course...especially considering you will be able to get all of the below from this online course:

 

  • Lifetime Online Access + Course Updates so you can view at any time and are up to date with new Pivot Table features;
  • 14 chapters ranging from Analysis, Slicers, Pivot Charts, Conditional Formatting & Macros with over 200 videos and 10+ hours of content
  • Downloadable Excel Workbooks so you can follow along & practice or skip directly to the answers
  • Downloadable MP4 Videos to keep on your desktop and view the course offline or when travelling
  • Certificate of Completion to enrich your CV/Resume as well as add to your LinkedIn profile
  • 7 x Limited Time Bonuses ($1,193 in value) which include:

·          30 Day Money Back Guarantee so you can view the course without any risk

·         Course Bonus #1 ($490 Value): 12 Months of Dedicated Pro-Level Email Support

·         Course Bonus #2 ($197 Value): 25% Lifetime Discount on Any MyExcelOnline.com Courses

·         Course Bonus #3 ($25 Value): Power Pivot & Power BI Downloadable E-Book

·         Course Bonus #4 ($90 Value): Pivot Table Cheat Sheet, Workbook Progress Tracker & Top 20 Keyboard Shortcuts

·         Course Bonus #5 ($197 Value): Pivot Table webinar replay

·         Course Bonus #6 ($97 Value): Intro to Power Query Online Course

·         Course Bonus #7 ($97 Value): Intro to Power Pivot Online Course

STUDENT TESTIMONIALS:

 

“I have learned more about Pivot Tables within a week of taking this course than I have over the last couple of years. Really amazing stuff!” Joyce – England

 

“This is the best Excel course that I have taken! It not only talks about Pivot Tables in great detail, it also touches on charts, conditional formatting and macros. I can also track my progress and enter in Discussions with the lecturer who is always quick to respond. Excellent course for any Excel level” Jose - Spain

 

“This course is tremendously comprehensive. The best part is that the course is served in small bite-sized pieces that are easily digested. A teaching course that doubles as a reference guide. Definitely worth your time and money” James - USA

 

Now I want you to become better at your job and by taking this course you will be able to analyze data quicker, prepare awesome looking reports & interactive dashboards that will make you a key part of your team!

 

If you really want to stand out from your colleagues and improve your professional development to achieve greater opportunities like promotions, a higher salary, knowledge that you can take to another job, etc.....then this is the course for YOU!

 

Get off the fence and get started NOW and join over 14,000 professionals who have taken this course and enhanced their Excel skills. Every hour you delay is delaying your professional progress.

UDEMY STUDENT DISCOUNT:

As a valued Udemy student you get lots of benefits and this is no exception! You will get a 25% discount on the course price simply by entering the following coupon code: udemystudent

 

Click the links below to join the course today.  This will take you to a webinar page where you need to enter your details, watch the webinar where you will receive your invitation & special instructions on how to join this course which is open only a few times per year:

 

                                                   Click to join the Xtreme Pivot Table Online Course


If you have any queries please email me at john@myexcelonline.com and I will get back to you asap.  To your success!

Regards,

 

John Michaloudis

JOHN MICHALOUDIS

 

Chief Inspirational Officer

www.MyExcelOnline.com

THANK YOU!
01:26

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

John Michaloudis, Founder of MyExcelOnline | 25,000+ Excel Students

Hello fellow Excel lovers/beginners/experts/users! My name is John and I am a long time lover of Excel.

I hold a bachelors degree in Commerce (Major in Accounting) from La Trobe University in Melbourne, Australia and speak English, Greek and Spanish (and Excel!)

My journey in to Excel began after I graduated and have since helped many of my colleagues around the world understand this underutilized but powerful tool. Now its my turn to teach YOU the power of Excel with these high quality and easy to understand tutorials!

My aim is to get you to become comfortable & confident in Excel and use its power to make your job a lot easier & more efficient, create interactive reports that will reach top management and ultimately make you stand out from your colleagues and get that promotion or pay rise that you deserve!

I have taught over 25,000 students on Udemy alone plus more on my website MyExcelOnline.  I have an active blog where I post free Excel tutorials as well as an Excel podcast where I interview fellow Excel experts & share their insights!

I am currently living in the North of Spain (Basque Country) and I´m married and have one cheeky boy & a newly born baby girl! You could describe me as a football lover, wine & beer drinker, food indulger and occasional gym goer.

Join one of my courses and get ready to change your life!

Ready to start learning?
Take This Course