Which features of Microsoft Excel do you use? Want to get up to speed quickly on the most useful ones? As you probably know, even at the most basic level Excel allows us to perform calculations (like a calculator) and manipulate text (like a word processor). Its power comes from being able to do multiple related calculations, based on its grid structure. So while with a calculator or on paper we can do simple sums, in Excel we can do the same sum many, many times.
Below are five features you should be using – if you aren't already. Learn everything about these tips: they will improve your spreadsheet skills and allow you to successfully organise your data to your satisfaction.
1) Pivot Tables
PivotTables summarise large amounts of Excel data from a database that is formatted where the first row contains headings and the other rows contain categories or values. The way the data is summarised is flexible but usually the Pivot Table will contain values summed over some or all of the categories.
If you’re new to creating PivotTables, Excel 2013 can analyze your data and recommend a PivotTable for you. Once you’re comfortable with PivotTables you can start from scratch and create your own.
To create a Pivot Table, make sure your data has column headings or table headers and that there are no blank rows. Click any cell in the range of cells or table.