Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
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 …
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, …
©trumpexcel.com – Free Online Excel Training
