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 11 - Preventing Error Messages & Date/Time formulas

• Using IS functions - Useful for preventing error messages in complex spreadsheets
• Rounding
• Advanced Data Validation- Identifying Incorrect entries by using Formulas for Data Validation Rules
• Creating Custom Formats
• Date Functions - Creating formulas to display the number of days elapsed between two dates without weekends, holidays etc.
• Time Calculations - Adding up times

Module 12 - Financial Calculations & Advanced Filtering

• Using Match Function - To find whether information in two cells is exactly the same
• Financial Calculations - Functions for calculating Loan Information
• Outlining - Useful for summarising spreadsheets and simply hiding detail
• Advanced Database Filtering - Inserting Subtotal Calculations with Filters display filtered information on a separate sheet