Advanced Excel Spreadsheets Course ( 2 Courses ) See Dates/Register  

  • Advanced Spreadsheets

    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.
  • 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
  • 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.
  • You must have completed the Introduction & Intermediate Spreadsheets / Excel Courses or have very good working Knowledge of Spreadsheets / Excel.

Advanced Excel 1 Day Dec

Advanced Excel Spreadsheets 1 Day Course
Times: 10am to 5pm
Monday 16th December 2019
Small group size & limited places
Course Date 16-12-2019 10:00 am
Individual Price €180.00
€180.00 7

Advanced Excel 1 Day Jan 2020

Advanced Excel Spreadsheets 1 Day Course
Times: 10am to 5pm
Tuesday 28th January 2020
Small group size & limited places
Course Date 28-01-2020 10:00 am
Individual Price €180.00
€180.00 8
Pery Square Business College & Staff Agency.
4 Pery Square, Limerick, Ireland.
Telephone: +353 (0)61 310155
Email:
Call or Email to discuss the right course for you.
European Computer Driving Licence, ECDL
Irish Computer Society
Microsoft Office Specialist Certification
Quality and Qualifications Ireland (QQI)