List of The 50 Best Tips for Excel 2007

Do you want to learn Excel 2007 quickly? Do you want to learn how to create Pivot Tables to neatly summarize your Exce datal? Do you want to know how to find and to use the best Function or Formula to use?

Excel Tip List

Excel DVD Tips

Well, you have come to the right place, I created this DVD-ROM to show you how to get the most out of Excel – with 50 focused mini-lesson videos. You will learn the best tips for creating Pivot Tables, Charts, Data Visualizations, Financial Reports and more.

Here, on this page,  is a list of the 50 best tips for Excel 2007 along with the “run time for each lesson.

If you prefer, you can click here to download this list of The 50 Best Tips for Excel 2007.

 

 

NEW! Download a Free Copy of my new “Popular Keyboard Shortcuts for Excel” as a PDF – CR – Chart of Popular Excel Keyboard Shortcuts

I invite you to watch a short video tour of my DVD – “The 50 Best Tips for Excel 2007”

Skill Levels Covered on My “The 50 Best Tips for Excel 2007” DVD-ROM

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!
50 Best Tips for Excel 2007

50 Excel Tips

Beginning Level:

Add “The 50 Best Tips for Excel 2007” DVD to your secure shopping cart

  • Customizing AutoFill Options – Run time: 7:45
  • Customizing the Quick Access Toolbar – Run time: 5:30
  • Entering Formulas & Functions – Run time: 6:01
  • Entering Data Efficiently – Run time: 7:34
  • Exploring Excel Options – Run time: 7:49
  • Exploring Status Bar Tools – Run time: 4:42
  • Formatting & Aligning Cells – Run time: 6:24
  • Formatting with Cell Styles – Run time: 6:06
  • Getting Started in Excel 2007 – Run time: 5:49
  • Grouping Worksheets – Run time: 5:50
  • Naming Cells and Ranges – Run time: 6:33
  • Pasting Your Data – Run time: 5:27
  • Printing Your Worksheet – Run time: 6:16
  • Sorting Your Data – Run time: 7:25
  • Using Paste Special – Run time: 5:49
  • Working with Templates – Run time: 5:25

Intermediate Level:

Add “The 50 Best Tips for Excel 2007” DVD to your secure shopping cart

  • Annotating Your Workbook – Run time: 8:22
  • Applying Themes – Run time: 4:27
  • Bringing Charts to Life – Run time: 7:27
  • Calculating Time – Run time: 8:15
  • Charting Data – Run time: 7:23
  • Conditional Formatting – Run time: 8:43
  • Consolidating Data – Run time: 5:19
  • Counting Functions – Run time: 6:07
  • Creating Subtotals – Run time: 6:45
  • Decision-making Formulas – Run time: 5:04
  • Defining Named Constants – Run time: 6:47
  • Editing Charts – Run Time: 6:41
  • Extracting Text Strings – Run time: 6:44
  • Filtering Your Data – Run time: 6:32
  • Introducing Excel Tables – Run time: 6:50
  • Joining Text Strings – Run time: 6:18
  • Pasting Links Between Workbooks – Run time: 7:52
  • Preventing Formula Errors – Run time: 6:21
  • Protecting Your Workbook – Run time: 5:01
  • Removing Duplicate Records – Run time: 6:58
  • Saving Time with Shortcuts – Run time: 9:17
  • Summing Functions – Run time: 6:34
  • Validating Your Data – Run time: 7:26

Advanced Level:

Shop for “The 50 Best Tips for Excel 2007” DVD

  • Auditing Formulas – Run time: 6:43
  • Grouping & Charting in Pivot Tables – Run time: 5:50
  • Importing External Data – Run time: 7:31
  • Introducing Pivot Tables – Run time: 8:23
  • Looking Up Information – Run time: 6:39
  • Performing “What-if” Analysis – Run time: 5:29
  • Producing Financial Reports – Run time: 7:21
  • Solving Problems With Goal Seek – Run time: 5:57
  • Using Conditional Sum Wizard – Run time: 7:36
  • Using Lookup Wizard – Run time: 5:50
  • Using New Pivot Table Features – Run time: 7:46

Add “The 50 Best Tips for Excel 2007” DVD to your secure shopping cart

Related Videos:

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn