List of “The 50 Best Tips for Excel 2007″
I invite you to watch a short video tour of my DVD – “The 50 Best Tips for Excel 2007″
Here is the Main Menu for my DVD, “The 50 Best Tips for Excel 2007.” I have divided the tips into Beginning Level (16 Tips), Intermediate Level (23 Tips) and Advanced Level (11 Tips). As a bonus, I have also included all of the Excel Workbooks that I use on the DVD. This enables you to practice the tips as you view each lesson!

Beginning Level:
(Follow this link to go to my online store)
- Customizing AutoFill Options
- Customizing the QAT
- Entering Formulas & Functions
- Entering Data Efficiently
- Exploring Excel Options
- Exploring Status Bar Tools
- Formatting & Aligning Cells
- Formatting with Cell Styles
- Getting Started in Excel 2007
- Grouping Worksheets
- Naming Cells and Ranges
- Pasting Your Data
- Printing Your Worksheet
- Sorting Your Data
- Using Paste Special
- Working with Templates
Intermediate Level:
(Follow this link to go to my online store)
- Annotating Your Workbook
- Applying Themes
- Bringing Charts to Life
- Calculating Time
- Charting Data
- Conditional Formatting
- Consolidating Data
- Counting Functions
- Creating Subtotals
- Decision-making Formulas
- Defining Named Constants
- Editing Charts
- Extracting Text Strings
- Filtering Your Data
- Introducing Excel Tables
- Joining Text Strings
- Pasting Links Between Workbooks
- Preventing Formula Errors
- Protecting Your Workbook
- Removing Duplicate Records
- Saving Time with Shortcuts
- Summing Functions
- Validating Your Data
Advanced Level:
(Follow this link to my online store)
- Auditing Formulas
- Grouping & Charting in Pivot Tables
- Importing External Data
- Introducing Pivot Tables
- Looking Up Information
- Performing “What-if” Analysis
- Producing Financial Reports
- Solving Problems With Goal Seek
- Using Conditional Sum Wizard
- Using Lookup Wizard
- Using New Pivot Table Features