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

Follow this link to go to my online store.