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 Table is an amazing feature that makes working with data a lot easier. And as more advanced tools such as Powe Query and Power Pivot now rely on Excel tables to be the data source, Excel tables are going to become even more important. But this tutorial is not about the awesomeness of Excel …
Comparing two Excel files (or comparing two sheets in the same file) can be tricky as an Excel workbook only shows one sheet at a time. This becomes more difficult and error-prone when you have a lot of data that needs to be compared. Thankfully, there are some cool features in Excel that allow you …
If you want to calculate the number of months between two dates in Excel, subtracting one date from the other will only give you days. That is because months do not all contain the same number of days. Excel can return completed months, decimal months, or every calendar month touched. In this article, I’ll show …
If you work with names datasets, sorting it is one of the common tasks you would have to do often. It’s quite easy to sort data alphabetically based on the full name, where Excel uses the first character of the name to sort. But what if you want to sort data by the last name …
Excel has some really smart features that can be really useful in many cases (and sometimes it could be frustrating). One such area is when you enter numbers in Excel. Sometimes, Excel automatically changes these numbers to dates. For example, if you enter 1/2 in Excel, Excel will automatically change this to 2-Jan (or 1-Feb …
Most of the people who work with Excel spreadsheets deal with numbers in large/small datasets. And when you work with numbers, you will have all types of it (positive, negative, decimals, date/time). One of the common tasks a lot of us need to do often is to convert these numbers from one format to another. …
In Excel, you can easily remove cell formatting with a few clicks (or a keyboard shortcut). You can also copy-paste formatting from one cell/range to the other. Or, you can choose to clear the formatting from cells that contain a specific value or a specific format. In this short Excel tutorial, I will show you …
It’s amazing how you can find multiple ways to do the same thing in Excel. After all, there are so many awesome functionalities and functions. A really simple and often needed task is to calculate the square root in Excel. And as I said, there are multiple ways you can do that in Excel (formulas, …
By default, date and time are saved as numbers/decimals in Excel. But you often see it in different formats because of the way the cells have been formatted. For example, in the below example, the value in column A and B is the same, but these are displayed differently because of the format. And one …
©trumpexcel.com – Free Online Excel Training
