[ Pobierz całość w formacie PDF ]
.USED FORcustomized" In the Toolbars list box, highlight the name of the toolbar." Click the Reset button to return the toolbar to its original format." Select Close when you have finished.TRAININGSAMPLE ONLY NOT TO BE USED FOR TRAINING© Cheltenham Computer Training 1995-2000 - Tel: +44 (0)1242 227200 - Fax: +44 (0)1242 253200Email: sales@cctglobal.com - Internet: http://www.cctglobal.com/ 64 Customizing Excel1995-2000 - Cheltenham Computer Training© Excel 2000 AdvancedReview Questions© Cheltenham Computer Training 1995-2000 Excel 2000 Advanced - Slide No.35Review Questions - How Would You.1.Use the View Options?2.Use the Calculation Options?3.Use the Edit Options?4.Use the Transition Options?5.Use the General Options?6.Use the Custom Lists Options?SAMPLE ONLY7.Use the Chart Options?8.Use the Color Options?9.Customize a toolbar?10.Reset a toolbar which you have customized?NOT TO BEUSED FORTRAININGSAMPLE ONLY NOT TO BE USED FOR TRAINING© Cheltenham Computer Training 1995-2000 - Tel: +44 (0)1242 227200 - Fax: +44 (0)1242 253200Email: sales@cctglobal.com - Internet: http://www.cctglobal.com/ Security and Proofing within Excel 65Excel 2000 Advanced ©1995-2000 - Cheltenham Computer TrainingSecurity and Proofing within ExcelLearning Module ObjectivesWhen you have completed this " Use the spell checkerlearning module you will have" Share a workbookseen how to:" Set data validation for a range of cells" Set Input messages" Set Error Alerts" Specify a password for opening or saving a workbook" Use passwords" Create backups" Hide worksheet elements" Protect cells" Use Auditing Tools" Manipulate commentsSAMPLE ONLYNOT TO BEUSED FORTRAININGSAMPLE ONLY NOT TO BE USED FOR TRAINING© Cheltenham Computer Training 1995-2000 - Tel: +44 (0)1242 227200 - Fax: +44 (0)1242 253200Email: sales@cctglobal.com - Internet: http://www.cctglobal.com/ 66 Security and Proofing within Excel1995-2000 - Cheltenham Computer Training© Excel 2000 AdvancedAuditing and Security Featureswithin Excel 2000" Spell Checker" Cell Notes" Password" Tracing" Information Window© Cheltenham Computer Training 1995-2000 Excel 2000 Advanced - Slide No.37Auditing and Security Features within Excel 2000Background If worksheets are developed for other users, it is important that the users find them easyto use, and hard to break .Protection should be built-in to the worksheets to preventunauthorized tampering with the sheet, but allow data entry, as required, to specificparts of the sheet.It is also very important that a worksheet is properly audited for errors, prior to releaseSAMPLE ONLYon other unsuspecting users.When developing worksheets for others bare in mind the following:" Protect items such as formulas and data that must not be changed." Protect or hide any sensitive information contained within the worksheet.NOT TO BE" You may want worksheets to be shared across a network." You should document any calculation or concepts contained within a workbook.Levels of security offered by Excel:" Top level security is offered by use of a password that restricts unauthorized usersfrom opening a workbook file.USED FOR" Workbook protection." Worksheet protection." Object protection (cells or charts).TRAININGSAMPLE ONLY NOT TO BE USED FOR TRAINING© Cheltenham Computer Training 1995-2000 - Tel: +44 (0)1242 227200 - Fax: +44 (0)1242 253200Email: sales@cctglobal.com - Internet: http://www.cctglobal.com/ Security and Proofing within Excel 67Excel 2000 Advanced ©1995-2000 - Cheltenham Computer TrainingSpelling Checker© Cheltenham Computer Training 1995-2000 Excel 2000 Advanced - Slide No.38The Spell CheckerTo use the spell " Select a single cell to check the entire worksheet.checker" From the Tools menu, select Spelling." If no incorrect words are found, the Spelling dialog box will not appear.A boxwill appear to tell you that Excel has finished checking the spelling." If the Spelling dialog box is displayed, select one of the following options:SAMPLE ONLYAdd Will add the word to the current custom dictionary.Cancel Will stop the spelling check.Change Will change this occurrence of the word to the word displayed in theChange to text box.Change All Will change all occurrences of the word to the word displayed in theNOT TO BEChange to text box.Ignore Will ignore the word and continue.Ignore All Will ignore all further occurrences of the word in the document.Suggest Will suggest alternative words from the dictionary.USED FOR" If you began the spelling check in the middle of the worksheet, you may beasked whether you want to continue checking at the beginning of the sheet.Select Yes." When the spelling check is complete, a box will appear.Select OK.TRAININGSAMPLE ONLY NOT TO BE USED FOR TRAINING© Cheltenham Computer Training 1995-2000 - Tel: +44 (0)1242 227200 - Fax: +44 (0)1242 253200Email: sales@cctglobal.com - Internet: http://www.cctglobal.com/ 68 Security and Proofing within Excel1995-2000 - Cheltenham Computer Training© Excel 2000 AdvancedWhat Are Shared Workbooks?" A workbook can be made available over anetwork and many people can work on the sharedworkbook at the same time" Each user can modify the workbook (includingthe data, rows, columns etc)" Each user can apply filters to the data and notaffect other users sharing the workbook© Cheltenham Computer Training 1995-2000 Excel 2000 Advanced - Slide No.39What Are Shared Workbooks?To allow " From the Tools drop downworkbook menu, select the Sharesharing Workbook command, which willdisplay the Share Workbookdialog box." Click on the Allow changes bySAMPLE ONLYmore than one user at thesame time check box." Click on the OK button and thesystem will force you to saveyour workbook at this point.NOT TO BE" When you re-open the ShareWorkbook dialog box, you willnotice that the Workbook is nolonger marked as exclusive
[ Pobierz całość w formacie PDF ]