Introduction

In requests for office software support there are regularly questions caused by some awkward solution strategies for day to day exercises in a spreadsheet. By not knowing simple but powerful concepts, users create very complicated formulas. A much more solid, simple, and flexible solution is based on using the DataPilot.

The DataPilot is not just a tool for advanced users. If beginners would know about this tool, it would save them many hours of work.

This chapter is divided into two sections:

• Examples with step by step descriptions uses three typical cases to demonstrate the advantages and applications of the DataPilot. You can follow these examples and learn by doing how easy it is to use the DataPilot.
• DataPilot functions in detail describes the DataPilot in detail. You can use this part for looking up how a function is used.