Microsoft Excel Intro Training Course Glasgow
Duration: 1-day course and is for individuals new to using Microsoft Excel.
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.
Overview of Excel
Overview of Microsoft Excel
The Screen /The Ribbon / File Tab / Quick Access Toolbar
Excel Options Menu
Screen Tips / Using HELP
Overview of the Spreadsheet / Cell Addresses
Cursor Movement / GoTo / Excel Navigator
Working with Ranges & Named Ranges
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
SUM / AVERAGE / MIN / MAX / COUNT / COUNTIF/ SUMIF
DATE & TIME FUNCTIONS / NOW()
Named Ranges in Formula
Formatting Cells / Worksheet
Text / Numeric / Dates etc / Special
Alignment Options / Fonts / Borders / Patterns
Using Conditional Formatting
Using the Format Painter
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.
To book this course, please contact us on 01236 733898 or email: email@example.com