Excel tutorial on 4 ways to round in Excel. We’ll look at ROUND, ROUNDUP, ROUNDDOWN and MROUND functions. It might seem odd that there are so many rounding functions but having them helps add flexibility to meet the needs of different projects. Here’s how these rounding functions differ: 1. What is the ROUND function in […]
Excel Tutorials
How to Use Option Buttons to Filter a Chart in Excel – Tutorial
Excel tutorial on how add Option Buttons to filter a chart. One of the Form Control tools, the Option Buttons will also help make the chart interactive. In the example in this tutorial, we’ll assign macros to the Option Buttons, or Radio Buttons, to filter the chart just by selecting a button.
How to use the MATCH Function in Excel – Tutorial
Excel tutorial on how to use the MATCH function in Excel. The MATCH function returns a value that represents the location of a specific item within a selection. In this tutorial, we’ll first walk through the basics of how the MATCH function works and we’ll follow that with an example of the MATCH function used […]
How to Use the CHOOSE Function in Excel – Tutorial
Excel tutorial on how to use the CHOOSE function in Excel. The CHOOSE function returns the value of an item in a list based on the order of its location when that list was added to the function. In this tutorial, we’ll look at 2 examples of the CHOOSE function: In the first example, we’ll […]
How to Make Drop Down List + List Box Using Form Controls in Excel – Tutorial
Excel tutorial on a couple of ways to make lists in Excel where users can select items using Form Controls. We’ll create a drop down list and then make a List Box. We’ll do both using Form Controls. What are Form Controls??? Located in the Developer Tab, Form Controls in Excel are objects that make […]
How to Make Graph Paper in Excel (+ video tutorial)
Is it possible to make graph paper in Excel that you can print? After all, a spreadsheet is just a bunch of grids. Yet, if you tried to make grid paper in Excel, you probably realized it’s a bit trickier than it seems. That’s because you can’t print only the gridlines: So, is it even […]