How to use the UPPER Function in Excel - 2 Examples
What is the upper function and how do you use it? The UPPER function explained.
top of page
Recent Posts
How to use the RAND Function in Excel - 3 Examples
What is the RAND function and how to use it with multiple examples.
How to use the RANDBETWEEN Function in Excel - 4 Examples
How to use the RANDBETWEEN function with multiple examples and use cases.
How to use the RANDARRAY Function in Excel - 6 Examples
6 examples of how to use the RANDARRAY function in Excel from basic to advanced.
What Is the EVEN Function and How to Use It in Excel - 2 Examples
The even function rounds any numerical value away from zero, to the nearest even integer.
What Is the ODD Function and How to Use It in Excel - 2 Examples
The odd function rounds any numerical value the nearest odd integer (whole number).
What Is the N Function and How to Use It in Excel - 2 Examples
The N function converts non-number values to a number, dates to serial numbers, TRUE/FALSE to 1/0 respectively, and everything else to 0....
How to Sum Across Multiple Dynamic Arrays by Row in Excel
How to sum across multiple dynamic arrays in a dynamic, flexible formula using the BYROW and LAMBDA Functions.
Excel's Secret Formula: =DATEDIF( )
An easy way to find the number of days, months, or years between two dates.
How to Update Pivot Table Data Sources on New & Copied Workbooks with VBA
When copying workbooks, sometimes Pivot Tables/Caches Won't update and link properly, here's a work around.
What Is the Best Way to Learn Excel?
Excel is massive. It can be intimidating to learn. What's the best way to start? What different methods are there to help you learn?
What is Excel? A General Overview and History
What is Excel? Why do people use it? What came before it?
Understanding the Basic Layout of Excel
If you're just learning to use Excel, learning to navigate efficiently is a crucial building block that will allow you to get better,...
How to Perform Mathematical Operations Using Paste
How to add, subtract, multiply, and divide any size range without the need to create extra columns. All with paste.
bottom of page