Excel (Intermediate) IIA
Learn about custom lists, lookup functions and more.
By Ben Chapman
Date and time
Tue, 21 Jan 2020 09:00 - 13:00 GMT
Location
Lee House (Sunshine Suite Theatre)
90 Great Bridgewater Street Manchester M1 5JW United KingdomLearn about custom lists, lookup functions and more.
Lee House (Sunshine Suite Theatre)
90 Great Bridgewater Street Manchester M1 5JW United KingdomThis 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