Spreadsheets Intermediate MS Excel
Details
Outline
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
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.