Excel – Intermediate – Fully Subscribed

  • Event: Excel – Intermediate – Fully Subscribed
  • Date: 11/03/2015
  • Time: 9:30 AM - 1:30 PM
  • Venue: The Park Inn by Radisson, Shannon Airport, Shannon, Co Clare
Book Now Add to your calendar

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. (4 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

  1. Bring your laptop with Excel 2007, 2010 or 2013
  2. Clients will receive notes and exercises with worked examples