Excel Tips
October 29, 2002
Is there any way to have Excel show or print the formulas rather than me having to move the cell pointer to check each formula in the formula bar?
October 22, 2002
I have a database of events in Excel and my boss wants me to plot frequency charts by month.
October 15, 2002
Trying to convert a supplier price book in Excel to match their UPC codes to our UPC code system.
Relative And Absolute Formulas »
October 8, 2002
Is there a single formula in cell B2 which can be copied across and down to create a multiplication table?
Record Modify Run Excel Macro »
October 1, 2002
Many of the Excel tips involve some sort of macro trick. This week, for the Excel users who have never written a macro, I offer a primer on how to record and then customize a useful Excel macro.
September 24, 2002
I love Quicken, but it certainly has its annoyances.
Print Every Value In Page Field »
September 10, 2002
I have an Excel pivot table set up with 150 different values in the page field. How can I run a macro to print each individual page?
September 3, 2002
How to make sure that duplicate invoice numbers are not entered in a particular Excel column.