Scarborough UK computer training company, database development, internet trainingSoftware Computer Training Word Excel Access PowerPoint Outlook InternetDevelopment of Access databases and visual basic programsDeveloping Microsoft Access DatabasesWindows NT and Windows 2000 by qualified MCSE EngineerInternet installation and training. Connecting companies to the internet

Excel 2000 - Advanced

Access 2000

  

Templates and styles

·          What are templates?

·          Creating templates

·          Using templates

·          What are styles?

·          Creating and using styles

 

Importing data

·          Why import data?

·          The text wizard

·          Importing from a database

·          Database terminology

·          Using Microsoft query

 

“what if?” Utilities

·          Excel “what if?” Type utilities

·          Goal seek

·          Graphical goal seeking

·          Scenario manager

·          Solver

·          Solver terminology and examples

 

Macros and custom controls

·          What are macros?

·          To record a macro

·          Running macros

·          Creating a button in a worksheet and assigning a macro to it

·          Attaching macros to a button

·          Drawing, editing and formatting buttons

 

Customizing Excel

·          Customizing Excel 2000 - options

·          Customizing toolbars

 

Security and proofing within Excel

·          Auditing and security features within Excel 2000

·          The spell checker

·          What are shared workbooks?

·          Advanced workbook sharing options

·          Data validation

·          Workbook password protection

·          Workbook protection

·          Worksheet protection

·          Cell protection

·          Excel 2000 auditing tools

·          Auditing worksheets

·          Cell comments

 

Data maps

·          What are data maps?

·          The data map control dialog box

·          Placing data on a map

·          Formatting a data map

 

Consolidation

·          What is consolidation?

·          Consolidating rows and columns  

 

Excel 2000

Word 2000

PowerPoint 2000

Windows

Miscellaneous

Office 97