Excel (Intermediate) IIA

Event Information

Share this event

Date and Time

Location

Location

Lee House (Sunshine Suite Theatre)

90 Great Bridgewater Street

Manchester

M1 5JW

United Kingdom

View Map

Event description
Learn about custom lists, lookup functions and more.

About this Event

This course covers:

• Custom Lists - Use a custom list to sort or fill in a user-defined order. Excel provides day-of-the-week and month-of-the year built-in lists, but you can also create your own custom lists.

• Naming Cells & Ranges for use in navigation and calculations/functions

• Specialised functions beyond basic Sum, Average & Max

• Text & Logical Functions

• Lookup Functions – VLOOKUP, HLOOKUP, MATCH + INDEX

• Sorting & Filtering Data – Working with Tables: Formats, Filters, Sorts

Share with friends

Date and Time

Location

Lee House (Sunshine Suite Theatre)

90 Great Bridgewater Street

Manchester

M1 5JW

United Kingdom

View Map

Save This Event

Event Saved