LiveLessons: Power Excel 2007 with MrExcel
May 2008
LiveLessons Power Excel 2007 DVD-ROM with Bill Jelen from QUE
Buy Now »- 8 Hours
- Publisher: QUE Publishing
- ISBN: 978-0-7897-3825-7
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 on your computer and you will be understanding pivot tables in just a few minutes.
-
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
