For the last installment of 2011 Fast Tips, we’ve brought back a long time favorite feature! Exporting data to Microsoft Excel is a fast and easy way to share your Contacts, Activities or analyze Opportunities. This tip will show you how to export the exact data you would like to review, print or analyze in Microsoft Excel!
Exporting List Data to Excel
1. Before you export data, set up your data list with the appropriate columns by selecting the Options button, and then clicking Customize Columns.
2. Add/remove columns to the list view. This is important because only data displayed will be exported.
3. After your list is set, click the Export Current List to Excel button, or alternatively, click Tools > Export to Excel…
4. Data will be exported to Excel. Now it's ready for you to share, print, or analyze!
Next week, we'll start looking into new features of Sage ACT! 2012 that will increase your productivity, and make it easier to keep all the details of your personal and business life at your fingertips!