Special Techniques in Excel

<p>Excel can be used for only so much—or can it?</p><p>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.<br />By following the techniques in the guide you’ll be able to:<br />automate data analysis from the time you key in data to the time you generate a report with a single condition or multiple conditions;<br />save computer memory by automating data and storing it properly;<br />create daily weekly monthly and yearly reports on one sheet that changes when new data are entered; and<br />save time and money in preparing complex reports.</p><p>Once you set up the report technique you can use it anytime to generate daily weekly monthly or yearly reports.</p><p>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.</p>