Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
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 …
With VBA in Excel, you can easily open one or more Excel files by specifying their location. This is made possible by the Workbooks.Open method, which takes the file location as the argument and opens that Excel file. You can do a lot more with the Workbooks.Open method, such as opening all the files in …
We all know how important it is to be able to see the data in our spreadsheets clearly. I find the functionality to zoom in on a specific section of the data set in Excel quite useful when I used to present my work in calls and meetings. Once you know how to zoom in …
Most of us work with tabular data in Excel where the data is arranged in columns. And one of the common tasks most Excel users have to do is to go to the end of the data in the column (i.e., the last filled cell). While you can quickly go to the end of the …
Working with Excel often involves rearranging the data in the worksheets. And one common task many Excel users have to do is to cut the cell values from one cell and paste it to some other cell in the same worksheet or in another worksheet/workbook. While this is a basic operation that most Excel users …
One of the worst things that can happen to you when using an Excel file is to lose your work. This is why almost all Excel experts recommend saving your work frequently (now Excel even has an autosave feature where it saves files automatically). While this is good practice, I recommend going even further and …
I’ve been a big fan of Excel drop-down lists since I learned about them. It makes data entry fast It also allows me to create dashboards and reports that are interactive (where a user can choose an option from the drop-down in the entire dashboard updates). It’s also a useful tool when I’m sharing my …
©trumpexcel.com – Free Online Excel Training
