Copy of Advanced Spreadsheet Skills

3. How to filter unique items from a list

3.1 First you go on the option Data where you choose from the Main Menu:

3.2 Then in that field, you have the Filter tool and you select it:

3.3 Right click on the tool Filter, you have the option Advanced. Choose it and you check the Unique records only option and click OK.

*The Auto Sum feature provides a quick way to add up columns or rows of figures in a spreadsheet. This function makes it easy to sum all columns, rows and individual cells in one click.

2.2 Then you continue with the tab Home – Editing, where you can edit everything that you want to change in your Excel document:

2.3 In that option you have more functions. From all these functions you will choose Clear All so you can delete all cells that you’ve selected before:

A Brief History of Excel

Some Facts About Excel

Microsoft Excel (AKA Microsoft Office Excel) is a spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables and, except for some Mac editions, a macro programming language called VBA (Visual Basic for Applications).

1. Changing the colour of the sheet name tabs

Right click on the sheet and select the option “Tab color” and then you can choose which colour you like. It looks very fun and interesting for show. It is so easy to do this, see how it looks like:

A Brief History of Spreadsheets

2. Delete all formatting with one click

2.1 First you select all cells/ranges so you can give a command which cells/ranges will be removed and deleted. Press CTRL+A to select all the cells:

A spreadsheet is a computer application that superseded paper worksheets. It displays multiple cells that together make up a grid consisting of rows and columns, each cell containing either alphanumeric text or numeric values. A spreadsheet cell may alternatively contain a formula that defines how the contents of that cell is to be calculated from the contents of any other cell (or combination of cells) each time any cell is updated. Spreadsheets are frequently used for financial information because of their ability to re-calculate the entire sheet automatically after a change to a single cell.

How To: Excel Formulas

4. Auto sum cells with one click

Select a bunch of cells and click on the Sigma symbol “∑” what you can find in the tab Home from the Main Menu. After that, you press Enter and you get the final sum.

These are the most interesting and useful facts about Excel, so, now you have more experience with all these activities and you can create an Excel document with these very easy steps.

Our References:

http://www.software-matters.co.uk/spreadsheets.html

http://www.softwareask.com/some-interesting-facts-about-microsoft-excel/

https://www.gcflearnfree.org/excelformulas/

Advanced Spreadsheet Skills