A nice simple Excel Services Demo
People just love Excel – However, some of the challenges that a lot of customers face are things like multiple versions of the same document, security, access, auditing etc –
A nice little Excel Demo that takes about 5 minutes to knock up shows a few of the features of Excel Services that can help.
First create a new Excel Spreadsheet in Excel 2007 and rename 3 worksheets Calc, Sales and Secret
On the calc sheet we're going to create a mini mortgage calculator
Add the following information
|
Loan |
100,000 |
|
Rate |
6% |
|
Years |
25 |
Highlight all 6 cells, click on the Formulas Tab and select Create From Selection and then put a check in the Left Column check box. You've now just created a named range for Amount, Rate and Loan.
In the next cell add the following
|
Payment |
=ABS(PMT(Rate/12,Years*12,Loan)) |
On the Sales Sheet add the following cells
|
North |
35365 |
|
South |
3232 |
|
East |
2323 |
|
West |
23423 |
The numbers aren't important –
Now select all 8 cells and select Insert and then Pie Chart
On the Secret Tab just write in anything eg "You shouldn't see this"
Now if you publish your spreadsheet click the Excel Services Option
On the Show Tab select Sheets from the drop down list and just select calc and sales (thus hiding the secret workbook)
On the parameters tab add in your named ranges - voila, that's the only information you can enter.
So know you've locked down a spreadsheet, got a single version of it that's secure.
It's that easy.
