LEN Function
LEN Function – Counting Characters in a Cell LEN() is one of those functions that you wonder about. LEN is a text function and depending upon… Read More »LEN Function
Functions
GETPIVOTDATA Function
I am in the process of updating my Pivot Table course and decided that I take another look at the GetPivotData function. GET PIVOT DATA is an… Read More »GETPIVOTDATA Function
AGGREGATE Function
The AGGREGATE Function The AGGREGATE function is a very powerful function for summarizing an array of data. It combines 19 different ways to summarize data… Read More »AGGREGATE Function
EOMONTH
Date Function EOMONTH displays the serial number of the last day of the specified month. You can use this to calculate maturity dates and due dates… Read More »EOMONTH
Ways to Sum Data with Errors
Excel Techniques to Sum Data with Errors There are times that you need to know the sum of numeric data even though there may be… Read More »Ways to Sum Data with Errors
An Automated Alternative in Excel
Automated alternative to FlashFill (and the “Text to Columns” Wizard) My Excel tip is not so much about a favorite “tip or trick” as it… Read More »An Automated Alternative in Excel
The N() function. Comments Anyone?
Most people are familiar with Insert>Comment. Just right-click on a cell and select Insert>Comment. Very easy. Right-click on the comment to display it, edit it or… Read More »The N() function. Comments Anyone?
Computing a Loan Payment & Creating an Amortization Schedule
Computing the Periodic Payment for a Loan Excel Financial Function Computing the periodic payment is probably the most used Excel financial function simply because it… Read More »Computing a Loan Payment & Creating an Amortization Schedule
Using Workday to Calculate Invoice Dates
This is just a quick tip as Excel is not necessarily that date friendly. If you want to calculate an invoice date or a project… Read More »Using Workday to Calculate Invoice Dates
Preventing Duplicate Entries using Data Validation in Excel
If you are setting up a spreadsheet for someone else to enter data this is a neat trick. You can use the Data Validation and… Read More »Preventing Duplicate Entries using Data Validation in Excel