In the Excel VBA Edit a Recorded Macro article, you saw the steps for making changes to an Excel macro that you had recorded.

I've uploaded a new video that shows the steps for editing the Excel macro, and stepping through the macro code by using the F8 key.

____________

I'd need wider columns to hold my golf scores, but this Excel template for golf scores might help you keep track of your annual progress.
 
There's also an annual summary sheet, that calculates your average score and best score for the year.

Conditional Formatting for Scores
The golf scores template uses conditional formatting to highlight the [...]

You can quickly create a named range in Excel, but it doesn't automatically expand to include new items that are added at the end of the list.

If you plan to add new items to a list, create a dynamic named range, by using an OFFSET formula. In this example, the formula entered in [...]

Lots of people visit the Contextures website looking for information on the Excel Count functions. Counting seems like an easy thing to do in Excel, if you've been using the program for a while. But, if you're just starting out, it might not be so obvious.
Count Quirks
There are a few quirks with the Count functions [...]

If you have a long list of items, you could use formulas to count how many times each item occurs in the list. It would take a few steps, including pulling a list of unique items from the list, then creating a formula to count each item.
I find it quicker and easier to create a [...]

When you summarize data in a pivot table, it usually shows a sum of the values. (If there are blanks or text values in the field, usually the pivot table shows a count instead.) In this pivot table, you can see the total labour cost for each Service Type.

If there are two or more [...]

If Excel data is on different sheets, you can create a pivot table using multiple consolidation ranges. It's better if the data is all on one sheet, but if you don't have that option, multiple consolidation ranges will pull all the data into one pivot table.
In Excel 2003 you can open the PivotTable and PivotChart [...]

Instead of copying and pasting, you can quickly copy data from a web browser to Excel, by dragging and dropping.
To see the steps in action, you can watch this 30 second video.

___________

There's a sample Excel workbook on my Contextures website that uses a bit of Excel VBA to automatically add new items to an Excel data validation drop down list.
For example, if the drop down list shows Apple, Banana and Peach, you can type Lemon in the data validation cell. Then, as soon as you press [...]

When you print an Excel worksheet, you can also print all the comments that have been added to the sheet. You can print the Excel comments the way they appear as pop-ups on the worksheet, or print all the comments at the end of the worksheet.
If you're using an older version of Excel, there are [...]