Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
While working at IBM, I was a part of a ToastMasters International club. It’s a place where you can improve your communication and leadership skills. An interesting section in the weekly meetings was impromptu speaking. In this part of the meeting, a person was given a topic and he/she had to speak on it for 2 minutes. There …
Watch Video – Creating a Step Chart in Excel A step chart can be useful when you want to show the changes that occur at irregular intervals. For example, the price rise in milk products, petrol, tax rate, interest rates, etc. Let’s take the example of a Petrol hike in India. It can happen any …
‘A’ as in Alpha, ‘B’ as in Bravo, ‘C’ as in Charlie. Heard these phrases before? These are called the Military Alphabet Code (also known as NATO alphabet code). It is often used by people (especially the call center guys) to communicate the name, email address or the home/office address. Generate Military Alphabet Code in Excel In …
A Radio Button in Excel (also called the Option Button) can be used to select one of the many choices/options. You must have seen it on hundreds of web pages where you are asked to select an option by clicking on a small round shape next to the text. As soon as you select it, …
Gridlines in Excel are those faint gray lines that you see around the cells in the worksheet. These gridlines make it easier to differentiate between the cells and read the data. Now don’t confuse gridlines with borders. Gridlines are visible on the entire worksheet while borders can be applied to the entire worksheet or to a …
What do you do when you have to enter a sequence of serial numbers in a column in Excel? For example, entering numbers 1 to 1000 in cell A1:A1000. The regular way of doing this is: Sometimes it may get a bit irritating to drag the fill handle to the last cell which can be …
Excel Pivot Table is a great tool. It only takes a few clicks to create a Pivot table and you can easily analyze huge datasets without worrying about human errors. One of the default settings in Pivot Tables is to show a blank cell when there is no data for the given row/column label. In …
If you need to print your work in Excel, this tip would save you some papers. Using this, you can set the print area in Excel worksheets, so that only that part of the worksheet is printed. This technique could be useful if you want to print only a part of a report or there is …
If your work involves printing your excel worksheets, it’s a good idea to insert page numbers in it. Inserting page numbers in Excel takes a little more work as compared with other Microsoft applications such as Word or PowerPoint. Watch Video – How to Insert Page Numbers in Excel How to Insert Page Numbers in …
©trumpexcel.com – Free Online Excel Training
