Excel -1- Get Started

Never used MS Excel before? Maybe once or twice, and most probably by mistake…?

Calm down and follow these simple steps.

Empty worksheet
When first starting MS Excel 2010, the program opens an empty workbook file named by default “Book1” (as indicated in the title bar on the top of the window). This workbook contains three empty worksheets (“Sheet1”, “Sheet2” and “Sheet3”) represented by the three tabs at the bottom of the window. […]

1. Starting up MS Excel 2010

Insert a new worksheet via contextual menu
Default workbooks always come with 3 empty worksheets. At any time, you may add a new worksheet to your workbook just by clicking on the icon next to the last sheet of your current workbook. The new sheet automatically appears to the right of the last one. Note that mousing […]

2. Opening a new worksheet

without parentheses
One of the first things that you may want to try when it comes to calculation is performing simple arithmetic operations “somewhere” in the worksheet. To do this, select any cell in the worksheet by clicking on it or by entering its address (for example E7) in the name box. […]

6. Simple arithmetic operations

Insert function
Many functions and arithmetic operations are pre-programmed in MS Excel. Providing that you know the name and role of a function, you may perform heavy calculations within a few clicks. At any time, click on the symbol fx next to the name box to open a dialog box which will […]

9. Using formulas and functions

Sorting data
You do not necessarily need to suffer from obsessive compulsive disorder (OCD) to organize and tidy a bit your data. It is actually a good practice to sort tables using parameters and variables. MS Excel has a useful tool that performs this type of tidying according to one or several variables of […]

11. Sorting your data

Save your work
When you are finally happy with the content of your worksheet and you consider that it would be a shame to see it disappear, simply use CTRL+S to save your work. If the workbook already has a name and location, then the data will be save automatically without any further request. Otherwise, […]

13. Saving your work