Excel with Excel Pivot Tables: Beginners
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.
Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
***** 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
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: DOWNLOADABLE WORKBOOKS|
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 BLOGPreview
|Section 2: CUSTOMISE YOUR PIVOT TABLE|
Inserting a Pivot TablePreview
Drill down to audit
Sort Field List from A to Z
Customising a Pivot Table Style
Change Sum views in Label areas
Show report filter on multiple pages
Recognize which button is used to update a Pivot Table
|Section 3: VALUE FIELD SETTINGS > SUMMARIZE VALUES BY|
Create multiple subtotalsPreview
Show various Grand Totals
Shortcuts to Field & Value Field SettingsPreview
Recognize the shortcuts to show the Summarize Values By option
|Section 4: VALUE FIELD SETTINGS > SHOW VALUES AS|
% of Column Total
% of Row Total
Running Total In (Year To Date)Preview
CASE STUDY ~ FINANCIAL: Actual v Plan Variance Report
Identify the steps to showing the values as a Year to Date accumulation
|Section 5: GROUPING|
Group by Date
Group by Quarters & YearsPreview
Grouping by a Sales ranges
Group by Text fields
Grouping by a custom date
CASE STUDY ~ ACCOUNTING: Quarterly Comparative Report
State which command is used to group a PivotTable report by weeks
|Section 6: SORTING|
Sorting by Largest or Smallest
Sort manually (drag, write, right click)
Sort using a Custom List
Identify the steps to creating a Custom List
|Section 7: FILTERING|
Filter by DatesPreview
Filter by Labels - Text
Filter by Values
Filter by Values - Top or Bottom %
Filter by Text wildcards * and ?
Recall the command to search for a wildcard entry
|Section 8: SLICERS (NEW IN EXCEL 2010)|
Insert a SlicerPreview
Slicer Connections for multiple pivot tables
Different ways to filter a Slicer
CASE STUDY ~ ACCOUNTING: Select a Monthly P&L report with a Slicer
Recall how to connect multiple Pivot Tables to a Slicer
|Section 9: CALCULATED FIELDS & ITEMS|
Creating a Calculated FieldPreview
Excel formulas & Calculated Fields
Creating a Calculated Item
CASE STUDY ~ ACCOUNTING: Creating a P&L Pivot Table Report
State the steps to creating a Calculated Item
|Section 10: PIVOT CHARTS|
Insert a Pivot ChartPreview
Insert a Slicer with a Pivot Chart
Saving a Pivot Chart template
Include a Sparkline with your pivot table
CASE STUDY ~ FINANCIAL: Pivot Table Slicer & Chart Dashboard
State the button to format a Pivot Chart
|Section 11: CONDITIONAL FORMATTING PIVOT TABLES|
Intro to Conditional Formatting
Top & Bottom Rules
Data Bars, Color Scales & Icon Sets (NEW IN EXCEL 2010)Preview
Control Conditional Formatting with Slicers
CASE STUDY ~ FINANCIAL: Conditionally Format your sales results
Identify the step to insert a Color Scale
|Section 12: GETPIVOTDATA Formula|
Intro to GETPIVOTDATAPreview
Create a custom report with GETPIVOTDATA
CASE STUDY ~ ACCOUNTING: Live forecasting with GETPIVOTDATA
Define when to use the GETPIVOTDATA function
|Section 13: MACROS & PIVOT TABLES|
Different pivot table views macro
Top 10 macro
Recall how to assign a macro
|Section 14: DATA MANAGEMENT|
Compatibility Issues with Excel 2007 and Excel 2010
Sharing a Pivot Table via OneDrive
State the steps to share a Pivot Table via Microsofts OneDrive
|Section 15: BONUS VIDEOS|
Consolidate with a Pivot Table
Break Even Model
Interactive Balance Sheet Pivot Table
Monthly Sales Manager Performance Report
EXCEL WITH EXCEL PIVOT TABLES: Course ContentPreview
DOWNLOADABLE PDF OFFER >>> CLICK ON THE DOWNLOAD LINK ON THE RIGHT HAND SIDE OF YOUR LECTURE PANEL, WHICH IS THE SECOND ICON ON THE TOP.
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!