Excel tutorial on 2 ways to pull data from a website into Excel without copying it. Both of the ways we’ll look at will create a connection with the web page you select. You can then choose to leave the connection active so you can refresh the data in the future or disconnect if you […]
Excel Tutorials
Change the Gridline Color in Excel Spreadsheets – 2 Ways!
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 […]
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 […]