Excel 2010 - Advanced

Print versionPrint version
Network: 
ITAG Skillnet
Location of Course PFH,Galway Technology Park, Galway City
Trainer Abaltacht
Further Enquiries Dee Timoney
Email: dtimoney@itag.ie
Entry Requirements Must have good working knowledge of Excel prior to attending the Advanced course.
Enrolment and Start Dates Comment 16th May, 2013 - Courses are run on a regular basis please contact us to get further dates.
Subjects Taught Concepts and Functionality

Working with Excel Workbooks
• The Excel Screen
• View Options
• Splitting Worksheets
• Hiding Worksheets, Columns and Rows
• Save Options

Functions in Excel
• Sumif, Countif, Conditional IF statement, worksheet subtotal, vlookup / hlookup

Printing
• Print Options
• Page Setup

Advanced Formatting
• Paste special
• Conditional formatting

Sorting and filtering data
Subtotals
Pivot Tables
Data Validation
Advanced Chart Editing
Auditing and error management
Working with multiple sheets and workbooks
Scenario Manager
Macros

Duration 1 day, from 9.30am - 4.30pm.
Comment Eligible jobseekers can attend free of charge.
Number of Places 10
Course Fee €45
Available to Job Seekers: 
Yes
Certified: 
No