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

Home Our Courses One Day Courses Spreadsheet / Excel TrainingIntermediate Spreadsheets

Intermediate Spreadsheets

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

Title	Date/Time	Full Price	Deposit Price	Extra Info
Intermediate Spreadsheets Nov	22-11-2016 10:00 am	€120.00	€0.00	Intermediate Excel / Spreadsheets 1 Day Course from 10am to 5pm Tuesday 22nd November 2016 Places on courses are limited & not guaranteed until paid in full	Register

Purpose

excel2

Intermediate Spreadsheets (Microsoft Excel)

This course will build on your Basic Spreadsheets / Excel skills and cover more complex formulas, building formulas across worksheets, linking data, charting data and also protecting your sheets and workbooks.

Course Details

Recap on the Basics

Absolute & Relative Cell References
Basic Calculations
Inserting and Deleting Sheets
Inserting/Deleting Workbook Sheets
Page Layout View
Getting Help
Inserting Files

Naming Cell Ranges

Naming Individual Cells
Naming Range of Cells
Deleting and Amending Named Ranges
Using Named Ranges in Formulas & Functions

Linking Sheets and Files

Inserting/Deleting Workbook Sheets
Linking Sheets in the same file
Linking different Excel files
Using Edit, Links
View Different Files on one Screen
Window Split
Freeze Panes

Conditional Functions

IF Statements
Nested IFs
Sum IF
Average IF
Count IF
Nesting IF, WITH, AND, OR

Basic Lookup Functions

Vertical Lookup (Vlookup)
Horizontal Lookup (Hlookup)

Essential List Management

Sorting Data, Multi Column Sort
Filter, Multi Column Filter
Advanced Filter, Adding Subtotals
Group and Outline
Data Form

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