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.
In my last article, I wrote about mouse double-click tricks. In this tutorial, I will show you some amazing things you can do in Excel by using a combination of mouse and keyboard. Shift Rows/Columns/Cells Suppose you have three cells, and you want to shift the content of cell A1 to cell A3 (as shown …
In my first job, we had to go through a rigorous 3-week training before we got any real work. One of the trainers was a 40 something guy with awesome Excel skills. I used to call him the Excel Superman. I still remember the first thing that he told us was to avoid the use …
There is no one size that fits all. When it comes to Excel, the default settings work fine in most of the cases. But if need be, you can easily customize many of the Excel Options. In this blog post, I will show you how to use Excel Options to customize your workbooks and get a …
As the world goes crazy (including me) over the new season of Game of Thrones, I thought it would be a good idea to visualize its data by creating an Excel Dashboard. Using my substandard secondary skills, I was somehow able to find enough data points to create an awesome Excel dashboard. There are many …
WUHOOOO.. we are past the 2000 subscribers mark. You can imagine me doing the Happy Dance right now 🙂 This is a huge milestone for me and I am completely overwhelmed by the love and support I have got from my readers. I started this journey ~2 years ago and it has been a heck …
Excel built-in data sorting is amazing, but it isn’t dynamic. If you sort data and then add data to it, you would need to sort it again. Sort Data in Alphabetical Order In this post, I will show you various ways to sort data in alphabetical order using formulas. This means you can add data, …
I get this query all the time. People have huge data sets and someone in their team has highlighted some records by formatting it in bold font. Now, you are the one who gets this data, and you have to filter all these records that have a bold formatting. For example, suppose you have the …
Excel Filter is one of the most used functionalities when you work with data. In this blog post, I will show you how to create a Dynamic Excel Filter Search Box, such that it filters the data based on what you type in the search box. Something as shown below: There is a dual functionality to …
The easiest way to concatenate a range in Excel is the TEXTJOIN function, which joins a whole range of cells into one cell and lets you pick the separator. If you don’t need a separator, the CONCAT function does the job with a shorter formula. You’d think the CONCATENATE function would handle this too, but …
©trumpexcel.com – Free Online Excel Training
