Introduction to Excel

Introduction to Excel

Introduction to Excel

AIM

Develop a good working knowledge of Excel to include features such as basic functions and formulae, sorting and filtering data, formatting and printing spreadsheets.

COURSE CONTENT

Introduction and Overview
Programme Overview , Accessing Excel, Using Help, Navigating the Spreadsheet

Parts of the Screen
What’s new in Excel 2010, Using the Ribbon and Quick Access Toolbar, Task Panes, Smart Tags and Option Buttons, Zoom

Creating an Excel Spreadsheet
Best Practices, Entering Information – Labels, Numbers, Formulae, Saving, Opening, Closing and Deleting Workbooks, Document Properties and Management

Editing
Selection Techniques, Drag and Drop, Editing on Spreadsheets or with Formula Bar, Delete / Clear Options, Cutting, Copying, and Pasting Text, Paste Options, Clipboard, Moving and Copying Text between Workbooks, Inserting and Deleting Columns, Rows and Cells, AutoFill

Excel Formulae
Entering and Referencing Formulae, Calculations with Formulae, Editing Formulae, Order of Operations, AutoFill with Formulae

Excel Functions
Basic Functions – Sum, Average, Min, Max, Count, Trace Error Options, Relative and Absolute Cell Addressing , Naming Cells

Formatting the Spreadsheet
Number and Font Formatting, Alignment, Patterns / Borders / Shading, Format Painter

Comments
Inserting Comments, Editing and Deleting Comments, Printing Options, View Options

Page Setup
Orientation, Scaling, Margins, Header / Footer, Gridlines

Printing
Print Preview, Printing Options, Header and Footer

Using Multiple Sheets in a Workbook
Naming Sheets, Moving and Copying Sheets, Inserting and Deleting Sheets, Formulas across Sheets

Excel Charts
Introduction to Excel Chart Facilities, Constructing Charts from Spreadsheet Data, Changing the Chart Type, Chart Options, Formatting Charts

Introduction to Excel Databases
Setting up an Excel Database, Using the Sort Facility, Using AutoFilter Feature, Custom Filters

METHODOLOGY

This is a highly interactive, practical and participative course

TARGET AUDIENCE

Aimed at users who are new to Excel and want to set up their own spreadsheets and manipulate existing ones.

DATES and VENUES

9th September 2016. 9.30am – 5.00pm. Olas, Dublin

9th November 2016. 9.30am – 5.00pm. Olas, Dublin

FEE:

1 day course: €230 ISME Skillnet Members, €315 Non Members

Booking Essential

FOR FURTHER INFORMATION OR TO BOOK CONTACT:

Liz Carroll, Training and Development Manager, 01 6622755, liz@isme.ie

The ISME Skillnet is funded by member companies and the Training Networks Programme, an initiative of Skillnets Ltd. funded from the National Training Fund through the Department of Education and Skills.