“The Excel Experience”
Downloadable Learning Experiences
Baarns Publishing developed a series of On-Line Experiences detailing the benefits and outlining the steps of many Excel features. These are worth the download. They are a great resource for learning advanced features, training, and tips on a great consistent presentation that you can use to format your workbooks.
These Experiences were developed for Microsoft Corporation by Baarns Publishing.
Information provided in these document is provided "as is" without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The user assumes the entire risk as to the accuracy and the use of this information.
Subtotals Experience
Group and Outline Experience
Range Name Experience
Functions Experience
PivotTable Experience
Auto Filter Experience
Auto Format Experience
Power Chart Experience
Scenario Experience
Solver Experience
Download Excel Subtotals
Experience Now
(142K exe file - decompresses to an xls workbook.)
This workbook features "Subtotals..." an advanced feature of Microsoft Excel versions 5.0 and 7.0.
Subtotals provides an easy way to summarize your lists of data. You can display all levels of detail, or just those you want by expanding or collapsing the subtotals.
Download Group and Outline
Experience Now
(146K exe file - decompresses to an xls workbook.)
This workbook features "Group and Outline" an advanced feature of Microsoft Excel versions 5.0 and 7.0.
In a prior OnLine Experience you may have learned how to use subtotals to summarize data. In this experience you learn how to use the Outline feature to summarize data both vertically and horizontally.
In this demonstration, you'll see how an owner of a small coffee shop, such as Volcano Coffee Company, takes advantage of Group and Outline to analyze performance by beverage category and total revenue by category.
Download Excel Range Names Experience Now
(139K exe file - decompresses to an xls workbook.)
This workbook explains how to use the Range Name feature of Microsoft Excel versions 5.0 and 7.0, to analyze your data.
Names provide an easy way for you to refer to groups of cells in your workbooks. For example, Gross Revenue may be located on Sheet1 in cells E3 to E37. Rather than having to remember the cell reference, Microsoft Excel allows you to name cells and then use the range name in formulas. This makes possible formulas like, Gross-CostOfGoods, TotalSale*Tax, and so forth. Range names can be available to all sheets in a book, or a single sheet, and may also be used to navigate from range to range in a large worksheet.
Download Excel Functions
Experience Now
(171K exe file - decompresses to an xls workbook.)
This workbook explains how to use the Functions feature of Microsoft Excel versions 5.0 and 7.0, to analyze your data.
Functions provide easy methods for you to analyze data using built-in formulas. For example, you can calculate the Future Value of an investment just by knowing the interest rate, the number of payments, and the term of the investment. In this OnLine Experience you'll see how the owner of a small business called, Volcano Coffee Company, uses functions to analyze business performance and project the amount required to purchase new equipment.
Download PivotTable Experience
Now
(159K exe file - decompresses to an xls workbook.)
This workbook explains how to use the PivotTable feature of Microsoft Excel versions 5.0 and 7.0, to analyze your data.
Pivot tables form one of the most powerful tools available in Microsoft Excel. A pivot table automatically summarizes large amounts of data, and lets you analyze it by creating various views of the results.
In this demonstration, you'll learn how to create pivot tables, and how to use them to view a summary of your data in different ways. You will see the power and ease of pivot tables in action, by reading and following the detailed instructions in front of you.
Download Auto Filter Experience
Now
(175K exe file - decompresses to an xls workbook.)
This workbook features tips on how to use the Auto Filter feature of Microsoft Excel versions 5.0 and 7.0.
AutoFilter provides an easy way to manage your lists of data. With AutoFilter, you can display just the rows of information you want to see.
In this demonstration, you'll see how an owner of a small coffee shop, such as Volcano Coffee Company, takes advantage of AutoFilter to analyze yearly sales information. Using AutoFilter, you can analyze specific information to get the important facts out of the mountain of data accumulated over a years worth of sales.
Download Auto Format Experience
Now
(125K exe file - decompresses to an xls workbook.)
This workbook explains how to use the AutoFormat Chart feature of Microsoft Excel versions 5.0 and 7.0. With AutoFormat, you achieve higher productivity and consistency in presenting your graphs.
Excel's ChartWizard makes it easy to create and format many types of charts. The automatic formatting facility lets you tell Excel about your preferred formats among the many possible combinations. You can then apply this look to your other charts, in one simple step.
In this demonstration, you'll learn how to create AutoFormats, and how to use them to quickly format your charts. You will also be able to try out the steps while reading the detailed instructions in front of you.
Download Power Chart
Experience Now
(125K exe file - decompresses to an xls workbook.)
This workbook features advanced hints to add power to your charts in Microsoft Excel versions 5.0 and 7.0.
While Excel's ChartWizard makes it easy to create and format several types of charts, effective use of charts requires the application of some general principles.
In this demonstration, you'll learn some important guidelines to make your charts more informative and easy-to-read. You will see these guidelines in action through a side-by-side comparison of Before and After charts.
Download Scenario Experience
Now
(227K exe file - decompresses to an xls workbook.)
This workbook features Scenario Manager, an advanced feature of Microsoft Excel versions 5.0 and 7.0.
What-if analysis is the heart of many spreadsheet models. Scenario Manager allows you to consolidate multiple what-if models in one spreadsheet. Switch between the Scenarios to see the impact of various assumptions on your model.
In this demonstration, you'll see how an owner of a small coffee shop, such as Volcano Coffee Company, takes advantage of Scenario Manager to analyze various business scenarios involving average purchases and average costs.
Download Solver Experience Now
(227K exe file - decompresses to an xls workbook.)
This workbook features Solver, an advanced feature of Microsoft Excel versions 5.0 and 7.0.
What-if analysis is the heart of many spreadsheet models. For example, you can invest in a combination of 3 and 6 month CDs at varying interest rates. What's your best strategy? You have customers located in several geographic regions and four shippers that service those areas. What shippers should you use and for which customers? The Solver is a tool that looks at multiple variables and suggests an optimum solution.
In this demonstration, you'll see how an owner of a very successful chain of shops, Volcano Coffee Company, takes advantage of Solver to analyze various investments to assist in working capital management.
