Introduction
Part 1 Excel 2007 Interface
Lesson 1 Introducing the Ribbon
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 2 Quick Access Toolbar
What You Will Learn
More Details
Notes from the Lesson
Lesson 3 Finding Icons
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 4 Keyboard Shortcuts
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 5 Mini Toolbar and Live Preview
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 6 Zoom Slider and Page Layout
What You Will Learn
Notes from the Lesson
Lesson 7 Recent Documents
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 8 Save as PDF
What You Will Learn
Notes from the Lesson
Lesson 9 Excel Options
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 10 Opening Templates, Closing Excel
What You Will Learn
Related Lessons
Notes from the Lesson
Part 2 Excel 2007 New Features
Lesson 11 Unlocking the Big Grid, File Formats
What You Will Learn
Notes from the Lesson
Lesson 12 Cell Styles and Themes
What You Will Learn
Notes from the Lesson
Lesson 13 Data Visualizations
What You Will Learn
Notes from the Lesson
Lesson 14 Tables and Table Formulas
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 15 Sort and Filter by Color
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 16 Duplicates
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 17 Picture Tools and WordArt
What You Will Learn
Notes from the Lesson
Lesson 18 New Features
What You Will Learn
Related Lessons
Notes from the Lesson
Part 3 Text
Lesson 19 Drag the Fill Handle to Extend a Series
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 20 Create Your Own Series
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 21 Joining Text
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 22 Rapid Formula Copy
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 23 Convert to Proper Case
What You Will Learn
Notes from the Lesson
Lesson 24 Joining Dates
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 25 Converting Formulas to Values
What You Will Learn
Notes from the Lesson
Lesson 26 Breaking Apart Text
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 27 Parsing Fixed Width
What You Will Learn
Related Lessons
Notes from the Lesson
Part 4 Excel Customizations
Lesson 28 Data Entry Tricks
What You Will Learn
Notes from the Lesson
Lesson 29 Customize All Future Workbooks
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 30 Copy Worksheets
What You Will Learn
Notes from the Lesson
Lesson 31 Change All Worksheets
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 32 Arranging Windows
What You Will Learn
Notes from the Lesson
Part 5 Sorting and Subtotals
Lesson 33 Data Preparation
What You Will Learn
Notes from the Lesson
Lesson 34 Sorting Basics
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 35 Random Sort
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 36 Sorting by Weekday
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 37 Rearranging Columns
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 38 Subtotals
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 39 Collapsing Subtotals
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 40 Copy Subtotals
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 41 Formatting Subtotals
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 42 Multiple Subtotals
What You Will Learn
More Details
Notes from the Lesson
Lesson 43 Filling In Data on Subtotal Rows
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 44 Subtotal Tricks
What You Will Learn
Notes from the Lesson
Part 6 Pivot Tables
Lesson 45 Creating a Pivot Table
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 46 Changing a Pivot Table
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 47 Pivot Gotchas
What You Will Learn
Notes from the Lesson
Lesson 48 Pivot Sorting
What You Will Learn
Notes from the Lesson
Lesson 49 Drill Down
What You Will Learn
Notes from the Lesson
Lesson 50 Summarizing Dates
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 51 Top 10 Report
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 52 Pivot Calculations
What You Will Learn
Notes from the Lesson
Lesson 53 Pivot Formatting
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 54 Unique List
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 55 Ad-Hoc Queries
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 56 New Filtering Options
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 57 50 Reports in 5 Seconds
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 58 Pivot Compatibility
What You Will Learn
Notes from the Lesson
Lesson 59 Making Reports Pivotable
What You Will Learn
Notes from the Lesson
Part 7 Charting and SmartArt
Lesson 60 Creating and Formatting a Chart
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 61 Adding or Removing Chart Data
What You Will Learn
Notes from the Lesson
Lesson 62 Interactive Chart
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 63 Charting Differing Orders of Magnitude
What You Will Learn
Notes from the Lesson
Lesson 64 Pie Chart Tricks, Histograms
What You Will Learn
Notes from the Lesson
Lesson 65 XY and Bubble Charts
What You Will Learn
Notes from the Lesson
Lesson 66 Saving Favorite Chart Settings
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 67 Creating Smart Art
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 68 Formulas in Smart Art
What You Will Learn
Related Lessons
Notes from the Lesson
Part 8 Formulas
Lesson 69 AutoSum Tricks
What You Will Learn
Notes from the Lesson
Lesson 70 Formula Auditing
What You Will Learn
Notes from the Lesson
Lesson 71 Three Ways of Entering Formulas
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 72 Relative Versus Absolute Formulas
What You Will Learn
Notes from the Lesson
Lesson 73 Discovering Functions
What You Will Learn
Notes from the Lesson
Lesson 74 Goal Seek
What You Will Learn
Notes from the Lesson
Lesson 75 Unusual Functions
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 76 IF Formulas
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 77 VLOOKUP
What You Will Learn
Notes from the Lesson
Lesson 78 IFERROR
What You Will Learn
Notes from the Lesson
Lesson 79 SUMIFS
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 80 Super Formulas
What You Will Learn
Notes from the Lesson
Lesson 81 Date and Time
What You Will Learn
Notes from the Lesson
Part 9 Macros
Lesson 82 Recording a Macro
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 83 Recording Navigation
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 84 How Many Rows?
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 85 Event Macros
What You Will Learn
Related Lessons
Notes from the Lesson
Part 10 Tips and Tricks
Lesson 86 Finding Records
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 87 Web Queries
What You Will Learn
Notes from the Lesson
Lesson 88 Copying Column Widths
What You Will Learn
Notes from the Lesson
Lesson 89 Page Numbering
What You Will Learn
Related Lessons
Notes from the Lesson
Lesson 90 Turn Data
What You Will Learn
Notes from the Lesson
Lesson 91 & in Header
What You Will Learn
Notes from the Lesson
Lesson 92 Choose from a List
What You Will Learn
Notes from the Lesson
Lesson 93 Tool Tips for a Cell
What You Will Learn
Notes from the Lesson
Lesson 94 Word Processing in Excel
What You Will Learn
Notes from the Lesson
Lesson 95 Have a Talk with Excel
What You Will Learn
Notes from the Lesson
Afterword
0789738252 TOC 3/21/2008
Bill Jelen is the host of MrExcel.com and the author of 20 books on Microsoft Excel, including Special Edition Using Excel 2007, Pivot Table Data Crunching, and VBA & Macros for Microsoft Excel. He has made more than 75 guest appearances on TechTV with Leo Laporte and was voted guest of the year on the Computer America radio show. He has produced more than 600 episodes of his daily video Learn Excel podcast. Bill will entertain you while showing you the powerful tricks in Excel. Before founding MrExcel.com in 1998, Jelen spent 12 years “in the trenches” as a financial analyst for the accounting, finance, marketing, and operations departments of a publicly held company. Since then, his company has automated Excel reports for hundreds of clients around the world. The website answers more than 30,000 questions a year—for free—for readers all over the world.
Your Basket