Your One Stop for Excel Tips & Solutions

  MrExcel - Photos of MrExcel
Questions
About MrExcel
Consulting Services
Learn Excel Resources
Excel - Visual Learning
Challenge of the Month
MrExcel Seminars
Message Board
MrExcel Store
Podcast
Search
Media
Contact
Home
Having an Excel Emergency?
 
 


Click Add as Fan in top right
of our Facebook page

 
 

 
 
MrExcel Library - Charts And Graphs: Microsoft Excel 2010

DVD: 8+ Hours (Searchable Format)

Product Details:
DVD-ROM: 8+ Hours
Publisher: QUE, October 2013

Price: $49.99
Available Now!

Back

Live Lessons: Power Excel 2013 with MrExcel

Click here to order the DVD!

Did you wish you could have attended Bill Jelen’s Power Excel Seminar but you couldn't find your city on the list of seminars?

Did you attend the Power Excel seminar and wish you could replay that tip on copying subtotals again?

Have you upgraded to Excel 2013 and are frustrated that Bill still covers Excel 2007or 2010 in most of his seminars?

Can you not make it away from the office for four hours of training?

From Bill "MrExcel" Jelen himself:

Screenshot from "Live Lessons: Power Excel 2013 with MrExcel"

"Attending one of my live Power Excel seminars is like drinking from a fire hose. There is no way you can absorb 100 new tricks in 8 hours. With the LiveLessons DVD, you can watch one trick a day, usually in 5 minutes or less. If you need a refresher on how to do something later, jump directly back to that trick and have your answer in a few minutes."

This AMAZING DVD-ROM from QUE is for you. The LiveLessons Power Excel 2013 DVD-ROM contains nearly 8+ hours of tips and tricks from Bill’s Power Excel 2013 Seminar. The seminar is broken up into 97 lessons, so you can jump right to a lesson and watch it. In most cases, you will learn the technique and be back to work in less than five minutes. This version of the DVD is performed entirely in Excel 2013.

The package contains a DVD-ROM with 8+ hours of video content. There is a completely searchable index on the DVD. Pop this into your computer and you will be understanding Pivot Tables in just a few minutes.

"Live Lessons: Power Excel 2013 with MrExcel"

Click here to order the DVD!

Table of Contents:

Part 1: Excel 2013 Interface

  • Part 1-Interface: Lesson #1 Sign-in to Office: The Account Page, Saving to the Cloud (4:18)
  • Part 1-Interface: Lesson #2 Start Screen, Open Screen, Recent Documents (3:24)
  • Part 1-Interface: Lesson #3 Excel on Two Screens, Window Arrange (5:07)
  • Part 1-Interface: Lesson #4 Flash Fill (6:13)
  • Part 1-Interface: Lesson #5 Quick Analysis (4:09)
  • Part 1-Interface: Lesson #6 Apps for Office (4:54)
  • Part 1-Interface: Lesson #7 Customizing Ribbon and QAT (8:27)
  • Part 1-Interface: Lesson #8 Keyboard Shortcuts (10:57)
  • Part 1-Interface: Lesson #9 Page Layout View (6:13)
  • Part 1-Interface: Lesson #10 Customize All Future Workbooks (7:05)
  • Part 1-Interface: Lesson #11 Copy Worksheets (3:58)
  • Part 1-Interface: Lesson #12 Change All Worksheets (3:47)
  • Part 1-Interface: Lesson #13 Saving Workbook to PDF (3:57)
  • Part 1-Interface: Lesson #14 Finding Icons (4:08)
  • Part 1-Interface: Lesson #15 Snow Blindness (6:18)

Part 2: Text Formulas

  • Part 2-Text: Lesson #16 Drag the Fill Handle to Extend a Series (1Q 2011 (9:10)
  • Part 2-Text: Lesson #17 Create Your Own Series (including ABC (3:35)
  • Part 2-Text: Lesson #18 Joining Text (2:14)
  • Part 2-Text: Lesson #19 Rapid Formula Copy (note fill handle change) (2:59)
  • Part 2-Text: Lesson #20 Convert to Proper Case (2:11)
  • Part 2-Text: Lesson #21 Joining Dates (5:21)
  • Part 2-Text: Lesson #22 Converting Formulas to Values (including Paste Special) (4:03)
  • Part 2-Text: Lesson #23 Breaking Apart Text (5:09)

Part 3: Formulas

  • Part 3-Formulas: Lesson #24 AutoSum Tricks (3:54)
  • Part 3-Formulas: Lesson #25 Formula Auditing (7:10)
  • Part 3-Formulas: Lesson #26 Three Ways of Entering Formulas (4:11)
  • Part 3-Formulas: Lesson #27 Relative Versus Absolute Formulas (replace absolute by naming range) (4:43)
  • Part 3-Formulas: Lesson #28 Tables and Table Formulas (4:39)
  • Part 3-Formulas: Lesson #29 Discovering Functions such as PMT (6:46)
  • Part 3-Formulas: Lesson #30 Goal Seek (2:41)
  • Part 3-Formulas: Lesson #31 What-If with Data Table (6:46)
  • Part 3-Formulas: Lesson #32 IF Formulas, including IFERROR & SUMIFS (10:09)
  • Part 3-Formulas: Lesson #33 VLOOKUP (Basic, Trim, Many, Horizontal, Two-way, Range, Array) (10:47)
  • Part 3-Formulas: Lesson #34 Date and Time, including time in excess of 24 hours, format as Qtr,
  • NETWORKDAYS (11:28)
  • Part 3-Formulas: Lesson #35 Implicit Intersection (3:25)
  • Part 3-Formulas: Lesson #36 Array formula for date range (6:27)

Part 4 Sorting & Filtering

  • Part 4-SortFilter: Lesson #37 Data Preparation (3:35)
  • Part 4-SortFilter: Lesson #38 One-Click Sorting (3:10)
  • Part 4-SortFilter: Lesson #39 Sorting by Color (2:49)
  • Part 4-SortFilter: Lesson #40 Sorting by Weekday (3:03)
  • Part 4-SortFilter: Lesson #41 Rearranging Columns (2:39)
  • Part 4-SortFilter: Lesson #42 Sort with a Formula (5:25)
  • Part 4-SortFilter: Lesson #43 Filter by Selection, plus ad-hoc totals (4:09)
  • Part 4-SortFilter: Lesson #44 Other ways to Filter (Search, Icon, Top 10) (3:55)
  • Part 4-SortFilter: Lesson #45 Remove Duplicates (5:12)

Part 5 Subtotals

  • Part 5-Subtotal: Lesson #46 Subtotals (3:13)
  • Part 5-Subtotal: Lesson #47 Collapsing Subtotals (1:25)
  • Part 5-Subtotal: Lesson #48 Copy Subtotals (3:42)
  • Part 5-Subtotal: Lesson #49 Formatting Subtotals (2:15)
  • Part 5-Subtotal: Lesson #50 Sorting Subtotals (2:29)
  • Part 5-Subtotal: Lesson #51 Changing Sum to Count in 1 column (7:11)
  • Part 5-Subtotal: Lesson #52 Manual Grouping (2:02)
  • Part 5-Subtotal: Lesson #53 Data Consolidate (3:50)

Part 6 Pivot Tables

  • Part 6-Pivot: Lesson #54 Creating a Pivot Table (including Recommended Pivot Tables) (5:12)
  • Part 6-Pivot: Lesson #55 Changing a Pivot Table (3:40)
  • Part 6-Pivot: Lesson #56 Pivot Gotchas (7:46)
  • Part 6-Pivot: Lesson #57 Pivot Formatting, including Tabular & Repeat Item Labels (6:12)
  • Part 6-Pivot: Lesson #58 Drill Down (4:05)
  • Part 6-Pivot: Lesson #59 Pivot Calculations, Including % of Parent Row (11:01)
  • Part 6-Pivot: Lesson #60 Summarizing Dates, add Year-over-Year (5:16)
  • Part 6-Pivot: Lesson #61 Pivot Sorting (3:41)
  • Part 6-Pivot: Lesson #62 Filtering Row Fields (including Search) (2:06)
  • Part 6-Pivot: Lesson #63 Top 10 Report, 4 Ways, including AutoFilter and Data Model (5:21)
  • Part 6-Pivot: Lesson #64 Filtering a Pivot Table with Slicers and Timelines (7:40)
  • Part 6-Pivot: Lesson #65 Pivot Tables - Slicers on Two Pivot Tables (5:48)
  • Part 6-Pivot: Lesson #66 50 Reports in 5 Seconds (3:00)
  • Part 6-Pivot: Lesson #67 Base on a table, force a new cache (2:45)
  • Part 6-Pivot: Lesson #68 Frequency Chart (2:45)
  • Part 6-Pivot: Lesson #69 Matching Two Lists (3:41)
  • Part 6-Pivot: Lesson #70 Using GetPivot Data (6:14)

Part 7 PowerPivot

  • Part 7-PowerPivot: Lesson #71 Join two tables in the data model (4:51)
  • Part 7-PowerPivot: Lesson #72 Join two tables in PowerPivot (6:32)
  • Part 7-PowerPivot: Lesson #73 Calculations in the Grid (5:42)
  • Part 7-PowerPivot: Lesson #74 Date Table in PowerPivot (5:02)
  • Part 7-PowerPivot: Lesson #75 Calculated Fields (8:14)
  • Part 7-PowerPivot: Lesson #76 Power View (9:52)

Part 8 Charting

  • Part 8-Charting: Lesson #77 Creating a Recommended Chart (5:55)
  • Part 8-Charting: Lesson #78 Tools for Formatting a Chart (8:18)
  • Part 8-Charting: Lesson #79 Chart Data Labels (5:31)
  • Part 8-Charting: Lesson #80 New Combo Chart to Chart Different Orders of Magnitude (2:15)
  • Part 8-Charting: Lesson #81 Scatter Charts and Paste Special (4:06)
  • Part 8-Charting: Lesson #82 Saving Favorite Chart Settings (2:25)
  • Part 8-Charting: Lesson #83 Add : Sparklines 1 (4:15)
  • Part 8-Charting: Lesson #84 Add: Labeling Sparklines (5:44)
  • Part 8-Charting: Lesson #85 Color Scales, Icon Sets, Data Bars (6:55)
  • Part 8-Charting: Lesson #86 Creating SmartArt (4:14)
  • Part 8-Charting: Lesson #87 Smart Art Formulas (4:09)

Part 9 Tips and Tricks

  • Part 9-Tips: Lesson #88 Turn Data (add Formula) (3:08)
  • Part 9-Tips: Lesson #89 Choose from a List (2:21)
  • Part 9-Tips: Lesson #90 ToolTips for a Cell (2:59)
  • Part 9-Tips: Lesson #91 Mail Merge (2:10)
  • Part 9-Tips: Lesson #92 Have a Talk with Excel (3:09)

Part 10 Excel Web App

  • Part 10-Web: Lesson #93 Web Data Functions (EncodeURL, Webservice, FilterXML) (4:31)
  • Part 10-Web: Lesson #94 Saving Workbook to Excel Web App, Share Via Twitter (5:12)
  • Part 10-Web: Lesson #95 Embedding in a web page or blog (2:46)
  • Part 10-Web: Lesson #96 Excel Button (2:10)
  • Part 10-Web: Lesson #97 Surveys (4:20)

Afterword

Click here to order the DVD!

Product Details:
DVD-ROM: 8+ Hours
Publisher: QUE, October 2013

Price: $49.99

MrExcel Library - Charts And Graphs: Microsoft Excel 2010

 


 


There are over 150,000 pages at MrExcel.com
Use Google
to search our site:

 


The MrExcel Library

     
 

Excel is a registered trademark of the Microsoft® Corporation.
MrExcel
TM is a registered trademark of Tickling Keys, Inc.

All contents Copyright 1998-2014 by MrExcel Consulting | Domestic and International Copyright Applies | All Rights Reserved