Excel with Excel Pivot Tables: Beginners
4.6 (38 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,705 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel with Excel Pivot Tables: Beginners to your Wishlist.

Add to Wishlist

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.6 (38 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,705 students enrolled
Created by John Michaloudis
Last updated 11/2016
English
Current price: $10 Original price: $190 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • 1 Article
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
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
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
Who is the target audience?
  • New users, beginners and intermediates Excel users
Compare to Other Excel Courses
Curriculum For This Course
67 Lectures
03:58:36
+
DOWNLOADABLE WORKBOOKS
2 Lectures 00:30

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

Downloadable Workbooks
00:30

+
CUSTOMISE YOUR PIVOT TABLE
9 Lectures 19:48

Excel Tables
02:46


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
+
VALUE FIELD SETTINGS > SUMMARIZE VALUES BY
5 Lectures 11:49

Count
02:27

Average
02:43

Show various Grand Totals
02:36


Recognize the shortcuts to show the Summarize Values By option
1 question
+
VALUE FIELD SETTINGS > SHOW VALUES AS
6 Lectures 20:10
% of Column Total
02:15

% of Row Total
01:55

% Of
04:03

Difference From
04:54


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
+
GROUPING
6 Lectures 18:42
Group by Date
02:45


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
+
SORTING
3 Lectures 07:20
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
+
FILTERING
5 Lectures 18:42

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
+
SLICERS (NEW IN EXCEL 2010)
4 Lectures 13:08

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
+
CALCULATED FIELDS & ITEMS
4 Lectures 19:50

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
+
PIVOT CHARTS
5 Lectures 24:19

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
6 More Sections
About the Instructor
John Michaloudis
4.3 Average rating
1,096 Reviews
23,170 Students
4 Courses
Founder of MyExcelOnline | 35,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!