HAPPY BOOKSGIVING
Use code BOOKSGIVING during checkout to save 40%-55% on books and eBooks. Shop now.
Accessible from your Account page after purchase. Requires the free QuickTime Player software.
Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec.
Register your product to gain access to bonus material or receive a coupon.
Actual product comes full screen and in high resolution.
Actual product comes full screen and in high resolution.
Actual product comes full screen and in high resolution.
Actual product comes full screen and in high resolution.
Actual product comes full screen and in high resolution.
Actual product comes full screen and in high resolution.
Actual product comes full screen and in high resolution.
Actual product comes full screen and in high resolution.
Excel PivotTables, PowerPivot, Power View, and GeoFlow 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
Part X: DAX Calculated Fields
63 - DAX Measures
64 - Use DAX Measures to Calculate a Range
65 - Use DAX Measures to un-apply a Filter
66 - Using a Calendar Table for Time Intelligence
67 - Time Intelligence Functions
68 - Disconnected Parameter Tables with FILTER()
69 - Actuals vs Budget
70 - Using IF(VALUES in a Measure
71 - Build Slicers on Lookup Tables
72 - First Initial Slicer (and turning off cross-slicer filtering)
73 - Convert the Pivot Table to Cube Formulas
Part XI: Power View
74 - Preparing your data for PowerView
75 - Adding a Power View Worksheet
76 - Adding a Dashboard Element as a Table
77 - Converting Table to a Chart
78 - Explicit and Implicit Slicers
79 - Understanding the Filter Pane
80 - Using Tile Boxes
81 - Replicating Charts Using Multiples
82 - Showing Data on a Map
83 - Showing Images in Table or Card View
84 - Formatting Power View
85 - Animating a Scatter Chart over Time
Part XII: GeoFlow
86 - Adding data to GeoFlow
87 - Flying through the map
88 - Animating GeoFlow
89 - Building a tour in GeoFlow
LiveLessons Video Training series publishes hundreds of hands-on, expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. This professional and personal technology video series features world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, IBM Press, Pearson IT Certification, Prentice Hall, Sams, and Que. Topics include: IT Certification, Programming, Web Development, Mobile Development, Home and Office Technologies, Business and Management, and more. View all LiveLessons on InformIT at http://www.informit.com/imprint/series_detail.aspx?ser=2185116
Que:
http://www.quepublishing.com/imprint/series_detail.aspx?st=87397
Bill Jelen, Excel MVP and the host of MrExcel.com, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. Bill was a regular guest on "Call for Help with Leo Laporte" and has produced more than 1,200 episodes of his daily video podcast, "Learn Excel from MrExcel." He is the author of 30 books about Microsoft Excel and writes the monthly Excel column for Strategic Finance magazine. You will most frequently find Bill taking his show on the road, doing half-day Power Excel seminars wherever he can find a room full of accountants or Excellers. Before founding MrExcel.com, Jelen spent 12 years in the trenches working as a financial analyst for finance, marketing, accounting, and operations departments of a $500 million public company.
Download ExcelFiles_Part_1.zip
Download ExcelFiles_Part_2.zip
Download ExcelFiles_Part_3.zip