Logged out
Access All our Essays in an Instant
Swap your work for FREE access, or pay £4.99 for instant access
In the following report, I will describe, using screenshots, the advanced features of Microsoft Excel I have used in the spreadsheet system.
Member rating: No Rating | Words: | Submitted: Thu Aug 21 2003
Page Preview
On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:
Implementation Advance Features Report In the following report, I will describe, using screenshots, the advanced features of Microsoft Excel I have used in the spreadsheet system. 1. Macros I used macros in mostly all parts of the system to link the sheets together. After creating a box using the drawing toolbar and adding the appropriate text, I right clicked on the box, selected 'assign macro' and in the dialogue box typed 'moveto........' and clicked 'record'. I then clicked 'ok' in the next dialogue box from which appeared. I then went to the sheet that the particular was to open and selected the 'stop recording' button, shown in the icon above. 2. Check Boxes/COUNTIF Function/Training Chart Above is part of the 'Training' section of the 'Staff' sheet. Here I used checkboxes to show which of the six modules have been completed by each of the Pharmacy employees. I created the tick boxes by clicking on the 'View'...
Get instant access
- Instant, unlimited access to our documents in full
- Swap your work for free access, or pay £4.99
- To see the full version of this document and 150,112 others
