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″
Shop for My DVDs at the Online Store for The Company Rocks
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
