Download My Excel Practice Files
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
- 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
- Group Data in Pivot Table for Summary by Quarter