Excel Tips
Get Help on Any Function While Entering a Formula »
January 14, 2022
There are hundreds of functions available in Excel. Sometimes I remember that I need to use a particular function, but I cannot remember the sequence of the arguments in the function.
Discover New Functions Using the fx Button »
January 13, 2022
There are hundreds of functions available in Excel. I know that I want to find a function to calculate a car payment, but I have no clue which function might do this.
Automatically Number a List of Employees »
January 11, 2022
I work in human resources, and I have a list of employees, separated by department. I have a numeric sequence in column A and the employees’ names in column B. Every time the company hires or fires an employee, I have to manually renumber all the employees. How can I make this job easier?
January 10, 2022
I’ve marked several cells in red. I need to total the red cells.
The Count Option of the AutoSum Dropdown Doesn’t Appear to Work »
January 7, 2022
I am using the Count option from the AutoSum dropdown on the toolbar, but it does not appear to provide consistent results. Cells B11 and C11 both contain counts of the cells in rows 2 through 10 of each column. One function indicates that there are nine entries; the other function indicates that there are only two. Clearly, both columns have nine entries. What is the problem?
January 6, 2022
I routinely have to sum and average the same range. The sum is easy enough with the AutoSum. But when I try to do the average, the formula above is in the way.
Use the AutoSum Button to Enter Averages, Min, Max, and Count »
January 5, 2022
I often enter totals formulas, but in this case, I need to enter an average formula. How can I do it quickly?
AutoSum Doesn’t Always Predict My Data Correctly »
January 4, 2022
When I use the AutoSum button, Excel sometimes predicts the wrong range of data to total. Below, AutoSum worked fine in F2 and F3, but in cell F4, Excel thought I wanted to total the rows above F4. How do I enter the correct range?
Use AutoSum to Quickly Enter a Total Formula »
January 3, 2022
I have numeric data in Excel. I need to total the rows quickly.