Microsoft Excel

 

Microsoft Excel allows you to store, manipulate and analyze data in organized workbooks for home and business tasks.

The Cell :

Each rectangle in a worksheet is called a cell. A cell is the intersection of a row and a column. Each cell has a name, or a cell address based on which column and row it intersects. The cell address of a selected cell appears in the Name box.

 

To Cut And Paste Cell Content :

1. Select the cells you wish to copy.
2. Click the copy command. The border of the selected cell will change appearance.
3. Select the cell or cells where you want to paste the content.
4. Click the Paste command. The copied content will be entered into the highlighted cells.

To Access Formatting Commands By Right – Clicking :

1. Select the cells you want to format.
2. Right-click on the selected cells. A dialog box will appear where you can easily access many commands that are on the ribbon.

To Drag And Drop Cells :

1. Select the cells that you wish to move.
2. Position your mouse on one of the outside edges of the selected cells. The mouse changes from a white cross to a black cross with 4 arrows.
3. Click and drag the cells to the new location.
4. Release your mouse and the cells will be dropped there.

To Modify Column Width :

1. Position your mouse over the column line in the column heading so that the white cross becomes a double arrow .
2. Click and drag the column to the right to increase the column width or to the left to decrease the column width.
3. Release the mouse. The column width will be changed in your spreadsheet.

Formatting Text :

Many of the commands you will use to format text can be found in the Font, Alignment, and Number groups on the ribbon. Font commands let you change the style, size, and color of text. You can also use them to add borders and fill colors to cells. Alignment commands let you format how text is displayed across cells both horizontally and vertically. Number commands let you change how selected cells display numbers and dates.

Sparklines :

Sparklines are miniature charts that fit into a single cell. Since they're so compact, you can place a large number of them in your worksheets. For example, you could place one sparkline on each row to show trends within that row.

Types of sparklines :

There are three different types of sparklines: Line, Column, and Win/Loss. Line and Column work the same as line and column charts. Win/Loss is similar to Column, except it only shows whether each value is positive or negative, instead of how high or low the values are. All three types can display markers at important points, such as the highest and lowest points, to make them easier to read.

Line	Column	Win / Loss

Why Use Sparklines ?

Sparklines are basically charts, so why would you want to use sparklines instead of charts? Sparklines have certain advantages that make them more convenient in many cases. Imagine you have 1000 rows of data. If you place a sparkline on each row, it will be right next to its source data, making it easy to see the relationships between the numbers and the sparkline. If you used a traditional chart, it would need to have 1000 data series in order to represent all of the rows, and you would probably need to do a lot of scrolling to find the relevant data in the worksheet.

Sparklines are ideal for situations where you just want to make the data clearer and more eye-catching, and where you don't need all of the features of a full chart. On the other hand, charts are ideal for situations where you want to represent the data in greater detail, and they are often better for comparing different data series.

Pivot Tables :

PivotTable reports (or, simply PivotTables) make the data in your worksheets much more manageable by summarizing the data and allowing you to manipulate it in different ways. PivotTables can be an indispensable tool when used with large, complex spreadsheets, but they can be used with smaller spreadsheets as well.