Description
Time: 9.30am – 1.30pm
Tea and Coffee included.
Venue: The Park Inn by Radisson @ Shannon Airport, Shannon.
Members: € 70.00
Non-Members: € 90.00
12 Delegates per programme. (6 places remaining)
Training provided by Geraldine Fitzpatrick
Geraldine has over 10 years’ experience in delivering training on Microsoft Office Suite. Clients range from corporate, public and private individuals. Successfully trained beginners to advanced; in a classroom based, one to one or web-based training environment.
Excel Intermediate – Intensive Course
Course Duration: 4 hours
Who should attend?
This course is designed for Microsoft Excel users who have good knowledge and understanding of Excel and who wish to extend their knowledge and skills beyond building simple workbooks. This course is suitable for people who use or who will use Excel in their daily role.
Course Aims and Objectives
This course demonstrates how to work more efficiently with workbooks, enhance the appearance of data and worksheets, use the tables and filtering features to manage and analyse data, productivity features and data analysis tools.
Course Outline
Shortcuts
Keyboard shortcuts
AutoSum shortcuts
Paste Special
Fill Handle
Worksheets and Workbooks
Linking Multiple Worksheets and Workbooks
Format/Add data, formula to more than one worksheet simultaneously
Password Protection
Managing Data
Conditional Formatting
Text to Columns
Working with Functions and Formulas
Absolute & Relative Cell References
IF and SUMIF
VLookup and HLookup
Showing Data as a Graphic
Creating and Modifying Charts
Analyzing Data
SubTotals
Pivot Tables
Requirements on day
- Bring your laptop with Excel 2007, 2010 or 2013
- Clients will receive notes and exercises with worked examples
