Pery Square Business College :: Business Training and Computer Courses Limerick :: ECDL :: QQI :: ICS.

Home Our Courses One Day Courses Spreadsheet / Excel TrainingAdvanced Spreadsheets

Advanced Spreadsheets

Swipe to left to see rest of Info >>>>

Title	Date/Time	Full Price	Deposit Price	Extra Info
Advanced Spreadsheets April 2017	27-04-2017 10:00 am	€180.00	€0.00	Advanced Spreadsheets / Excel 1 Day Course 10am to 5pm Thursday 27th April 2017 Places on courses are limited & not guaranteed until paid in full	Register
Advanced Spreadsheets May 2017	31-05-2017 10:00 am	€180.00	€0.00	Advanced Spreadsheets 1 Day Course 10am to 5pm Wednesday 31st May 2017 Places on course are limited & not guaranteed until paid in full	Register
Advanced Spreadsheets June 2017	27-06-2017 10:00 am	€180.00	€0.00	Advanced Spreadsheets 1 Day Course 10am to 5pm Tuesday 27th June 2017 Places on course are limited & not guaranteed until paid in full	Register
Advanced Spreadsheets July 2017	14-07-2017 10:00 am	€180.00	€0.00	Advanced Spreadsheets 1 Day Course 10am to 5pm Friday 14th July 2017 Places on course are limited & not guaranteed until paid in full	Register

Purpose

excel3

Advanced Spreadsheets (Microsoft Excel)

This course is aimed at Experienced Spreadsheet / Excel Users who need to perform more complex functions, Lists analysis, V & Hlookup, Pivot Tables and Macros. Can be used in preparation for MOS Excel Test or Advanced ECDL Excel Test.

Course Details

Recap on Functions

IF Statements
Nested IFs
Combining IF, And, Or, Not
SumIF
Vlookup
Hlookup

Lookup & Information Functions

Match Function, Index Function
ISTEXT, ISVALUE, ISDATE, ISNULL
IFError, OffSet
Advanced List Management
Advanced Filter
Database Functions

Summarising Data with Pivot Tables

Inserting Calculated Fields
Manipulating Fields
Changing Value Field Settings
Using Report Filter
Grouping Data containing Dates & Numbers
Formatting Pivot Tables, Refreshing the Data
Showing and Hiding the Grand Totals
Changing the Scope of the Data Source
Summarising Options, Pivot Table Options
Pivot Chart

General Analysis Tools

Scenarios
Custom Views
Goal Seek
Solver
Data Tables
One Input
Two Input

Protecting and Sharing

Sharing a File
Tracking Changes
Accepting or Rejecting Changes
Applying Data Validation Rules
Protecting Cells, Sheets, Files
Password Protecting a File
Password Protecting a Cell Range

Macros and Templates

What is a Macro?
Saving a Macro
Absolute and Relative Records
Running Macros
Creating Custom Templates
Opening and Editing Templates
Setting Template Properties

Popular Courses.

training and Development

Computer Courses

client 4

MS Excel

care skills

See Our Calendar.

Contact Details.

Pery Square Business College & Staff Agency.
Limerick, Ireland.
Telephone: +353 (0)61 3270125
Email: This email address is being protected from spambots. You need JavaScript enabled to view it.
Call or Email to discuss the right course for you.

European Computer Driving Licence

logoQQI

Irish Computer Society

mos