Details
Outline
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
Pery Square Business College provide training for companies, individuals and groups. We run scheduled training courses from our premises in Pery Square and also offer onsite training tailored to the needs of any organisation. Pery Square Business College have over 20 years industry experience.
We cater for all ages and skill levels - from Absolute Beginners to Business Professionals and Trainers.
Our Tutors are all highly qualified and class sizes are kept small.
We cater for Business Training, both in-house at our training rooms or on-site at the company's offices.
Specially customised training affords our Business Clients the assurance of compliance within their I.T. and customer service systems.
Our Recruitment Agency links up with many organisations in the Limerick city and Mid-West Region offering a discreet and confidential service for both temporary and permanent placements to the private and public sectors. All candidates are screened by experienced consultants prior to introduction, in order to match the most suitable candidate to our customer requirements.
Related Courses
