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.
I love using Conditional Formatting in Excel. It allows me to quickly highlight and format cells based on specified conditions. While Conditional Formatting is great, it’s also volatile – which means that if you have a lot of conditional formatting rules applied to large data sets, it can slow down your Excel file. So, I …
Cells are the building blocks of a worksheet in Excel. Most Excel users spend the majority of their time working with the cells in Excel – be it entering data or formulas or editing the already entered formulas/text. In this tutorial, I will cover everything you need to know about editing cells in Excel. While …
The Pivot Table feature is used by many Excel users – beginners as well advanced. One thing that often troubles new Pivot Table users is when they find that a Pivot Table Fields list (some people call this Pivot Table Fields menu) goes missing. You can’t do much with a Pivot table if you do …
Pivot tables are very easy to create and even easier to move to some other worksheet or a new worksheet in the same Excel workbook. Many Excel users often end up creating multiple Pivot tables in the same worksheet, which is not a very organized way of doing things. But thanks to a readily available …
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 …
Sometimes you may have the text and numeric data in the same cell, and you may have a need to separate the text portion and the number portion in different cells. While there is no inbuilt method to do this specifically, there are some Excel features and formulas you can use to get this done. …
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 …
©trumpexcel.com – Free Online Excel Training
