Develop a good working knowledge of Excel to include features such as basic functions and formulae, sorting and filtering data, formatting and printing spreadsheets.
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
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
Entering and Referencing Formulae, Calculations with Formulae, Editing Formulae, Order of Operations, AutoFill with Formulae
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
Inserting Comments, Editing and Deleting Comments, Printing Options, View Options
Orientation, Scaling, Margins, Header / Footer, Gridlines
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
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
This is a highly interactive, practical and participative course
Aimed at users who are new to Excel and want to set up their own spreadsheets and manipulate existing ones.
DATES and VENUES
To be confirmed.
1 day course: €230 ISME Skillnet Members, €315 Non Members
FOR FURTHER INFORMATION OR TO BOOK CONTACT:
Sheila Flannery, Training and Development Manager, 01 6622 755, firstname.lastname@example.org.
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.