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.
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.
Closed tailored courses are available on your site for £595.00 plus vat (up to 8 attendees).
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