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 Level course.

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

Module 3 - Creating Formulas

• Using the AutoSum feature to automatically add values
• Understanding Formulas and their rules
• Creating Basic Formulas
• Copying and Pasting Formulas
• Using and Creating Absolute Formulas to enable a specific value to be used many times, i.e. VAT rate
• Finding Minimum, Maximum and Average values of a list of data
• Using named ranges within a formula
• Using the Function Library
• Inserting and Formatting Dates and Times
• Using Dates within Formulas

Module 4 - Links, Graphs & Basic Conditional Logic

• Linking Workbooks
• Working with Hyperlinks
• Protecting Formulas and Worksheets
• Understanding Conditional Logic, i.e. IF statements
• Working with Multiple Worksheets within a Single Workbook, Renaming, Inserting, Copying Information and Creating Summary Worksheets
• Creating Graphs