Explore Excel Deeply
Advanced Excel / Formulas / Functions
by Taryn N · Published April 3, 2017 · Last modified September 17, 2017
The NPV (Net Present Value) Function is used to calculate the net present value of an investment by evaluating a provided discount rate, a series of future payments (negative values) and income (positive values)....
The PV Function, FV Function, and PDURATION Function are all extremely useful financial functions. The Present Value (PV) Function is used to calculate the present value of a loan or an investment using a...
You’re here because you want to make stunning, interactive and professional dashboards with Excel. You’re at the right place. I am recommending the best Excel dashboard courses here. I have checked these courses personally (enrolled)...
Advanced Excel / Formulas / Functions
by Taryn N · Published March 28, 2017 · Last modified September 17, 2017
The CONVERT function is an extremely useful and relatively unknown Excel function. It converts a number from one unit of measurement to another unit of measurement. The CONVERT function can convert between units of...
Advanced Excel / Charts / Data Visualization
by Taryn N · Published March 24, 2017 · Last modified September 17, 2017
When you have more than one data series that you want to plot on the same chart, you can create a combination chart in order to deliver a visual representation of each of the...
Advanced Excel / Formulas / Functions
by Taryn N · Published March 22, 2017 · Last modified September 17, 2017
Using Flash Fill This is a question that is often asked namely, how to extract data from one column into another format or more than one column. We are going to see how to...
Advanced Excel / Data Analysis / Formulas / Functions
by Taryn N · Published March 20, 2017 · Last modified September 17, 2017
The Excel database functions are designed to help one retrieve relevant information from large sets of data stored in Excel. There are twelve database functions available in Excel namely: DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX,...
Advanced Excel / Formulas / Functions
by Taryn N · Published March 18, 2017 · Last modified September 17, 2017
Microsoft Excel provides efficient functions that allow one to search for and lookup data. Of the lookup functions – VLOOKUP, INDEX and MATCH and the database function DGET are the most useful and most...
by Taryn N · Published March 16, 2017 · Last modified September 17, 2017
Excel has a variety of date and time functions that are very useful when working with calculations involving dates and times. The DAYS function, not to be confused with the DAY function, returns the...
In this post, we shall discuss how you can navigate within a table, how you can select different parts of a table and how you can move a table from one location to another....
In this post, we shall learn how you can add new rows or columns in a table and how you can delete existing rows or columns from a table. You can add a new...
This post will deal with imposters! No, I mean table duplicate entries. We will be able to manage them, remove them, tame them according to our needs and desires by the end of this...
In this post, we will discuss how you can sort and filter the data of a table. The following table contains the data of a real estate company. Each item in the Header Row...
In this post today, we will be discussing the Slicer Feature in Excel. It is also possible to filter a table using Slicer feature. This feature is visually appealing, but not an efficient way...
Advanced Excel / Data Analysis / Formulas
by Taryn N · Published March 13, 2017 · Last modified September 17, 2017
Wildcard characters such as the asterisk “*”, question mark “?” and the tilde “~” can greatly extend searching, counting, and addition functionality in Excel. Excel wildcards can be used with functions such as AVERAGEIF,...
