Special Techniques in Excel

This title is printed to order. This book may have been self-published. If so, we cannot guarantee the quality of the content. In the main most books will have gone through the editing process however some may not. We therefore suggest that you be aware of this before ordering this book. If in doubt check either the author or publisher’s details as we are unable to accept any returns unless they are faulty. Please contact us if you have any questions.

Excel can be used for only so much–or can it?

This guide shows you how to do just about anything using the popular program. It presents ideas on query techniques to automate business tasks whether you are using Excel as a database, to compare related data, or to gain insights about data.
By following the techniques in the guide, you’ll be able to:

automate data analysis from the time you key in data to the time you generate a report with a single condition or multiple conditions;
save computer memory by automating data and storing it properly;
create daily, weekly, monthly, and yearly reports on one sheet that changes when new data are entered; and
save time and money in preparing complex reports.

Once you set up the report technique, you can use it anytime to generate daily, weekly, monthly or yearly reports.

Whether you’re just learning Excel or are an experienced user, you can move beyond using it as a simple computational tool with Special Techniques in Excel.