tkaplan
09-16-2009, 07:47 AM
So I'm the excel geek in my company. and people come to me to help them format the spreadsheets, but after they have messed them up so bad that it's easier to start from scratch: merged cells galore (so array formulas dont work), blank columns to create space (instead of just indenting the data), using spaces to get to the next line instead of alt+enter, etc.
So I am on a mission to teach people who know very very very little about excel some basics to make life easier for them and save my sanity.
I have started weekly tips and am compiling a list of basics to teach and am asking for some input of any other very simple things that i can teach them (like alt+enter, center across selection) etc.
Here is the list I have so far. Any input would be greatly appreciated!
1. alt+enter
2. center accross selection
3. no blank columns - use resize and indent
4. wrap text
5. & sign dont show up in header and footer - need to use &&
6. paste vs. paste special
7. drawing borders (for presentations)
8. round() function
9. validation
10. sumproduct() funcation (I will only teach the very basic - not all the advanced stuff you can do with it. it will fly above their heads)
11. set print area
12. printing multiple tabs at the same time or entire workbook instead of clicking every tab individually (they couldnt figure out how i could print a 30 tab workbook in 2 seconds ....then i realized they were clicking every tab individually!)
13. conditional formatting based on cell value (i think based on formula may be too complicated for now)
14. referencing other spreadsheets within the same workbook so no redundant data
Any input would be greatly appreciated!
So I am on a mission to teach people who know very very very little about excel some basics to make life easier for them and save my sanity.
I have started weekly tips and am compiling a list of basics to teach and am asking for some input of any other very simple things that i can teach them (like alt+enter, center across selection) etc.
Here is the list I have so far. Any input would be greatly appreciated!
1. alt+enter
2. center accross selection
3. no blank columns - use resize and indent
4. wrap text
5. & sign dont show up in header and footer - need to use &&
6. paste vs. paste special
7. drawing borders (for presentations)
8. round() function
9. validation
10. sumproduct() funcation (I will only teach the very basic - not all the advanced stuff you can do with it. it will fly above their heads)
11. set print area
12. printing multiple tabs at the same time or entire workbook instead of clicking every tab individually (they couldnt figure out how i could print a 30 tab workbook in 2 seconds ....then i realized they were clicking every tab individually!)
13. conditional formatting based on cell value (i think based on formula may be too complicated for now)
14. referencing other spreadsheets within the same workbook so no redundant data
Any input would be greatly appreciated!