Excel 2013 Tutorial#1 Conditional Formatting in Excel 2013

Excel Basic Concepts –

Filters in excel –
Short key – Alt D FF
You can also find the filter tab in data tab.

Freeze rows:
1. Select the row below the row(s) you want to freeze. In our example, we want to freeze header row which contains name and rank
2. Click the View tab.
3. Select the Freeze Panes command, then choose Freeze top row from the drop-down menu.
4. The rows will be frozen in place.
We can also freeze row / col in between by selecting row and selecting freeze panes instead of selecting freeze top row.

We can add multiple work sheets in same excel file. To rename the sheet, just right click on the sheet tab it will options select rename and rename it. Also to delete we need to right click and delete the sheet.
We can also group worksheets:
• Select the first worksheet you wish to include in the worksheet group. Selecting the first worksheet of the group.
• Press and hold the Ctrl key on your keyboard.
• Select the next worksheet you want in the group. ...
• Release the Ctrl key.