Microsoft Excel Training - for new users

Duration:

1-day course for people new to Excel.

Objectives:

The objective of this session is to provide the new user with an appreciation of the role of the spreadsheet in a business environment and to familiarise them with the basic features and facilities of the Microsoft Excel.  It will also prove useful for the person who is self taught, for those coming from another spreadsheet programme or for those who quickly need to evaluate the software.

Course Topics:

Overview of Excel
The Screen - Menus / Dialog Boxes / Toolbars / Status Bar.
Cursor Movement - Keyboard / Mouse / Go To Navigator Selecting Cells / Rows / Columns / Sheets. Ranges & Multiple Ranges.
Changing Row Height / Column Width / Autowidth Entering / Deleting / Editing Data / Using Undo.
Creating and Using Custom Lists Text Alignment
Formula & Functions
=SUM / =COUNT / =AVERAGE / =MIN / =MAX / =IF Percentages and Autosum Date & Time Facility Cut / Copy / Paste Using Excel Shortcuts Relative /Absolute Cell References Using Goal Seek
Formatting the Worksheet
Numbers / Fonts & Sizes / Borders & Shading / Format Painter / AutoFormat.
Conditional Formatting
File Handling
Using Save / Save As - Directories / Drives / File Type.
Print Preview / Changing the Set Up
Margins / Headers & Footers / Print Areas / Page Break Preview
The HELP facility
Using named ranges / GoTo & in Formula
Inserting Comments
Working with Charts
The Chart Wizard / Series RangesSetting the Series / Modifying / Changing the Type / Formatting/ Auto Formatting
Showing the Data Table / Chart Toolbar
Overview of Working with Multiple Worksheets.
Questions and Answers.

Venues and Delivery:

We offer this course on a regular basis at our training venue at the Travelodge Conference Room, Auchenkilns, Cumbernauld. 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 Intro 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 on 01236 733898 or
email: bookings@uk-insight.org.uk
Microsoft Excel