Getting a Circular Reference error in Excel can be intimidating. But it doesn’t have to be. Let’s take a look at what Circular Reference errors are and how you can fix them. Circular Reference in Excel WATCH: Circular Reference Error in Excel – Tutorial What does Circular Reference mean in Excel??? A Circular Reference is […]
Excel Tutorials
How to Design the Comment Box in Excel – Tutorial
Excel tutorial on how to design the Comment Box in Excel. We’ll go over how to format the color, borders and other aspects of the box and then over how to change the shape of the Microsoft Excel Comment Box. Watch how we create a heart-shaped comment box for our spreadsheet! 💚
How to Use Subtotal in Excel – Tutorial
Excel tutorial on how to use Subtotal in Excel. We’ll use the Subtotal button, found in the Data tab, and then go over how to use the SUBTOTAL function. The SUBTOTAL function in Excel is made up of 2 things: a math calculation (in the form of a function) and the data to be subtotaled. […]
Create a Custom Sort List in Excel (+ video tutorial)
You’ll want to create a custom sort list in Excel for items that you don’t want to sort in alphabetical or numerical order. By doing a custom sort list you can specify the order in which your list will be sorted in. Let’s say you need to sort a list where the items are rated […]
How to Save an Image from Excel (+ video tutorial)
Knowing how to save an image from Excel can come in handy. Like if you want to save an Excel chart as a jpg or png image file to use in a presentation. In this Excel tutorial, you’ll learn, step-by-step, a few different ways that you can save an object in Excel as an image […]
How to Round Time in Excel – Tutorial
Excel tutorial on how to round time in Excel. Excel has many rounding functions, but, we’ll use MROUND in this tutorial because I like how it’s able to round up or round down to whatever multiple we want to use. There are many reasons why you may need to round time, but, a common use […]