MS Excel is the commonly used spreadsheet tool in the world today.
Here, I list 3 common MS Excel features that you can use and help you be more efficient in your daily tasks:
Master this feature and you can easily handle your MS Excel. How to?
|Number||In this tab, we can apply different number formats without changing the number itself. A number format does not affect the actual value that Excel uses for calculations. The actual value is still displayed in the Formula Bar|
|Alignment||In this tab, we can set how the cells will be aligned vertically, horizontally or even diagonally. We can also set the indentation within cells and also to merge or wrap text within cells|
|Font||In this tab, we can choose what font to use, the font size, the font style, the font colour or some additional text effects like strikethrough|
|Border||In this tab, we can set the border formatting options for a single cell or multiple cells or table|
|Fill||In this tab, we can set the background colour for a single cell or multiple cells or table|
|Protection||In this tab, we can set the option to protect the cells or hide the formula used in the cells we selected. Please take note, that any options that we choose in this tab will not function until we protect the worksheet (Review Tab, Changes Group, Protect Sheet button)|
For more in-depth about Format Cells, please click here to register your interest to attend my class.
Do this exercise:
* The above exercise is an excerpt from what I share in my class. Do the above and you will understand the very basic function of MS Excel.
Every month I do conduct training sessions on various training topics including MS Excel. These sessions are limited to 10 pax per topic. Please click here to register your interest.
Table A – Famous Places visited by My Friends