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.

Objective:

The objective of this session is to provide the new user with a comprehensive overview of the capabilities of Excel as well as presenting the knowledge required to begin using the program effectively.    As the session is primarily hands on it will be restricted to one user per computer system and is suitable for both the novice and the person who has dabbled with the software.

Topics:

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 / Named Ranges in Formula
SUM / AVERAGE / MIN / MAX / COUNT / COUNTIF/ SUMIF
DATE & TIME FUNCTIONS / NOW()
IF STATEMENTS
3D Data Entry & 3D 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

Data Tables
Sorting and Filtering

QUESTIONS AND ANSWERS

 

Special Features and Facilities:

The course is devoted to a practical use of the software and is therefore primarily hands-on. An absolute maximum of 1 student per machine will be maintained.   The session is fully documented, and each person attending will have unlimited access to our after training back up service

This specification can be tailored for those requiring onsite training

Venues and Delivery:

We offer this course on a regular basis at our training venue at the Crowwood House Hotel, Chryston, Glasgow G69 9BS 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, PDF & Email