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.
______________
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. ______________
In an Excel pivot table, you can use built-in custom calculations, for a different view of the data. For example, in this video I set up the pivot table to show what % of monthly sales were Binders, and what % for each colour – red, blue, and black. You can get the sample file…
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 ______________
In Excel 2003, if there are duplicate items in a list, you can delete them by using an Advanced Filter. To remove the duplicates, follow the steps in this short Excel video tutorial. ______________
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 ____________________