Working faster in MS Excel – 4 easy tips

1.  Using CTRL 1 to format cells in MS Excel: To open the format cell dialog box in MS Excel – use CTRL + 1 – this option makes my life easier when I’m working with Excel – As soon as I select the area to be formatted with the mouse using my right hand, I press CTRL 1 on the keyboard with the left (this is easy because the two buttons (CTRL and 1) are on the left side of the keyboard).

2.  Organize your MS Excel Workbook – I like to name my worksheets, especially when working with big projects. To change the default sheet name, double click on the name (i.e. Sheet1), when it’s selected, type the new name.

3.  Using names rather than default cell positions (i.e. Revenue instead of D20) when working with complex tables. This is useful when you are dealing with a large audience because your names tell your viewers the purpose of your formula or a particular cell.

To name a cell, select the cell or range of cell > click on Insert menu > click on Name > click on Define to add a name.

Please note that defined names can be used on any worksheet.

4.  Creating a quick chart in Excel – To create a chart quickly in Excel using default settings, select your data range > then press F11.