
LiveLessons Power Excel 2007 DVDROM 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 DVDROM from QUE is for you. The LiveLessons Power Excel 2007 DVDROM 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 DVDROM 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: AdHoc 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:
DVDROM: 8 Hours
Booklet: 120 pages
Publisher: QUE, April 14, 2008
ISBN 9780789738257
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.
