The Essentials of Working with Tables in Excel 2010
Your Excel data is only useful if you can make sense of the numbers. If you know the essentials of creating and working with tables in Excel 2010, you can organize your data into easily read and understood tables. Use tables to help you manage your data.
Use the AutoFilter feature in Excel 2010 to hide everything in a table except the records you want to view. Filtering displays a subset of a table, providing you with an easy way to break down your data [more…]
In Excel 2010, you can use Web queries to import data directly from various Web pages that contain financial and other types of statistical data that you need to work with in a worksheet. [more…]
Excel 2010 can import data from an Access 2010 database table into a worksheet, a process known as making an external data query. After importing the data into Excel, you can then use the Filter buttons [more…]