The first step in adding filter options to every column in an Excel pivot table is to create it from your dataset. After organizing your data fields in the Rows and Columns sections, ensure the pivot table is set to a compact layout for a clear display. Turn on the “Field Headers” option. This one … Read more
We have treated relative references and absolute references in excel, now it is time for mixed references. Yes, you might have guessed, the mixed reference is a combination of the two types of reference stated earlier (relative & absolute reference). In today’s post we would take you through all you need to know about it … Read more
Absolute references in excel are vital to financial modeling. They are cell references which see the row and column coordinates remain constant whilst copying formula from once cell to another. You may know that the default referencing style of excel is the relative reference, and if you attempt to copy your formula to other cells, … Read more
Cell references are an integral part of excel use. In financial modeling, there is usually a need to refer to cells for various things like completing a function, data validation list, conditional formatting, named ranges and so on, and without knowing which type of reference you require, you may end up spending a lot of … Read more
The custom number format in excel is a very key feature that can help organize your data for presentation. Although excel has a lot of built-in number formats such as date, percentage, currency, time accounting, these may be limiting depending on how you want to organize your data. Thankfully, excel allows for including your custom … Read more
In excel, names can refer to cells, a specific value or a formula. These names can be used to make complex formulas easy to read and understand as you refer to the names instead of using a constant value or cell reference. The names can also serve as a data source in a data validation … Read more
Sometimes when copying data, you may find some annoying spaces either before, within or after the group of texts in each cell. Today’s post is dedicated to teaching you quick and easy ways to remove such spaces. Let’s begin Using Trim Function to remove Spaces The excel trim function is very handy in removing leading … Read more
Knowing how to insert bullet points may prove very useful when trying to articulate points in a clear and concise manner. It is for the reason that we would be touching on how to insert bullet points in Excel. There are various ways of inserting bullet points in excel but we would be reviewing the … Read more
In some cases, numbers copied may appear as texts, and this leads to incorrect calculations when you use affected cells as part of a formula or function in excel. Functions such as SUM or AVERAGE would ignore cells with text values while other functions such as VLOOKUP that requires an exact match to the number … Read more
When working with large data sets in excel, you quickly become accustomed to the find and replace dialog box which can serve as a very powerful tool to save countless number of hours on activities like changing formats, replacing links, replacing text in formulas, removing text and so much more. In today’s post we would … Read more
