If you find Excel VBA code on a website or a sample file, you can copy it to your own Excel file.
Follow the steps in this short Excel video tutorial to copy the code.
For detailed instructions please read the article Excel VBA – Adding Code to a Workbook
______________
Sometimes it’s easy to make an Excel chart, and sometimes a struggle. There are days when you feel like a superhero, if you just manage to build a simple chart, and change the colours in it! Here are a couple of short videos that show how to work with Excel pie charts, and win the…
Highlight all the cells in a row, if one cell is above or below a specific value. To do this, use Excel conditional formatting, as described in this short Excel video tutorial. For detailed instructions, please visit the page Excel Conditional Formatting Based on another cell ____________________
If you copy data from another program to Excel, Excel might treat the numbers as text, and totals that use these numbers will be incorrect. This video shows the simple steps to change the text "numbers" to real numbers. For written instructions, visit Convert Text to Numbers ______________________
Use the Excel IF function when you want to test something. The IF formula will show one result if the test result is True, and a different result if the test result is False. For example: Check if cell D7 is empty. If it is, the result is an empty string. If not, multiply C7…
It’s easy to name a group of cells in Excel, then use that name for navigation. This Excel video tutorial shows you the steps. For a written Excel tutorial on naming ranges, see naming ranges in Excel. ______________
When you link to data in a pivot table, you may see a GETPIVOTDATA formula, instead of a simple cell reference. To turn this feature off, follow the instructions in this short video. For written instructions, please see Turn Off GetPivotData Formulas for Excel Pivot Tables. ________________