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.