Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
When you copy a cell or range of cells in Excel and paste it somewhere else, it pastes the entire content of the cells, including the formatting. But do you know that you can also copy the column width? Excel allows you to copy cells and paste selectively (such as only pasting the values or …
Pivot tables are used by hundreds of thousands of people every day to analyze and summarize large amounts of data. Pivot Tables are fairly easy to use, and most Excel users get the hang of it after using it a couple of times. So if you’re a fan of Pivot Tables and use them quite …
Many Excel users use the terms ‘Formula’ and ‘Function’ interchangeably. While this does no harm in most cases, it’s good to have a proper understanding of what a formula is and what a function is in Excel. And, of course, it is going to give you a lot of opportunities to correct others and brag …
While this may be a basic question for many Excel users, I have been asked multiple times about the difference between rows and columns in Excel. While one obvious difference is the placement of the row versus column in Excel, there is more to it. In this article, I will cover the differences between rows …
It’s a common requirement to calculate the date after a specific number of weeks from the current date or any other given date. This is especially helpful while planning a project where you have a tentative idea of how much time a task would take and want to know when it will be completed (by …
Excel users often need to compare cells or columns to check if the same text is available in the cells/columns or not. A very common example of this is when you have names in two columns and you want to check if the names are exactly the same or what names are missing in one …
When I was working as a data analyst years ago, part of my job was to download data from financial databases and then clean this data. And one of the things I had to do while cleaning the data was to delete any blank columns in the data set. While you can always manually select …
Excel allows you to sort your data set based on numeric values, text values, dates, as well as colors in the cell. However, there is no inbuilt functionality in Excel to sort the cells based on the length of the text in the cells. In one of my Excel training sessions, I was asked whether …
Working with dates is a common task for many Excel users. And sometimes, you can come across dates that are formatted as text (or look like dates but are not in the acceptable date formats, so Excel treat them as text strings). Since dates are stored as numbers in the backend in Excel, it allows …
©trumpexcel.com – Free Online Excel Training
