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

• 50% COUPON CODE: UPGRADENOW >>> COURSE: EXCEL WITH EXCEL PIVOT TABLES!
• BONUS: EXCEL RESOURCE BLOG
• 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

### Course Status:

Active

1 - 4 hours / week

This course is listed under Data & Information Management Community

Related Posts: