1. In Excel Ribbon click on the Page Layout tab.
2. In the Sheet Options group click Sheet Right-to-Left. The sheet direction will be changed. Column A will now be to the far right. Columns B, C, D.. etc. will follow to the left.

A. The quick (shortcut) way:

• Press the control key and the ~ key at the same time (CTRL ~) to show formulas in the cells.
• Press the same keys again to hide formulas in the cells.

B. Using Excel Options:

1. Click File.
2. Click Options. Excel Options window will open.
3. Click on the Advanced tab.
4. Go to the section titled “Display options for this worksheet”.
5. Select the check box that says “Show formulas in cells instead of their calculated results”.

3.Click on the Popular tab in Excel 2007 or General tab in Excel 2010.
4. On the line that says Use this font, select the font you want from the drop down box.
5. Click OK.

1. Select the first worksheet.

2. In the View tab, Window group click New Window.

3. Select the second worksheet. Now you have two windows, one on display and the other one in the background.

4. In the View tab, Window group click Arrange All. The Arrange Windows window will open.

5. Select one of the options then click OK. The Tiled option, for example, will show the sheets next to each other, one on the left and the other on the right. The Horizontal option will show them one under the other.

Syntax:

CONCATENATE(text1, text2, text3 ……)

You can concatenate up to 255 items into one text string.

Example:

Cell A1 = “MBA”

Cell B1 = “Master of Business Administration”

Cell C1 contains the formula: CONCATENATE(A1; B1)

The value of C1 will be “MBAMaster of Business Administration”

You can also use literals (fixed text) in the CONCATENATE function. E.g. if C1 has the formula:

CONCATENATE(A1; “ – “; B1

Then the value of C1 will be “MBA – Master of Business Administration”

You can also use the ampersand (&) calculation operator to achieve the same result as the CONCATENATE function. The last example will look like this:

=A1 & ” – ” & B1

1. In the Home tab, Styles group click Conditional formatting.
2. Point to Top/Bottom Rules and click Top 10 Items.



3. The Top 10 Items window will open.



4. Specify the number of items to format (left) and the formatting options from the drop-down list on the right. If you are not satisfied with what is on the list, you can click Custom Format at the bottom and then set up your own.
5. Your data will look like this.

We can do this in Excel as follows:

Column A:  Date entry.

Column B: Sales entry.

Column C: A formula to calculate the running total

1. In C2 enter the same value as B2. This is the first row of sales.
2. In C3 enter the formula : =C2+B3.
3. Select cell C3 and drag the fill handle down until the end of your data.
4. Now C4 will have the formula C3+B4, C5 will be C4+B5 and so on. The running total will be updated automatically.

To handle cell protection differently then you have to change the default settings for the required cells.

Here is how to protect formula cells but allow access to data cells:

1. Select all cells in the worksheet by clicking on the top left corner of the sheet.
2. On the Home tab, Cells group, click Format.
3. Under Protection click Format cells. The Format Cells window will be shown.
4. Click on the Protection tab.
5. Uncheck the Locked and Hidden check boxes, then click OK.

These five steps will make all cells in the worksheet unprotected and can therefor be modified. Next step is to protect the formula cells, and here is how we do it:

1. Select all cells that have formulas.
2. On the Home tab, Cells group, click Format.
3. Under Protection click Format cells. The Format Cells window will be shown.
4. Click on the Protection tab.
5. Check the Locked and Hidden check boxes, then click OK.
6. On the Home tab, Cells group, click Format.
7. Under Protection click Protect sheet.

Applies to: Excel 2007 , Excel 2010

1.      Click on Excel Developer tab. If you can’t see the developer click Here.

2. On the Code group click Visual Basic.

3. You will be switched to Visual Basic Editor Menu.

4. On the Insert menu (Visual Basic Editor) select Module.

5. This will open the code window.

6. Type the Visual Basic code for your function.

7. On the File menu click Close and return to Microsoft Excel.

8. Your new function should now be ready for use like any other Excel function.

1. Click the  Microsoft Office Button (File tab in case of Excel 2010).
2. Click Excel Options (at the bottom right of the menu).



3. Excel Options window will open.



4. In Excel Options window (left side) click Advanced.
5. On the right side  check the box labeled: Automatically insert a decimal point , then specify the number of decimal points you want in the combo box labeled: Places (next line).
6. Click OK.

1. Click the  Microsoft Office Button.
2. Click Excel Options (at the bottom right of the menu).



3. Excel Options window will open.



4. In Excel Options window (left side) click Popular.
5. On the right side, next to Color scheme click the arrow of the drop down list and select the required scheme.
6. Click OK.

1.       Select the cell, range of cells within the same column or the entire column that you want to distribute its data.

2.       On the Data tab, Data Tools group, click Text to Columns. This will start the Convert Text to Columns Wizard .

3.       In the first step of the wizard specify your data type then click Next :

a.       “Delimited” means data fields are separated by special characters like commas. E.g ” Shakespeare,William “.

b.      “Fixed” means fields are aligned in equal size columns separated by spaces. E.g ” Shakespeare William “.

4.       In the second step of the wizard you specify the field delimiters, if you choose “Delimited” in the previous step, or specify the field widths, if you choose “Fixed” in the previous step. Click Next when you are done.

5.       The last step lets you specify the data format of each column, if it is different from the default set by Excel. Click Finish when you are done.

6.       The data will be distributed into a number of columns depending on the number of separators or spaces in the original column.

=A1+A4+A6+A7+A8

This is OK for a few cells but for large range, it is better to write the formula as follows:

=SUM(A1,A4,A6:A8)

Which means some A1, A4 and the range A6 to A8.

1. Select your data range.
2. In the Home tab, Styles group click Conditional formatting.
3. Point to Highlight Cells Rules.
4. In the sub-menu to the right click Duplicate Values.



5. The Duplicate Values window will open. Click OK.
6. Any duplicate values in the range will be highlighted with the default color. You can change the color before clicking OK.

Applies to: Excel 2007, Excel 2010

To save the worksheet as a comma delimited file:

1.       In Excel menu click File.

2.       Click Save As. The Save As window will open.

3.       In the Save as type drop down, select CSV (Comma delimited).

4.       Any row in the worksheet will be transformed like this:

“ABC;7268;87368;XYZ;373″

The delimiter is either a “,” or “;” depending on your installation of Excel.

Applies to: Excel 2007, Excel 2010

1. Select the sparkline or the group of sparklines that you want to delete.
2. On the Sparkline Tools, click the Design tab.



3. On the Design tab, in the Group group, click Clear.

1. Select the worksheet(s) you want to hide.
2. In the Home tab, Cells group click Format.
3. Under Visibility, point to Hide & Unhide and then click Hide Sheet.

To display or unhide a worksheet:

1. In the Home tab, Cells group click Format.
2. Under Visibility, point to Hide & Unhide and then click Unhide Sheet.
3. In the Unhide sheet box, double-click the name of the hidden sheet that you want to display.

Applies to: Excel 2007, Excel 2010

1. Select a sparkline or a group of sparklines.
2. On the Sparkline Tools, click the Design tab.
3. On the Design tab, in the Show group, select the check boxes for the individual markers you want to show e.g. High Point, Low Point or Negative Points.
4. To show all markers, select the check box labeled Markers.
5. To hide a specific marker or markers uncheck the relevant check box(s).

The example below shows a Sparkline for the data in row 2.

To insert a Sparkline follow these steps:

1. Enter your data in the worksheet.
2. Select the cell where you want to insert the Sparkline.
3. Click on the Insert tab.
4. In the Sparklines group   select one of the three options:
   1. Line: to plot your chart as a trendline.
   2. Column: to plot your chart as a series of columns.
   3. Win/Loss:  good if you have negative numbers.
5. The Create Sparklines window will open.
6. In the Data Range text box enter your data range (in the form B2:G2).
7. Your Sparkline will be inserted in the specified cell.

Tip.

If you right-click on the Sparkline you will see Sparkline options. e.g. you can change the data range or the Sparkline location.