Course Description

Excel / Spreadsheets Advanced

Pery Square Business College

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.

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

89

241

Limerick City

Limerick, UK

View Phone Number

Book Course

Enquire for Info

View College Details Reviews

Add to Favourite

College Name	Pery Square Business College
Course Category	Computers & IT (Information Technology), Microsoft Excel
Course Type	One-To-One Coaching
Course Qualification	Certificate of Attendance
Course Location	Limerick, UK
Delivery mode	Classroom based
Course Start Date	14th June 2021
Course End Date	21st June 2021
Course Fee	€180
Course Duration	1 day - 10am to 5pm or 1 hourly sessions
Course Times	This course is currently run online through Zoom with Tutor 1 Day Course from 10am to 5pm (or 2 half days or 1 hourly sessions) Individual and Small group size only
Title of Awarding	Microsoft 2016 Advanced Spreadsheets
Entry Requirements	Must have our course on intermediate level of Spreadsheets completed or proven relevant work experience and knowledge. This course only covers advanced features and will not recap on any basic features.
Career Path	For those who need proficient excel skills for their work or want to have an edge over others. Learn about the advanced features of Excel for analysing data, protecting & sharing spreadsheets and using pivot tables. Useful for jobs in Human Resources, Accounting, Finance or Research and Development.