http://www.quepublishing.co... This video is a summary overview of the complete 7 hour course, Excel PivotTables, PowerPivot, Power View, and Power Map with MrExcel LiveLessons (Video Training) -- 7 Hours of Video Instruction
Explore the most popular and some of the lesser known features of Excel -- PivotTables, PowerPivot, Power View, and GeoFlow with MrExcel as your guide!
• Start-to-finish personal training on Excel 2013: just watch and learn!
• Simple, quick video walkthroughs of the tasks you perform most often!
• Great personalized training at a fraction of the cost...for everyone who doesn't have time to read a book!
These video lessons will ensure that you can harness the power of Excel faster and more easily than ever before! In 89 quick video lessons, Excel PivotTables, PowerPivot, Power View, and GeoFlow with MrExcel shows how to increase your productivity and optimize Excel's best tools and features. Expert Bill Jelen simplifies powerful features including Formatting, Calculations, Sort & Filter, DAX Calculated Fields, Troubleshooting, Animation and more! Truly harness the power built into Excel! Just watch: You'll master high-powered skills at your own pace--and get specific answers and solutions immediately, whenever you need them! For anyone who wants to master Microsoft Excel 2013 fast--from novices to experienced power users.
Part I: The Basics
1 - Use a Pivot Table to Summarize Detailed Data
2 - Your Manager Wants Your Report Changed
3 - Add or Remove Fields from an Existing Pivot Table
4 - Summarize Pivot Table Data by Three Fields
5 - Why Does the Pivot Table Field List Dialog Keep Disappearing?
6 - Move or Change Part of a Pivot Table
7 - Update Data Behind a Pivot Table
8 - Why Does This Look Different from Excel 2003? Return to the Classic Pivot Table Layout
Part II: Formatting
9 - Compare Four Ways to Show Two Values Fields in a Pivot Table
10 - Kill Compact View
11 - Eliminate Blanks in the Outline Format of a Pivot Table
12 - Suppress Grand Totals in a Pivot Table
13 - Replace Blanks in a Pivot Table with Zeros
14 - Specify a Number Format for a Pivot Table Field
15 - Format Pivot Tables with the Gallery
16 - Add a Format to Gallery
17 - Selecting Parts for Formatting
18 - Icon Set in a Pivot Table
Part III: Calculations
19 - Create a Report That Shows Count, Min, Max, Average, Etc
20 - Percent of Parent, Rank, Running Total In
21 - Calculated Fields in a Pivot Table
22 - Add a Calculated Item for Budget - Actuals
23 - Instead of Using Calculated Items Group Text Fields
Part IV: Sort & Filter
24 - Present a Pivot Table in High-to-Low Order by Revenue
25 - Manually Re-sequence the Order of Data in a Pivot Table
26 - Limit a Pivot Report to Show Just the Top 12 Customers
27 - Filtering a Pivot Table
28 - Add Visual Filters to a Pivot Table with Slicers
29 - Timelines vs Multiple Slicers
Part V: Features
30 - See Detail Behind One Number in a Pivot Table
31 - Group Daily Dates by Month in a Pivot Table
32 - Create a Year-over-Year Analysis
33 - Stop GetPivotData from Appearing
34 - Group by Week in a Pivot Table
35 - Group Numbers to Create Frequency Chart
36 - Grouping one pivot table groups all pivot tables; new Cache
Part VI: Uses
37 - Create a Unique List of Customers with a Pivot Table
38 - Use a Pivot Table to Compare Two Lists
39 - Fixing Customer Name problems Using a Pivot Table
40 - Show Text Fields for a Pareto Chart
Part VII: Tips
41 - Base your pivot table on a Table When New Data Might Be Added
42 - Show Yes/No As the Values in a Pivot Table
43 - Create Perfectly Formatted Pivot Tables Using GETPIVOTDATA
44 - Create a Worksheet for Every Customer Using Show Report Filter Pages
45 - Controlling Multiple Pivot Tables with One Set of Slicers
46 - Reduce Pivot Table Workbook Size by 50% Before Sending
47 - Create a Pivot Table from Access Data
48 - Create a chart from a pivot table with Pivot Charts
Part VIII: Troubleshooting
49 - Compatibility between versions
50 - Force Missing Months to Show in a Pivot Table
51 - Whatever Happened to Multiple Consolidation Ranges in Pivot Tables?
52 - Cleaning up bad data before creating a pivot table
53 - Pivot Data Where the Source Data Has Dates Stretching Across the Columns
Part IX: PowerPivot
54 - Using the Data Model in Excel 2013 to Join Two Tables
55 - Distinct Count in Excel 2013
56 - True Top Five in Excel 2013
57 - Using Named Sets for Asymmetric Reports
58 - Getting PowerPivot
59 - Load Data into PowerPivot
60 - Define Relationships in the PowerPivot Window or Diagram View
61 - Creating the Pivot Table - Compare Choices
62 - Changing the Calculation from Sum & Other Differences
For the complete TOC visit:
http://www.quepublishing.co...
Show less
