Microsoft Excel – Intro Training Course Glasgow Edinburgh Scotland

Microsoft Excel Intro Training Course Glasgow

Microsoft Excel Intro Training Course

Duration: 1-day course and is for individuals new to using Microsoft Excel.

Objectives:

The objective of this session is to provide the new user with an appreciation of the role of the Microsoft Excel spreadsheet in a business environment and to familiarize them with the basic features and facilities of the package. Gain a good understanding of the basic features and the facilities to enable the delegate to use the spreadsheet package.

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

Overview of Microsoft Excel
The Screen /The Ribbon /  File Tab / Quick Access Toolbar
Excel Options Menu
Screen Tips / Using HELP
Excel Shortcuts
Overview of the Spreadsheet / Cell Addresses
Cursor Movement / GoTo / Excel Navigator
Selecting Methods
Working with Ranges & Named Ranges
Name Manager
Data Types / Data Entry / Editing
Text / Numbers / Custom Lists / Fill Ranges
Cut / Copy / Paste / Paste Special Functions /Quick Functions etc
Relative / Absolute Cell Addresses
Copying between Sheets / Files
Creating / Importing / Using Customs Lists

= Functions
SUM / AVERAGE / MIN / MAX / COUNT / COUNTIF/ SUMIF
DATE & TIME FUNCTIONS / NOW()
IF STATEMENTS
Named Ranges in Formula

Formatting Cells / Worksheet
Text / Numeric / Dates etc / Special
Alignment Options / Fonts / Borders / Patterns
Using Conditional Formatting
Using the Format Painter

File Handling
Using Save / Save As – Directories / Drives / File Type.

Adding Password Protection
Protecting the Sheet / Workbook
Working with Comments

Print and Print Options
Changing the Set Up / Print Area
Headers and Footers / Page Break Preview / Orientation Print Preview /
Freezing Panes/ New Window

Working with Charts
Creating a Chart / Chart Types
Change Design / Layout / Colours / Format

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 IT training course schedule page to find out 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 in-house IT training, for further information Contact Us and we will get back to you very quickly.

Booking:

To book this course, please contact us on 01236 733898 or email: bookings@uk-insight.org.uk

Print Friendly