Excel tutorial on how to edit a macro in Excel. We’ll also do a brief overview of how the VBA editor is laid out. The VBA editor is the tool that Excel uses for macros. In this tutorial, we’ll use the VBA editor to make a change to a macro.
Excel Tutorials
How to Make a 12 Month Wall Calendar in Excel – Tutorial
Excel tutorial on how to make a wall calendar using Excel. We’ll make a 12-month calendar in legal size paper that you can print and display on your wall! Sometimes, it’s easier to have a wall calendar next to you that you can just look at as you work. This way, you can learn to […]
How to Protect Cells in Excel – Tutorial
Excel tutorial on how to protect cells in an Excel worksheet. In the example in this tutorial, we’ve created a form in which we want to protect some cells, but allow other cells to be edited by other users. To do this, we’ll lock cells that contain a formula and labels but unlock cells where […]
Top Reasons Why Excel Formulas Won’t Calculate & How to Fix (+ video tutorial)
Have you ever felt distressed when you’re using Excel, you type formulas in your spreadsheet and the formulas don’t calculate??? Or they don’t calculate and look more like a sentence than a formula? There could be several reasons why your Excel formulas won’t calculate. 3 Reasons Why Your Excel Formulas are Not Working Watch Tutorial: […]
How to Make an Organizational Chart in Excel (with video tutorial)
Did you know that you can make an organizational chart in Excel??? In this tutorial, you’ll learn how to make an org chart in Excel using SmartArt. NOTE: SmartArt graphics are available starting with Excel 2007. But, first, is this the right program for your organizational chart project? SmartArt org charts in Excel have a […]
How to Use IFS in Excel – Tutorial
Excel tutorial on how to use the IFS function in Excel. Available in versions of Excel 2016 or better, the IFS function works like the IF function in that it returns a value based on criteria you set. It differs from IF in that IFS doesn’t require a statement if False. Plus, hence the name, […]