PS Training Ltd

Printer-friendly document

Course Booking and enquiries: 01352 810443
enquiries@pstraining.co.uk

Prerequisites:
Attendees should have attended, or have knowledge equivalent to the Introductory, Intermediate & Advanced Level courses.

Duration:
This course can be delivered as a full day course or as individual half day modules

Module 9 - Manipulating Text & Counting Functions

• Tips and Tricks
• Shortcuts for working on spreadsheets
• Using String Functions
• Determining whether a Cell is Text or a Number, Comparing Cell Contents, Removing Excess Spaces and Nonprinting Characters, Replacing Text with other Text, Extracting Words from a Text String
• Introduction to Arrays to give access to more complex formulas, and to create protected formulas
• Advanced Counting Functions
• Counting Cells with Multiple Criteria

Module 10 - Advanced Conditional Logic & Lookups

• Advanced Conditional Logic - Creating formulas using Nested IF statements
• Advanced If statements, using more than one argument
• Creating formulas using AND & OR statements
• Advanced If statements, where multiple conditions are required for the argument to be true.
• Creation and Use of Advanced lookup Tables
• VLookup tables using ISNA and Lookup formulas
• Using an Exact Match Lookup
• Combining Lookup with other functions