Advanced microsoft Excel courses in Dublin - pivot tables - macros - cell protection - IF Functions - Tipperary - Cork - Kilkenny, Limerick, Waterford

Inspire IT deliver IT Training in the Microsoft Suite throughout Ireland. We also deliver training in Web Design

Office 2003
- Excel
- Word
- PowerPoint
  - Introduction
  - Advanced
- Access
  - Introduction
  - Advanced
- Visio
  - Visio Course
- Publisher
  - Publisher Course
- Outlook
  - Outlook Course
Office 2007
- Excel
- Word
- PowerPoint
  - Introduction
  - Advanced
- Access
  - Introduction
  - Advanced
- Visio
  - Visio
- Publisher
  - Publisher
- Outlook
  - Outlook
Web Design
Special Offers
One to One
Consultancy
Testimonials
Popular Courses
ECDL
ECDL Advanced
Videos
Blog
Profile
Careers

Advanced Excel

Course Objectives:

Our Microsoft Advanced Excel training course will improve efficiency and productivity in the work place with the use of advanced features such as Pivot Tables, Short Cuts, Filters, Macro's and scenarios. This course is aimed at the everyday user. We will look at functions such as IF, Vlookup and Nested IF's.

Inspire IT has delivered training in Dublin, Waterford, Kilkenny, Cork, Limerick, Sligo, Galway, Donegal, Tipperary, Athlone, Dundalk, Kerry and internationally.

Prior to to course we will discuss your requirements and develop the course content to suit your needs.

All participants receive handouts and course files of the course content if they want to review the information at a later date.
6 months FREE E-mail support after course.
Inspire IT are flexible with start and finish times for courses. We have delivered training courses that started at 7am and finished at 2pm due to clients preference.
We deliver one to one training

For more information please E-mail our Senior Trainer Alan Joyce at info@inspiresit.ie or contact him at 085 1055651 or Skype inspireitweb

Navigation & Data input

Quick Navigation of spreadsheets
Accurate selection of large amounts of data
Shortcut Keys
Named Ranges, modifying & deleting
Custom Lists, creation & deleting
Using AutoFill to create numbered sequences

Functions: IF & VLookups

Absolute Addressing
Using the IF Function – Using the Paste Function
Using the Vlookup
Count IF and Count A
Nested IF
Shortcut to view all formulaes
Auditing Toolbar

Data & Form

Data & Form
Using the Form to search for records
Adding records using the Form

Advanced Filter

Using the AutoFilter
Using the Advanced Filter
Filtering Results to another area of spreadsheet

Auditing Toolbar

Using the Auditing Toolbar
Tracing Precedents
Tracing Errors in Formulaes

Protection

Protecting Worksheets
Protecting Workbooks
Protecting parts of a spreadsheet
Placing a password on the file

Goal Seek & Consolidation

Using the Goal Seek in Excel
Consolidating Data in a spreadsheet

Pivot Tables

Creating Pivot Tables
Modifying Pivot Tables
Formatting data within Pivot Tables
Refreshing data in a Pivot Table
Creating a Pivot Chart
Modifying a Pivot Chart
Grouping Pivot Table

Scenarios

Creating Scenarios
Shortcuts to viewing scenarios

Views

Hiding Rows
Create Views
Shortcut to view “Different Views”

Toolbars

Creating Personal Toolbar
Deleting Toolbar

Import

Importing Data into Excel
Importing a Text file into Excel

Macros

Recording a Macro
Running a Macro
Assigning a Macro to a button in Toolbar
Assigning a Macro to a push button on spreadsheet
Editing & Deleting a Macro

Back to courses

Contact Us: 085 1055651 E-mail: info@inspiresit.ie Skype: inspireitweb