Did you know you can change the gridline color in Excel spreadsheets? This is a great option to help your worksheets stand out or for color-coding. Say you have a workbook with multiple sheets and each represents something different, changing the color of the gridlines can help with your color-coding. There are a couple of […]
Excel Tutorials
How to Debug a Macro in Excel – Tutorial
Excel tutorial on how you can debug a macro in Excel. We’ll look at an example of a chart filtered by option buttons linked to macros. One of the macros has an error that we’ll need to fix. We’ll go over what caused the error, how to fix it and we’ll test the macro by […]
How to Create a Data Entry Form in Excel Without VBA – Excel Tutorial
Excel tutorial on how to create a data entry form in Excel without VBA. We’ll use the Forms tool to help you enter data faster by condensing your fields into an easy to use form. We’ll first set up our spreadsheet for the data entry, go over how to add and use the Forms tool, […]
How to Add a Spin Button + a Slider to a Chart in Excel – Tutorial
Excel tutorial on how to insert a Spin Button in Excel and how to add a Slider to a chart in Excel. We’ll do this to make our example chart more interactive. The Spin Button will help us update our example chart by allowing us to update the year chosen by simply clicking up or […]
What is an Array Formula in Excel??? – Tutorial
Excel tutorial introducing array formulas. We’ll go over what an array formula is in Excel, how to use one, and end with some tips to keep in mind when using array formulas. First, in Excel an array refers to a group of values – they could be in a row, column or both. An array […]
CONVERT Function: How to do Unit Conversions in Excel (+ video tutorial)
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 […]