Calc Guide

Introduction
Many requests for software support are caused by complicated
formulas and solutions to simple day to day procedures. For more
efficient and effective solutions use the DataPilot, a tool for combining,
comparing, and analyzing large amounts of data easily. By using the
DataPilot, you can view different summaries of the source data, display
the details of areas of interest, and create reports, whether you are a
beginner or an intermediate or advanced user.
This chapter is divided into two sections:
• “Examples with step by step instructions” uses three typical cases
to demonstrate the advantages and applications of the DataPilot.
Follow the examples to learn how easy it is to use the DataPilot.
• “DataPilot functions in detail” starting on page 241 describes the
DataPilot in detail. You can use this part for looking up how a
function is used.
Examples with step by step instructions
This section demonstrates some of the possibilities of the DataPilot in
typical use cases. By following the step by step instructions, you can
recreate the examples and learn about the power of the DataPilot.
Example 1: Sales volume overview
A typical introductory example in courses and books for beginners with
spreadsheets is a simple sales volume overview.
Figure 149: Typical example for beginners
This example demonstrates the user interface and how to insert text
and numbers into cells. Useful aids like AutoFill and drag and drop
have been demonstrated in other chapters. The most important part is
Chapter 8 Using the DataPilot 219