How do you create a nested formula in excel?
What causes #ref in excel?
How do you unlock an excel spreadsheet for editing?
How do you quickly insert a row in excel?
How can I compare two excel files?
How to access my copy file?
What are pivot tables used for?
Why do the column headers show numbers instead of letters? How do I change my column headings so they are back to letters instead of numbers?
What is a spreadsheet used for?
I create lots of graphs with excel. Unfortunately, the options to which excel defaults are not the ones I use most. Is there any way to change the graph defaults to theones I prefer?
Is it possible to determine the day of the week for a particular date?
I want to count the number of cells in a range that have a particular interior color. The countif function seems like the right kind of answer but how to I return thecolor of the interior for each cell in a range? I would like to do something like: =countif(b1:b10, cell("interior","red"))?
What is a waterfall chart in excel?