Microsoft Excel Introduction Courses
Introduction Courses For Microsoft Excel
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).
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