Special Techniques in Excel

About the Book

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.

About the Author

David Fong has more than twenty years of experience working with Excel spreadsheets, and he has helped companies use them to analyze data and complete routine tasks. He has developed query techniques and dynamic formatting that bolster the power of automated data solutions.