Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
Most of my time working in Excel is spent cleaning data that I get from different sources. One common task that I have to do quite often is to remove parentheses (or brackets) from the cells in a dataset. As with almost everything else in Excel, there are multiple ways you can remove the parenthesis …
I’m a huge fan of using shortcuts in Excel to speed up my work While there are many shortcuts that I use on a daily basis, one that I find particularly useful is the ability to repeat the last performed action in Excel. This is useful when you have to do the same thing repeatedly …
In many situations, you may want to quickly highlight all the cells with formulas in Excel. When I was working as a financial analyst a few years ago, this is something I used to do often to mark the cells that contain formulas. Another situation where this may be useful is when you want to …
If you want to know how many days a month has, you can easily figure it out for one date. But doing it by hand for a whole column of dates gets slow. February makes it trickier, since it has 29 days in a leap year. But nothing to worry about, as a simple formula …
If you work with date values in Excel, it would be useful to know the different formatting options you can use with dates. Any date or time value in Excel would be a number in the back end that would represent that date or time. for example, 1 represents 1 Jan 1900, 2 represents 2 …
Page orientation can be important when planning to print your work in Excel. While the default page orientation in Excel is the Portrait mode (where the length of the page is more than the width), if you have a data set where there are more columns than rows, you may want to change the orientation …
Excel charts can be confusing for people, and it’s always a good idea to mark everything clearly in the chart. One chart element that is often missing in charts (which should ideally always be added) is the Axis Title. Most commonly used Excel charts have two axes (horizontal and vertical), and adding an axis title …
Filtering your data is a common task for many Excel users as a part of their daily work. Excel already has a well-developed filter functionality that allows you to filter based on many criteria, such as text or number, or dates. Not many people know that Excel also has an inbuilt filter by color functionality, …
Many times, I have a need to select every other row in Excel so that I can highlight or delete them. This is commonly the case when I download my data from databases or the web, and it adds an extra row after every useful row that I need to remove. Another useful situation can …
©trumpexcel.com – Free Online Excel Training
