Blog - Excel University
Round to the Nearest 5 in Excel Using 3 Different Functions
Whether you’re working with something like test scores, tracking expenses, or any other type of dat…
Read more
Blog - Excel University
How to Create a Simple Basis Points Calculator in Excel
Microsoft Excel is fantastic since it simplifies the process of creating and managing a portfolio (…
Read more
Blog - Excel University
Create an Average Daily Balance Calculator in Excel
Whether you’re tracking your personal or business finances, an average daily balance calculator in …
Read more
Blog - Excel University
How to Find Merged Cells in Excel (& What You Can Do Instead)
You’ve probably come across situations where Excel didn’t allow you to make certain changes to your…
Read more
Blog - Excel University
How to Remove Leading Spaces in Excel
Any work you do in Excel is built around data. The cleaner the data is, the easier worksheets are t…
Read more
Blog - Excel University
How to Square a Number in Excel
Squaring numbers are helpful in all different kinds of calculations, but it can be a tedious task i…
Read more
Blog - Excel University
Four Ways to Select Every Other Row in Excel
Selecting every other row in Excel can be helpful. Aside from making it easy to get rid of duplicat…
Read more
Blog - Excel University
Skipping Excel 3
In this third and final post of the Skipping Excel series, we’ll connect all the dots and use Zapie…
Read more
Blog - Excel University
Skipping Excel 1
Excel is used for many different tasks, such as budgeting, reporting, comparing bank statements, an…
Read more
Blog - Excel University
What’s #REF in Excel and How to Fix It
When a formula contains an invalid cell or range reference, the #REF! error is displayed. #REF! in …
Read more
Blog - Excel University
How to Clean Data in Excel – 8 Easy Ways
Man sitting at a desk with an open computer learning How to Clean Data in Excel The post How to Cl…
Read more
Blog - Excel University
CalCPA Article Instant Reconciliations
When you have two different lists that you need to compare, how do you do it? For example, you want…
Read more
Blog - Excel University
How to Count Cells That Contain Specific Text
Have you ever wanted to see how many times a certain text string pops up in a set of data? While yo…
Read more
Blog - Excel University
How to Hide Formulas in Excel (And Protect Your Worksheets)
Let’s say you’ve been building a worksheet to share with your coworkers. When you share it, they’ll…
Read more
Blog - Excel University
How to Merge Excel Files (Without Using VBA)
You might be surprised how much time is lost flipping between Excel workbooks trying to find inform…
Read more
Blog - Excel University
Two Easy Ways to Combine Date and Time in Excel
Excel contains plenty of options that make it easy to format cell values exactly how you want them:…
Read more
Blog - Excel University
List of files in Excel (easy way, no VBA macros or formulas)
In this post, I’ll answer a question about how to create a list of files in a folder (and any subfo…
Read more
Blog - Excel University
How to Make an Excel Dynamic Chart & Keep Your Updates Consistent
For the purposes of this discussion, a dynamic chart is a chart that automatically updates itself w…
Read more
Blog - Excel University
How to Perform a Frequency Distribution in Excel (no formulas)
Are you a school administrator who wants to see how student test scores are distributed, or maybe a…
Read more
Blog - Excel University
Use an Excel formula to insert pictures into cells with the IMAGE function
Microsoft recently announced the rollout of the new IMAGE function. It enables us to write a formul…
Read more
Social Plugin