Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
If you press the down arrow key in Excel and the cursor stays put, or the whole sheet scrolls instead, it can feel like the keyboard has stopped working. In most cases, the keyboard is fine. Excel has a few modes and settings that take over the arrow keys, and each one shows a clue …
Sometimes, when working with dates, you may want to know the date after a specific number of months. For example, you may want to know the date three months after a specific date. Thankfully, Excel has an in-built function (EDATE) that does exactly this. In this tutorial, I will show you how to use a …
Sometimes you may have dates in one column and time values in another column and you want to combine these to get one single date and time value in a cell. And if you’re thinking that you can do that by easily combining the two cells by using the concatenate formula or the & sign, …
When you printing your work in Excel, it would help if there is a system to decide how much content goes on one page and what’s then printed on the next page, and so on. By default, Excel does this by inserting page breaks at regular intervals in the worksheet while printing. This is done …
Excel is a powerful tool that has some amazing functions and functionalities when working with statistics. Finding a correlation between two data series is one of the most common statistical calculation when working with large datasets, I was working as a financial analyst a few years ago, and although we were not heavily involved in …
Running total (also called cumulative sum) is quite commonly used in many situations. It’s a metric that tells you what’s the sum of the values so far. For example, if you have the monthly sales data, then a running total would tell you how much sales have been done till a specific day from the …
The XML file format is quite commonly used on the web, and there is a possibility that sometimes you may have to work with the data in the XML file. Now you can’t use the XML file directly, as it’s not meant to be read by humans (but machines). In such a case, it would …
Excel allows you to format dates in many different ways. You can choose to show the date in a short date format or in a long date format. You can also only show the day number, the month name, or the year from a given date. In this short Excel tutorial, I will show you …
If you want to flip data in Excel, there are a few ways to do it. By that I mean reversing the order of the data upside down in a vertical dataset or left to right in a horizontal dataset. Now, if you’re thinking that there must be an inbuilt feature to do this in …
©trumpexcel.com – Free Online Excel Training
