In Excel there are tables and PivotTables. You may wonder why you'd need to create a table when the whole worksheet already looks like one. And you've heard about PivotTables and how complex they are. To be able to use either effectively, it helps to know what each of them does, and when to use...
Okay, you’ve got data arranged in spreadsheet rows and columns, with column headers. So why try tables? Well, tables make it easy to format data, sort, filter, add totals, and use formulas. With tables, you don’t need to fuss to get formatting just right. Excel automatically adds formatting...