The CONVERT function in Excel helps you do unit conversions from one measurement unit to another. For example, if you need to convert mph to km/hr. There are a TON of measurement units you can convert to and from! Some common ones are for weight and mass, distance, speed, time, and temperature, but there are […]
Excel Tutorials
How to Round in Excel – Tutorial
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 […]
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 […]