Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
When working with Excel spreadsheets, most people are either short on time or have a deadline to meet. And it could be a nightmare if, at that point in time, Microsoft Excel decides not to open (arghhhhh!). Unfortunately, this unexpected behavior is quite common where Excel refuses to open one of your important Excel files, …
When working with data in Excel, you’ll often have the issues of handling outliers in your data set. Having outliers is quite common in all kinds of data, and it’s important to identify and treat these outliers to make sure that your analysis is correct and more meaningful. In this tutorial, I’ll show you how …
Since dates and times are stored as numbers in the back end in Excel, you can easily use simple arithmetic operations and formulas on the date and time values. For example, you can add two different time values or date values or you can calculate the time difference between two given dates/times. In this tutorial, …
Excel is an amazingly well-developed spreadsheet tool that has been designed to maximize the efficiency of its users. While it works as expected in most of the cases, in some cases, it can be a little counterproductive. One such area is when Excel decides to round-off numbers (arghhh). In this tutorial, I will show you …
When you’re working with data in Excel, most of the time you’ll have to deal with decimals (especially if you’re working with currency data or accounting numbers). In an attempt to make Excel a smart and more user-friendly tool, there are some in-built features that end up being a little bit of an irritation. Working …
I was recently working on a project where I had dates in Excel and I had to find out what quarter of the year it was based on the date. For the purpose of this tutorial, let’s consider the following: In case you’re working with financial data where the quarter starts from April, then you …
When working with VBA coding in Excel, you can easily add comments while writing the code. Comments in VBA could be really useful for beginners, where you can add a comment to a line of code (or a block of code) that explains what it does. So, the next time you come back to the …
Formulas are the life and blood of Excel spreadsheets. And in most cases, you don’t need the formula in just one cell or a couple of cells. In most cases, you would need to apply the formula to an entire column (or a large range of cells in a column). For example, if you have …
When working with Excel, you spend most of your time on the worksheet (which is the area that has all the cells and everything that happens there). Working efficiently with Excel also means that you have to work with multiple worksheets within the same workbook. Excel allows you easily add multiple worksheets in the workbook, …
©trumpexcel.com – Free Online Excel Training
