MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Learn Excel Pivot Tables in Under 3 Hours!

Course Summary

Get Up To Speed With Using Excel Pivot Tables In Less Than 3 Hours!

• +

Course Syllabus

• DOWNLOADABLE WORKBOOKS
• Downloadable Workbooks
• 50% COUPON CODE: UPGRADENOW >>> COURSE: EXCEL WITH EXCEL PIVOT TABLES!
• BONUS: EXCEL RESOURCE BLOG
• CUSTOMISE YOUR PIVOT TABLE
• Inserting a Pivot Table
• Drill down to audit
• Sort Field List from A to Z
• Tabular Format
• Refresh
• Customising a Pivot Table Style
• Change Sum views in Label areas
• Show report filter on multiple pages
• VALUE FIELD SETTINGS > SUMMARIZE VALUES BY
• Create multiple subtotals
• Count
• Show various Grand Totals
• VALUE FIELD SETTINGS > SHOW VALUES AS
• % Of
• Difference From
• Running Total In (Year To Date)
• CASE STUDY ~ FINANCIAL: Actual v Plan Variance Report
• GROUPING
• Grouping by a Sales ranges
• Group by Text fields
• Grouping by a custom date
• SORTING
• Sorting by Largest or Smallest
• Sort manually (drag, write, right click)
• Sort using a Custom List
• FILTERING
• Filter by Dates
• Filter by Labels - Text
• Filter by Values - Top or Bottom %
• SLICERS (NEW IN EXCEL 2010)
• Insert a Slicer
• Slicer Connections for multiple pivot tables
• Different ways to filter a Slicer
• CASE STUDY ~ ACCOUNTING: Select a Monthly P&L report with a Slicer
• CALCULATED FIELDS & ITEMS
• Creating a Calculated Field
• Excel formulas & Calculated Fields
• Creating a Calculated Item
• CASE STUDY ~ ACCOUNTING: Creating a P&L Pivot Table Report
• PIVOT CHARTS
• Insert a Pivot Chart
• 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
• CONDITIONAL FORMATTING PIVOT TABLES
• Intro to Conditional Formatting
• Top & Bottom Rules
• Data Bars, Color Scales & Icon Sets (NEW IN EXCEL 2010)
• Control Conditional Formatting with Slicers
• GETPIVOTDATA Formula
• Intro to GETPIVOTDATA
• Create a custom report with GETPIVOTDATA
• CASE STUDY ~ ACCOUNTING: Live forecasting with GETPIVOTDATA
• MACROS & PIVOT TABLES
• Different pivot table views macro
• Top 10 macro
• DATA MANAGEMENT
• Compatibility Issues with Excel 2007 and Excel 2010
• Sharing a Pivot Table via OneDrive
• BONUS VIDEOS
• Consolidate with a Pivot Table
• Break Even Model
• Interactive Balance Sheet Pivot Table

Course Fee:
USD 89

Self-Study

Active

Workload:

1 - 4 hours / week

This course is listed under Data & Information Management Community

Related Posts:

Data management

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software