Back

Questions
About MrExcel
Consulting Services
Learn Excel Resources
Challenge of the Month
MrExcel Seminars

Message Board

MrExcel Store
Podcast
Search
Media
Contact
Home

 

BBBOnLine Reliability Seal

Member of the National Speakers Association



 

LiveLessons Power Excel 2007 DVD-ROM with Bill Jelen from QUE


Click here to order the DVD!

Do you wish you could attend Bill Jelenís Power Excel Seminar but you canít find your city on the list of upcoming seminars?

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

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

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

If so, this AMAZING DVD-ROM from QUE is for you. The LiveLessons Power Excel 2007 DVD-ROM contains nearly 8 hours of tips and tricks from Billís Power Excel seminar. The seminar is broken up into 95 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 2007.

The package contains a DVD-ROM with 8 hours of video content. It contains a 120 page booklet with notes from each lesson. There is a completely searchable index on the DVD. Pop this in your computer and you will be understanding pivot tables in just a few minutes.

Click here to order the DVD!

Table of Contents:

Part 1: Excel 2007 Interface

  • Lesson 1: Introducing the Ribbon
  • Lesson 2: Quick Access Toolbar
  • Lesson 3: Finding Icons
  • Lesson 4: Keyboard Shortcuts
  • Lesson 5: Mini Toolbar and Live Preview
  • Lesson 6: Zoom Slider and Page Layout
  • Lesson 7: Recent Documents
  • Lesson 8: Save as PDF
  • Lesson 9: Excel Options
  • Lesson 10: Opening Templates, Closing Excel
Part 2: Excel 2007 New Features
  • Lesson 11: Unlocking the Big Grid
  • Lesson 12: Cell Styles and Document Themes
  • Lesson 13: Data Visualizations
  • Lesson 14: Tables and Table Formulas
  • Lesson 15: Sort and Filter by Color
  • Lesson 16: Duplicates
  • Lesson 17: Picture Tools and WordArt
  • Lesson 18: Other New Features
Part 3: Text
  • Lesson 19: Drag the Fill Handle to Extend a Series
  • Lesson 20: Create Your Own Series
  • Lesson 21: Joining Text
  • Lesson 22: Rapid Formula Copy
  • Lesson 23: Convert to Proper Case
  • Lesson 24: Joining Dates
  • Lesson 25: Converting Formulas to Values
  • Lesson 26: Breaking Apart Text
  • Lesson 27: Parsing Fixed Width
Part 4: Excel Customizations
  • Lesson 28: Data Entry Tricks
  • Lesson 29: Customize All Future Workbooks
  • Lesson 30: Copy Worksheets
  • Lesson 31: Change All Worksheets
  • Lesson 32: Arranging Windows
Part 5: Sorting & Subtotals
  • Lesson 33: Data Preparation
  • Lesson 34: Sorting Basics
  • Lesson 35: Random Sort
  • Lesson 36: Sorting by Weekday
  • Lesson 37: Rearranging Columns
  • Lesson 38: Subtotals
  • Lesson 39: Collapsing Subtotals
  • Lesson 40: Copy Subtotals
  • Lesson 41: Formatting Subtotals
  • Lesson 42: Multiple Subtotals
  • Lesson 43: Filling in Data on Subtotal Rows
  • Lesson 44: Subtotal Tricks
Part 6: Pivot Tables
  • Lesson 45: Creating a Pivot Table
  • Lesson 46: Changing a Pivot Table
  • Lesson 47: Pivot Gotchas
  • Lesson 48: Pivot Sorting
  • Lesson 49: Drill Down
  • Lesson 50: Summarizing Dates
  • Lesson 51: Top 10 Report
  • Lesson 52: Pivot Calculations
  • Lesson 53: Pivot Formatting
  • Lesson 54: Unique List
  • Lesson 55: Ad-Hoc Queries
  • Lesson 56: New Filtering Options
  • Lesson 57: 50 Reports in 5 Seconds
  • Lesson 58: Pivot Compatibility with 2003
  • Lesson 59: Making Reports Pivotable
Part 7: Charting and SmartArt
  • Lesson 60: Creating and Formatting a Chart
  • Lesson 61: Adding or Removing Chart Data
  • Lesson 62: Interactive Chart
  • Lesson 63: Charting Differing Orders of Magnitude
  • Lesson 64: Pie Chart Tricks
  • Lesson 65: XY and Bubble Charts
  • Lesson 66: Saving Favorite Chart Settings
  • Lesson 67: Creating SmartArt
  • Lesson 68: Smart Art Formulas
Part 8: Formulas
  • Lesson 69: AutoSum Tricks
  • Lesson 70: Formula Auditing
  • Lesson 71: Three Ways of Entering Formulas
  • Lesson 72: Relative Versus Absolute Formulas
  • Lesson 73: Discovering Functions
  • Lesson 74: Goal Seek
  • Lesson 75: Unusual Functions
  • Lesson 76: IF Formulas
  • Lesson 77: VLOOKUP
  • Lesson 78: IFERROR
  • Lesson 79: SUMIFS
  • Lesson 80: Super Formulas
  • Lesson 81: Date and Time
Part 9: Macros
  • Lesson 82: Recording a Macro
  • Lesson 83: Recording Navigation
  • Lesson 84: How Many Rows
  • Lesson 85: Event Macros
Part: 10 Tips & Tricks
  • Lesson 86: Finding Records with Filter
  • Lesson 87: Web Queries
  • Lesson 88: Copying Column Widths
  • Lesson 89: Page Numbering
  • Lesson 90: Turn Data
  • Lesson 91: & in Header
  • Lesson 92: Choose from a List
  • Lesson 93: ToolTips for a Cell
  • Lesson 94: Word Processing in Excel
  • Lesson 95: Have a Talk with Excel
Afterword
Index to Lessons

Click here to order the DVD!

Product Details:
DVD-ROM: 8 Hours
Booklet: 120 pages
Publisher: QUE, April 14, 2008
ISBN 978-0-7897-3825-7
Price: $39.99

MrExcel.com Consulting can be hired to implement this concept, or many other cool applications, with your data.

MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

 

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

All contents Copyright 1998-2008 by MrExcel Consulting.