Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
*This is a guest post by Puneet Gogia, a fellow Excel blogger from India.* Excel has a Quick Access Toolbar that gives you instant access to your favorite/important options. However, not many people use the QAT efficiently. Last month I have asked 15 excel users about it, and only 7 were using it on frequent …
Often, once you create a Pivot table, there is a need you to expand your analysis and include more data/calculations as a part of it. If you need a new data point that can be obtained by using existing data points in the Pivot Table, you don’t need to go back and add it in …
When you work with Excel charts, it rarely happens that you use the same default chart that Excel creates for you. In most of the cases, you have to change its formatting based on your brand, project, or audience. Now, if there is a fixed format that you have to use for many charts, it …
Text to Columns is an amazing feature in Excel that deserves a lot more credit than it usually gets. As it’s name suggests, it is used to split the text into multiple columns. For example, if you have a first name and last name in the same cell, you can use this to quickly split these into two …
If you’re into and financial planning or analysis, you must have heard about the Compound Annual Growth Rate (or CAGR). In this tutorial, you’ll learn different ways to calculate the CAGR in Excel: But before we dive into how to calculate CAGR in Excel, let’s first understand what it means (feel free to skip this …
When working with large datasets full of formulas in Excel, it becomes difficult to keep a track of important cells and formula results. You may have a data set that spans across hundreds or even thousands of records, and going back and forth to know the result of important formulas could be a big waste …
*This is a guest post by Ryan Wells, a fellow blogger, and a brilliant VBA developer.* If you work with Excel, you undoubtedly have been asked to create summaries of your work. Sales reports, invoices, forecasts, schedules, you name it. You know what all these documents have in common? They look great in PDF form. …
There are situations when you need to add leading zeroes to a dataset in Excel. This could be the case if you maintain records in Excel, such as Employee Ids or Transaction Ids. For example, you may want to get a consistent look in your data set as shown below: In this tutorial, you’ll learn …
If you work with a lot of numbers in Excel, it’s a good practice to highlight negative numbers in red. This makes it easier to read the data. There are various techniques you can use to highlight negative numbers in red in Excel: Let’s explore each of these techniques in detail. Highlight Negative Numbers in …
©trumpexcel.com – Free Online Excel Training
