Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
Excel has a set of TEXT Functions that can do wonders. You can do all kinds of text slice and dice operations using these functions. One of the common tasks for people working with text data is to extract a substring in Excel (i.e., get psrt of the text from a cell). Unfortunately, there is …
We often create and work on multiple Excel worksheets. These could be separate sheets in the same workbook (for example different worksheets for different years, products, departments, etc.). Sometimes, you may need to send a part of the worksheet or a single excel worksheet from the workbook to your colleague or boss. While there can …
If you often need to print your Excel worksheets, it would be useful to know how to print comments in it. By default, this setting is disabled, which means that when you print a worksheet, the comments are not printed. While Excel provides a couple of options to print comments, it is not readily available in …
If you work with Excel worksheets that have a lot of cell comments in a worksheet, this tutorial could be useful. Sometimes you may insert cell comments to highlight or explain data, or your boss may insert comments in cells while reviewing your work. If you have a huge dataset and the comments are scattered …
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 …
©trumpexcel.com – Free Online Excel Training
