Scenario
You have convinced the company that spreadsheet models are the best way to analyse data. The company wants you to develop a complex spreadsheet to meet their needs. Exploit the full use of spreadsheet software by using advanced formulae, features and functions, and present data using charts and graphs. The company is now looking to take its work on sophistication even further, exploiting the software as much as it can with automated features.
This task has several stages, starting with creating a spreadsheet structure for a cash flow forecast or business year plan.
You will then add data and set up validation to ensure it is within a suitable range.
Next will be a series of formulae to calculate the remaining entries according to instructions provided.
You will then examine ways to present important parts of the data effectively and clearly.
No comments:
Post a Comment