Excel Tips

Total Without Using a Formula »

December 6, 2021

My manager called on the telephone, asking for the total sales of a particular product. I need to quickly find a total. Is there a faster way than entering a formula?

Use Named Constants to Store Numbers »

December 3, 2021

I’ve seen how to assign a name to a cell. Is it also possible to assign a name to a constant? That could be useful for a number, such as a local sales tax rate, that changes periodically.

Create Easier-to-Understand Formulas with Named Ranges »

December 1, 2021

How can I create easier-to-understand formulas?

Learn R1C1 Referencing to Understand Formula Copying »

November 30, 2021

All of a sudden, the column letters along the top of my spreadsheet have been replaced by numbers. None of the formulas I enter will work. What’s wrong?

Simplify the Entry of Dollar Signs in Formulas »

November 29, 2021

It is a pain to type the dollar signs in complex formulas such as the formula in the previous topic. How can I make this job easier?

Calculate a Sales Commission »

November 26, 2021

The VP of sales in my company has dreamt up the most convoluted sales plan in the history of the world. Rather than just paying the reps a straight commission, this plan involves paying a base rate and a 2% bonus based on the product sold, and a monthly profit sharing bonus. For the spreadsheet below, I need to create a formula that can be copied to all rows and all months.

Create a Multiplication Table »

November 25, 2021

I want to create a multiplication table to help my kids in school. I want to be able to enter a single formula in cell B2 that I can copy to the entire table.

Copy a Formula While Keeping One Reference Fixed »

November 24, 2021

I have 5,000 rows of data. Each row contains a quantity and the unit price. The sales tax rate for all orders is shown in cell C1. After I enter a formula to calculate the total with sales tax in the first row, how do I copy the formula down to other rows?

Copy a Formula That Contains Relative References »

November 23, 2021

I have 5,000 rows of data. After entering a formula to calculate gross profit percent for the first row, how do I copy the formula down to other rows?