Excel Practice Files to Download

Now On Sale! My DVD, “The 50 Best Tips for Excel 2007″

In response to several viewers, I have made these Excel Workbooks available for downloading as “Interactive Single Web Page Files.”  Simply click on the link below. Then, right-click on the Icon that appears to decide how and where to open the file.

Depending on your web- browser and your computer settings, you may have to install a “plug-in” or click to approve the download. You can “interact” with these files as you wish. If you have difficulty in accessing the files, send me an email message – danny@thecompanyrocks.com I will respond as soon as I can.

• Rearrange Your Columns in Excel – Sort left to Right
  • Practice file to download: rearrange-columns
  • View My Excel Training Video for Sorting by Columns
• Simplify Your Data Lookups
  • Practice file to download:  simplify-data-lookups
  • View My Excel Training Video for Simplifying Data Lookups
• Select Data Using Keyboard & Mouse Shortcuts
  • Practice file to download:  select-data-w-shortcuts
  • View My Excel Training Video for Selecting Data with Keyboard and Mouse Shortcuts
• Introduction to Pivot Tables in Excel 2003
  • Practice file to download: introduction-to-pivot-tables
  • View My Excel Training Video to Learn How to Create Pivot Tables
• Hide & Show Details in a Pivot Table
  • Practice file to download:  hide-show-details-in-pivot-table
  • View My Excel Training Video to Learn to Hide or Show Details in Pivot Tables
• Create Custom Lists for Data Entry & Sorting
  • Practice file to download: create-custom-lists
  • View My Excel Training Video to Learn to Create Custom Lists
  • View My Excel Training Video to Learn to Sort Data Using Custom Lists
• Excel’s “Go To Special” Tool
  • Practice file to download: go-to-special
  • View My Excel Training Video – Go To Cells with Formulas
• Produce Subtotals for your data
  • Practice file to download: create-subtotals
  • View My Excel Training Video for Produce Subtotals
• “What-If” Analysis Using a Two-Input Data Table
  • Practice file to download:  cr-tutorial-20b-2-input-table
  • View My Excel Training Video for Two-Input Data Tables
• Use the =SUMIF() Function to total only the cells in a range that match a condition
  • Practice file to download: sumif-function
  • View My Excel Training Video to Learn to Use the =SUMIF() Function
• Excel’s Future Value Function tells you what a regular series of investments will be worth
  • Practice file to download: future-values
  • View My Excel Training Video to Learn to Use the =FV() Function
• Name a Cell and Use it in Your Formulas
  • Practice file to download:  use-named-cells-in-formulas
  • View My Excel Training Video to Learn to Use Named Cells in Formulas
• How to Create Scenarios in Excel
  • Practice file to download: create-scenarios
  • View My Excel Training Video to Learn How to Create Scenarios
• Three Frustrations When Calculating Time in Excel
  • Practice file to download: 3-frustrations-with-time-calculations
  • View My Excel Training Video to Learn How to Solve Common Time Calculations in Excel
• Group Data in Pivot Table for Summary by Quarter
  • Practice file to download: grouping-by-quarters-in-pivot-tables
  • View My Excel Training Video to Learn How to Group Months into Quarters in a Pivot Table