Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
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 …
A lot of people use dates in Excel for planning and keeping track of tasks and activities. For example, below I have a data set where I have the tasks in column A and their due dates in column B. It would be useful if there was a way to automatically highlight dates before today, …
If you want to convert seconds values to minutes in Excel, it is not as straightforward as dividing it by 60. This is because Excel has a specific way of storing date and time values in Excel. While a full day is stored as a whole number in Excel, time values are stored as fractions/decimals. …
Excel has 450+ functions that can do a range of awesome things. If you’ve used Excel even for a few days, I am sure you have heard of functions like VLOOKUP, SUMIF, COUNTIF, and so on. And what is more awesome is that one Excel function – a formula that consists of two, three, or …
©trumpexcel.com – Free Online Excel Training
