Back to All Events

1 DAY EXCEL INTERMEDIATE COURSE

  • Myrick Training Myrick House, Hendomen Montgomery, Powys (map)

Microsoft Excel Intermediate Level Course

1 Day Course


£90 per delegate - Member Company

£95 per delegate - Non Member Company


Attendees should have attended, or have knowledge equivalent to the Introductory Level course

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


Booking Form:

Name *
Name
Earlier Event: November 19
Abrasive Wheels 1/2 DAY COURSE
Later Event: December 9
FIRST AID 2 DAY REFRESHER COURSE