- Series
- Que
- Author
- Bill Jelen
- Publisher
- QUE Publishing
- Cover
- Softcover
- Edition
- 1
- Language
- English
- Total pages
- 128
- Pub.-date
- May 2008
- ISBN13
- 9780789738257
- ISBN
- 0789738252

Title no longer available

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.