Microsoft Excel Introduction Courses
Introduction Courses For Microsoft Excel
Our Excel Introduction course is perfect for both beginners and those who are self-taught in Microsoft Excel and looking to learn skills that will transform how they work.
Our experienced trainers will guide you through hands-on exercises and real-world examples, so you’ll be able to apply what you’ve learned immediately in the workplace.
Our fee for a standard onsite Excel course Ā£545 + VAT
Includes up to 4 people onsite. Additional attendees: Ā£35 + VAT per person.
- Instructor-led Excel training (non-tailored)
- Delivered onsite at your location (up to 4 people)
- Printed reference materials for each attendee
- Trainer travel is included
Perfect for: Small teams who want a focused, hands-on Excel course on the key skills used within the workplace.
This equates to about Ā£75.00 plus vat per person (assuming 10 people attend), with each person receiving a supporting reference manual and course attendance certificate.
Keys Training also delivered regular scheduled Excel Introduction courses at our premises.
1 Day Course | 1 delegate Ā£195.00 plus VAT
*Book 2 or more delegates and receive significant discounts. Click here for information
Scheduled public courses are held at Preston, Liverpool, Manchester & London.
Meet Aedan, a member of the Marketing Teamā¦
Enquire About Training
Introduction
This one-day instructor led Excel Introduction course is designed to give a thorough introduction to the basic skills needed to use Excel effectively. By the end of the course delegates will be able to create, modify and format Excel spreadsheets including designing basic formulas and charts.
Course Objectives
- Understand the terminology used in Excel
- Open, close, save and print Excel worksheets
- Enter, edit and format data
- Use formulas and functions to calculate in Excel
- Create and format a simple chart
Pre-requisites
We recommend that all those who attend are able to:
- Use the mouse to select and open menus and icons
- Identify and use the Shift, Ctrl, TAB and Home keys on the keyboard
Course Content
Excel Basics
- Exploring the Excel window
- Spreadsheet terminology
- Opening and Closing workbooks
- Navigating around a worksheet
- Keyboard Shortcuts and Menu Items
Entering and Editing Data
- Creating a new Excel workbook
- Entering and editing labels and values
- Selecting cells and data ranges
- Moving and copying data
- Linking worksheets in a workbook
- Saving and updating a workbook
Formulas and Functions
- Creating new formulas
- Using SUM function
- Using AVERAGE, MIN, MAX and COUNT
- Copying formulas and functions
- Understanding Absolute and Relative references
- Editing formulas and functions
Printing
- Preparing to print
- Page set up options
Formatting and Manipulating Worksheets
- Formatting text
- Formatting rows and columns
- Formatting numbers
- Inserting rows and columns
- Deleting rows and columns
- Freezing panes
- Splitting the screen
Charts
- Creating a simple chart using Chart Wizard
- Formatting a chart