Course Description
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
Curriculum
Top 10 macro
% of Column Total
% of Row Total
Average
BONUS: EXCEL RESOURCE BLOG
Break Even Model
CASE STUDY ~ ACCOUNTING: Creating a P&L Pivot Table Report
CASE STUDY ~ ACCOUNTING: Live forecasting with GETPIVOTDATA
CASE STUDY ~ ACCOUNTING: Quarterly Comparative Report
CASE STUDY ~ ACCOUNTING: Select a Monthly P&L report with a Slicer
CASE STUDY ~ FINANCIAL: Actual v Plan Variance Report
CASE STUDY ~ FINANCIAL: Conditionally Format your sales results
CASE STUDY ~ FINANCIAL: Pivot Table Slicer & Chart Dashboard
Change Sum views in Label areas
Compatibility Issues with Excel 2007 and Excel 2010
Consolidate with a Pivot Table
Control Conditional Formatting with Slicers
Count
Create a custom report with GETPIVOTDATA
Create multiple subtotals
Creating a Calculated Field
Creating a Calculated Item
Customising a Pivot Table Style
Data Bars, Color Scales & Icon Sets (NEW IN EXCEL 2010)
Define when to use the GETPIVOTDATA function
Difference From
Different pivot table views macro
Different ways to filter a Slicer
Downloadable Workbooks
Drill down to audit
Excel formulas & Calculated Fields
Excel Tables
EXCEL WITH EXCEL PIVOT TABLES: Course Content
EXCEL WITH EXCEL PIVOT TABLES: Discount Coupon
Filter by Dates
Filter by Labels - Text
Filter by Text wildcards * and ?
Filter by Values
Filter by Values - Top or Bottom %
Group by Date
Group by Quarters & Years
Group by Text fields
Grouping by a custom date
Grouping by a Sales ranges
Identify the step to insert a Color Scale
Identify the steps to creating a Custom List
Identify the steps to showing the values as a Year to Date accumulation
Include a Sparkline with your pivot table
Insert a Pivot Chart
Insert a Slicer
Insert a Slicer with a Pivot Chart
Inserting a Pivot Table
Interactive Balance Sheet Pivot Table
Intro to Conditional Formatting
Intro to GETPIVOTDATA
Monthly Sales Manager Performance Report
Recall how to assign a macro
Recall how to connect multiple Pivot Tables to a Slicer
Recall the command to search for a wildcard entry
Recognize the shortcuts to show the Summarize Values By option
Recognize which button is used to update a Pivot Table
Refresh
Running Total In (Year To Date)
Saving a Pivot Chart template
Section 1: DOWNLOADABLE WORKBOOKS
Section 10: PIVOT CHARTS
Section 11: CONDITIONAL FORMATTING PIVOT TABLES
Section 12: GETPIVOTDATA Formula
Section 13: MACROS & PIVOT TABLES
Section 14: DATA MANAGEMENT
Section 15: BONUS VIDEOS
Section 2: CUSTOMISE YOUR PIVOT TABLE
Section 3: VALUE FIELD SETTINGS > SUMMARIZE VALUES BY
Section 4: VALUE FIELD SETTINGS > SHOW VALUES AS
Section 5: GROUPING
Section 6: SORTING
Section 7: FILTERING
Section 8: SLICERS (NEW IN EXCEL 2010)
Section 9: CALCULATED FIELDS & ITEMS
Sharing a Pivot Table via OneDrive
Shortcuts to Field & Value Field Settings
Show report filter on multiple pages
Show various Grand Totals
Slicer Connections for multiple pivot tables
Sort Field List from A to Z
Sort manually (drag, write, right click)
Sort using a Custom List
Sorting by Largest or Smallest
State the button to format a Pivot Chart
State the steps to creating a Calculated Item
State the steps to share a Pivot Table via Microsofts OneDrive
State which command is used to group a PivotTable report by weeks
Tabular Format
THANK YOU!
Top & Bottom Rules
LINK FOR THE FREE COURSE
100% Off, Udemy 100% Off, Udemy Coupon, Udemy Coupon Code, Udemy course, Udemy course download, Udemy course reviews, Udemy courses, Udemy courses for free, Udemy courses free, Udemy courses free download, Udemy discount, Udemy download, Udemy education, Udemy free, Udemy free course, Udemy free courses, Udemy free online courses, Udemy online, Udemy online course, Udemy online courses, Udemy online courses review, Udemy reviews, Udemy tutorial, Udemy tutorials, Udemy.com free courses,
