Power Excel Lessons
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
