Category: Tips

Formatting in cells of Excel – 3 of 8

I have given you two lists of very useful shortcut keys General and Navigational keys to use in Excel. Here is the third of the series of 8 using Formatting. Shortcut keys are a quicker way of executing certain commands. They also save your fingers from repetitive strain syndrome from using the mouse. As I…

Tips – Using Shortcut keys in Excel – General shortcuts

When windows and GUI was in its infancy my students were really against learning any key strokes to perform any function in any application. Today, some 20 years on, my students especially the younger ones rebel when I introduce them to keystrokes for executing something. This is a big mistake in my view. Shortcut keys…

Tips – How to create a Data table in Excel for a loan

I see loads of adverts for all sorts of loans that look so inviting. But wouldn’t you like to see what will be the amount you have to pay back if the rate of interest changes. One such way is to create a Data table in Excel. Using the PMT function to do the calculations.…