Looking for some awesome Excel tips and tutorials? You’re at the right place.
Here you’ll find a collection of amazing excel tips that will make you an Excel Ninja and save a lot of time.
All the Excel tips are covered in detail with supporting images and a video (in most of the cases).
If you’re a beginner in Excel, you can start from out Learn Excel section.
You also find tips and tutorials on various Excel topics such as charting, dashboards, and VBA. In addition to the tutorials, you will also find some useful Excel templates that you can download for free.
You will also find Excel formula tips to get common tasks done using the formulas. You can also visit the Excel Functions section to learn about most commonly used Excel functions such as VLOOKUP, INDEX, OFFSET, COUNTIF, IFÂ and so on..
Also check out our Online Excel Training courses on Excel (Basic to Advanced), Dashboard, and VBA.
Excel is not only a wonderful tool for data entry and data analysis, but also great at making charts, flow charts, simple diagrams, etc. It’s quite simple in Excel to insert a line and then customize and position it. In fact, you’ll be surprised how many options you get when you need to draw a …
Copying and Pasting a cell or a range of cells is one of the most common tasks users do in Excel. A proper understanding of how to copy-paste multiple cells (that are adjacent or non-adjacent) would really help you be a lot more efficient while working with Microsoft Excel. In this tutorial, I will show …
Although Excel is a powerful data analysis tool, many users use it for basic arithmetic operations. One common requirement is to multiply an entire column by a number (a constant value). In this tutorial, I will show you two easy ways to multiple an entire column with a given number. So let’s get to it! …
When you’re working formulas in Excel, many times you will encounter the #VALUE error. While the error is quite generic and doesn’t tell you what the problem is, in most cases, this happens when you give a formula a data type that is not expected (explained with examples below). For example, if you have a …
If you have been working with formulas in Excel, I am sure you have encountered the #DIV/0! error (the Division error). In this short tutorial, I will show you how to quickly remove the division error in Excel (using some easy formulas). I will also show you how you can find all the cells in …
If you like to plan ahead and make a weekly or monthly schedule, having a calendar in Excel could be quite useful. In this tutorial, I’m going to show you how to create a calendar in Excel that automatically updates when you change the month or the year value. I will show you the exact …
When working with the names dataset in Excel, often there is a need to slice and dice the dataset and extract a part of it. One common task many Excel users have to do is to extract the last name from the full name. While it may seem like an easy task, it can get …
Excel can be quite useful when you’re working dates. It has some powerful built-in formulas that allow you to do calculations based on dates. One common scenario where you have to perform calculations with dates would be to find out how many years or months or dates have elapsed between two given dates. This could …
Excel has some really amazing functions, but it doesn’t have a function that can sum cell values based on the cell color. For example, I have the dataset as shown below, and I want to get the sum of all orange and yellow color cells. Unfortunately, there is no in-built function to do this. But …
©trumpexcel.com – Free Online Excel Training
