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.
If you have a list where the same value repeats, you may want every occurrence of that value to carry the same serial number, no matter where it shows up in the list. A regular 1, 2, 3 fill won’t do this, because it gives every row a different number. But it’s simple to fix …
In this tutorial, I will show you how to create a drop-down filter in Excel so that you can extract data based on the selection from the drop-down. As shown in the pic below, I have a created a drop-down list with country names. As soon as I select any country from the drop-down, the …
In some cases, you may want to insert an image in the comments boxes in Excel. For example, if you have a list of products, then inserting product images in the comment box could make your Excel sheet easy to use. As soon as the user would hover the mouse over a cell that has a …
A few days ago, I was working with a data set that included a list of companies in Excel along with their logos. I wanted to place the logo of each company in the cell adjacent to its name and lock it in such a way that when I resize the cell, the logo should …
Excel Text to Speech feature (also called Speak Cells in Excel) was introduced in the 2003 version of Excel. While I believe this feature is more useful in MS Word, PowerPoint, or even Outlook, you may find it helpful in Excel in some cases. As the name suggests, it converts text into speech and can …
Watch Video – Excel Camera Tool and How to Use it! For all those who think working with Excel is boring, here is your answer to them – Excel Camera Tool. Now, don’t get all excited. It’s is not about a fancy DSLR and lens. It’s just another feature with a cool name. To begin …
Copying and Pasting data is one of the most performed actions in Excel. There is a lot more to copy-pasting than a simple Control + C and Control + V. In this tutorial, you will learn all about the Excel Paste Special feature and useful Excel Paste Special Shortcuts. What is Excel Paste Special? What …
Formatting data not only makes it look good but increases the readability of the data set. If you work with data and create good looking client-ready reports, it will pay off to learn some Excel formatting shortcuts that you can use regularly and save time. In this tutorial, I am sharing my top five Excel …
©trumpexcel.com – Free Online Excel Training
