Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
When working with dates, sometimes you may need to know the total number of days in a given month. This could be useful when working on project scheduling or payroll calculation, or even travel planning. While you can easily figure out the total days in a given month, when doing it for a larger dataset, …
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 …
Excel is a great tool when it comes to data manipulation. There are many functionalities and functions in Excel that allow you to modify your data to get the desired result quickly. One common scenario is when you get your data with dashes/hyphens, and you want to remove them. For example, below, I have the …
While working with large datasets in Excel, you may need to clean the data to use it further. One common data cleaning step is to delete blank rows from your data in Excel. In this tutorial, I will show you how to remove blank rows in Excel using different methods. While there is no in-built feature …
Excel has so many unique features that sometimes, some of the features don’t get the credit they deserve. One such tool is the Status Bar in Excel. The Status Bar, as the name suggests, allows us to check the status of a few things (such as the cell mode or the macro recording status, or …
©trumpexcel.com – Free Online Excel Training
