How are dates stored in Excel?
Learn how dates are stored sequentially in Excel.
CONCAT Function
The Excel CONCAT Function joins a range of cells or individual strings of data. This function was introduced in 2016 as a...
Average Annual Growth Rate (AAGR)
Learn how to calculate the Average Annual Growth Rate (AAGR) in Excel.
INDIRECT Function with Named Ranges
In this tutorial, we are going to cover how to use the INDIRECT Function with named ranges in Excel. Before we begin,...
Round Numbers in Excel
Rounding numbers in excel is critical in order to make spreadsheets look more professional.
Print to X Number of Pages
Sometimes when using Excel you may want to customize the way that you print the information you are working with. One option...
Create a Drop Down List
If you want to force user for selecting data from the fixed data items and prevent user from entering custom data for any...
Create a Dynamic Name Range Table in Excel
Learn to create a dynamic name range in Excel
Named Ranges in Excel – Setup, Rules, and Uses
Learn how to use Named Ranges in Excel.
GOAL SEEK in EXCEL – What-If Analysis
Learn to master Goal Seek in Excel. We cover multiple real world examples.
