|
Learn to love Excel - one cell at a time. Tutorials for beginners, tips for experienced users
| CREATE A DROPDOWN LIST IN EXCEL- 2012-09-18 07:33:19-04 |
A useful skill to have – particularly if you need to do analysis on a list (in pivot tables etc) as you want to ensure that your data entry is kept consistent. It’s also a real time saver it you need someone else to input data for you and you want to restrict data entry. [...]
Read more...
|
| NAME A RANGE IN EXCEL- 2012-09-19 05:20:14-04 |
So first of all what does this mean and why would you bother? Let me give you two examples =sum(a1:a10) or =sum(salaries) Which do you think looks easier to read and understand? Yes, the second one. So a very useful way to help document and clarify your spreadsheet is to create range names and to [...]
Read more...
|
|