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.
Among the many awesome features in Excel, the Name Box doesn’t get talked about enough. While it looks like a simple name box (just like its name says), there are some cool things you can do with it. In this article, I will cover everything you need to know about Name Box in Excel and …
When doing data entry work in Excel, you may want to prevent entering duplicate entries in a column or a range of cells. Thankfully, there is a feature in Excel that allows you to do precisely this – and it’s called Data Validation. In this article, I will show you how to prevent duplicate entries …
Conditional Formatting allows you to add a visual layer to your dataset and make it easier to understand. You can use it to quickly highlight cells that satisfy the specified conditions (such as highlighting cells with the top 3 values or highlighting all cells that contain the word ‘Excel’, etc.) But sometimes Conditional Formatting may …
Most of my work involves getting data from various sources, such as databases, webpages, or other people. In most cases, the first step is to clean the data and make it usable for my analysis. Sometimes, I get datasets that have an additional character in the end that I want to remove. Thanks to some …
There are multiple ways to calculate the square of a number in Excel. You can use the in-built POWER function or the Caret operator (^). Let me show you how to quickly calculate the square of a number in Excel. Using the POWER Function POWER function allows you to get the square, cube, or any …
Sometimes, it happens that instead of showing the result of a formula in Excel, you see the formula itself. Below, I have an example where I have a formula in column C, and instead of showing the result of the formula, Excel shows the formula itself. This is a pretty common occurrence with Excel users, …
Many of my projects involve working with data from the web, where I get hyperlinks in cells in Excel when I copy the data from other sources. Something as shown below (source): One of the first things I often have to do is extract the URLs from these hyperlinks so that I can do my …
I was recently working on a project where I had some dates and had to classify each date into its fiscal year (also sometimes called the financial year). While Excel does not have a dedicated function to do this, it can quickly be done using a combination of functions. In this article, I will show …
When working with dates and making project plans in Excel, you may come across a situation where you want to know how many weeks there are between two dates. While there is no built-in function to do this in Excel, this can easily be done using other simple functions. In this short article, I will …
©trumpexcel.com – Free Online Excel Training
