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 and Intermediate Level courses.

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

Module 5 - Advanced Formulas

• Using the Audit Feature to display cells used within Formulas
• Use of the Transpose Feature to switch the display of data
• Understanding Conditional Logic, i.e. IF statements
• Creating formulas using Basic Conditional Logic
• Creating formulas using Nested IF statements
• Creating formulas using Nested AND & OR statements
• Using the =Countif feature to count data meeting specified criteria
• Using the =Sumif feature to total data meeting specified criteria
• Using the =Averageif feature to find the average of data meeting specified criteria

Module 6 - Using the Database Functions

• Apply Conditional Formatting
• Applying Data Validation to ensure the correct information is entered
• Remove Duplicate Values for line of data
• Understanding the Database Functions
• Using AutoFilter to view a specific set of data
• Inserting Automatic Subtotals
• Converting Text Strings to separate columns
• Creation of Pivot Tables to display data in varying formats
• Creation and use of Vlook-up tables