Excel Tips
Yes, Formula Autocomplete Is Cool, if You Can Stop Entering the Opening Parentheses »
January 18, 2022
Formula AutoComplete lets me type just a few characters. I can just type =RA in a cell, and Excel will show me all the functions that start with RA. I don’t have to type my functions anymore, but why do I get an error every time I try to do this?
Use the Function Arguments Dialog with Nested Functions »
January 17, 2022
Can I build an INDEX and MATCH formula using the Function Arguments dialog?
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?