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.
A propos de l’auteur
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.
Plus d’ebooks du même auteur(s) / Éditeur
11 889 Ebooks dans cette catégorie
