Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
If you work with currency/sales data, it comes in handy to know how to insert dollar and cent symbols with the numerical/sales values in Excel. While the dollar sign is right there on the keyboard, cent symbol is a little more difficult to find and insert. How to Insert a Cent Symbol in Excel In this …
Using a combination of Excel functions and the date of birth, you can easily calculate age in Excel. You can either calculate the age till the current date or between the specified period of time. The technique shown here can also be used in other situations such as calculating the duration of a project or the tenure …
When we calculate a simple average of a given set of values, the assumption is that all the values carry an equal weight or importance. For example, if you appear for exams and all the exams carry a similar weight, then the average of your total marks would also be the weighted average of your …
A lot of times, we need to work with text data in Excel. It could be Names, Address, Email ids, or other kinds of text strings. Often, there is a need to combine cells in Excel that contain the text data. Your data could be in adjacent cells (rows/columns), or it could be far off …
In Excel, you can create a macro by recording it or by writing code in the VB editor. Once created, you need to run the macro. In this tutorial, I’ll show you different ways to run a macro in Excel. If you’re interested in learning VBA the easy way, check out my Free Excel VBA …
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 …
©trumpexcel.com – Free Online Excel Training
