One Day Course
This course is suitable for Users with a basic knowledge of Excel who want to consolidate and expand on their knowledge to a more advanced level.

 

 

Contents:

Templates

Using data lists

 

Using Excel as a database
Adding, finding and deleting records
Sorting by single and multiple fields
Using a data form

Working with Outline view

Password protecting your workbooks

Toolbars

 

Displaying hidden toolbars
Customising and creating toolbars

 

Register your interest

 

Back to course list

 

 

Importing and Exporting Data

 

Using Past Special
Object linking and embedding
Importing a text file into Excel
Sharing data and other applications

Macros

 

What is a macro?
Recording and running a macro
Editing a macro
Assigning a macro to a toolbar

 

 

 

 

 

 

 

 

 

 

(BCT), bct.gb, birmingham commercial training, birmingham commercial, BCT, BET, birmingham electrical training