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…
Chandoo started a new Excel series on his blog — How to create a fully interactive Project Dashboard with Excel. In this video for Part 1, Chandoo shows how to set up a Project Gantt Chart, and 3 more lessons in the series are coming.
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 ____________________
To highlight cells with a value that is too high or too low, you can use Excel Conditional Formatting. This short video shows you the steps. For detailed instructions see Excel Conditional Formatting Basics. ________________
Excel’s popup cell comments aren’t just for text. You can also display pictures in an Excel comment. This short Excel video tutorial explains the simple steps. For detailed written instructions see: Add a picture to a comment ______
You can quickly change values in Excel, without using formulas. Follow the steps in this short video to add, subtract, multiply or divide, by a specific amount or percentage. For detailed instructions, please visit Excel data entry tips. ______________