This lesson you should be formatting V.1.0 of your budget model for the Tokyo trip.
In other words, you must change the appearance of your model so that it is simple and easy to use. Your model should have a design so that all of the information that people do not need to see is hidden (usually cells containing formulas).
Also, you can use hyperlinks to link your sheets together and include validation to prevent people from making mistakes. Choose a good color scheme, attractive fonts and select a few images wisely.
Save your work and embed your model into your Blog. Call it 'Budget Model v2.0
Extension:
Check out this video tutorial.
What does the VLookup tool do? How could you include this feature in your spreadsheet model?
In other words, you must change the appearance of your model so that it is simple and easy to use. Your model should have a design so that all of the information that people do not need to see is hidden (usually cells containing formulas).
Also, you can use hyperlinks to link your sheets together and include validation to prevent people from making mistakes. Choose a good color scheme, attractive fonts and select a few images wisely.
Save your work and embed your model into your Blog. Call it 'Budget Model v2.0
Extension:
Check out this video tutorial.
What does the VLookup tool do? How could you include this feature in your spreadsheet model?
No comments:
Post a Comment