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.
Filling a background color in a cell or range of cells is a common task that most of Excel users have to do on a daily basis. While it’s quite easy to fill color in a cell in Excel (using the inbuilt option in the ribbon), it’s not the fastest way to do it. And …
‘Active Cell’ is an important concept in Excel. While you don’t have to care about the active cell when you’re working on the worksheet, it’s an important thing to know when working with VBA in Excel. Proper use of the active cell in Excel VBA can help you write better code. In this tutorial, I …
If you want to separate text and numbers in Excel, there isn’t a built-in one-click feature for this specific job. For example, you may need to split MKT175 into MKT and 175 in different columns. But there are features and formulas that can do this, and in this tutorial, I’ll show you four easy ways. …
While working with dates in Excel, you may have a need to fill a column only with the dates that occur on a weekday. This is usually needed when you’re creating a project plan, where only the weekday dates can be used, and the weekend dates are holidays. In this short tutorial, I am going …
There are multiple ways you can display a number in a cell in Excel. And one of the ways you can format a number is to show it as a date (for that corresponding serial number) When you see a date in a cell in Excel, in the back end it is still stored as …
The default setting in Excel is to show all the tabs (also called sheets) below the working area. But if you can’t see any tabs and are wondering where has it disappeared, worry not. There are some possible reasons that may have been the cause of missing tabs in your Excel workbook. In this article, …
Working with a large Excel workbook that has multiple sheets could be challenging. Even advanced Excel users feel overwhelmed when trying to switch between multiple worksheets in the same workbook. Imagine working on an Excel workbook with 15 worksheets, and having to constantly switch between worksheets #3 and #12. There are multiple ways to switch …
Excel Quick Analysis Tool allows you to quickly analyze data. It gives you quick access to some of the commonly used data analysis functionalities in Excel so that you don’t have to go into the ribbon and find the correct option (hence saving some clicks and a little bit of time). In this tutorial, I …
If you enter a number that has more than 11 digits in a cell in Excel, it will automatically be converted into the scientific notation (as shown below). While the number in the back end would still remain the same, Excel changes the way it shows you that number. Sometimes that’s what you want, and …
©trumpexcel.com – Free Online Excel Training
