Special Techniques in Excel

by David Fong

Overview

Excel can be used for only so muchor 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, youll 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 youre just learning Excel or are an experienced user, you can move beyond using it as a simple computational tool with Special Techniques in Excel.

Product Details

ISBN-13:	9781482881837
Publisher:	Partridge Publishing Singapore
Publication date:	12/09/2016
Sold by:	Barnes & Noble
Format:	eBook
Pages:	156
File size:	9 MB

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.