Microsoft Excel Training - for current users

Duration:

1-day course for people with some knowledge of using Microsoft Excel.

Objectives:

This course aims to provide people already familiar with Microsoft Excel with a more in-depth knowledge of programme than they currently have. Building on basic Excel skills, it will give users a thorough grounding the features that make Excel the most popular spreadsheet software available. By the end of the training, users will be familiar with all of the key functions including formulas and macros.

Course Topics:

Review of the basics - Shotcuts / Tips
Go to / Navigator
Creating / Using / Customs Lists / Conditional Formatting
Using Mutli Sheets
Dragging and Dropping between sheets and files
Linking Pages
Tab Names
Changing Page Order
Copying Data Between
Group Facility
3D data entry
Using Multipe Spreadsheets
Linking and Paste Linking to other applications
Using named ranges in formula
 Database Facility
Data entry forms / sorting a table / Sort keys / Left to Right
Using AutoFilter / Advanced Filter
Creating SubTotals
Pivot Table Reports
Pivot Table / Drop down menu / Pivot Table Formula
Using Lookup tables
In Linked Files / Named Ranges
Using Graphics & Pictures
Customising the Toolbars
Introducing Hyperlinks
Hyperlink Menu
Introduction of Macros
Macro Recorder
Macro button/ Macro Menu
Questions & Answers

Venues and Delivery:

We offer this course on a regular basis at our training venue in at the Garfield House Hotel - located on the A80 Cumbernauld Road, 10 minutes north of Glasgow, as well as offering in-house or bespoke training for HR departments or companies.

Please visit our schedule page to find out when when our Excel User training is running.

For corporate or business IT Training or for more info how Insight provide some of Scotland's and Europe's leading companies with inhouse IT training, please contact us.

Booking:

To book this course, please complete our online form or contact us 01236 733898 or
email: bookings@uk-insight.org.uk
Microsoft Excel