Microsoft Excel Intermediate Level Course

icon-it.png

Prerequisites

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

 

Module 3 - Creating Formulas

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

    * 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

    COST: Member Company - £90.00 per person

    Non Member Company - £95.00 per person


 

DURATION: One day

VENUE: Myrick House, Hendomen, Montgomery, Powys. SY15 6EZ

PLEASE NOTE THAT TRAINING COURSES CAN BE ARRANGED TO SUIT COMPANY OR INDIVIDUAL NEEDS AND CAN BE ARRANGED IN COMPANY IF REQUIRED

If you require further information please contact us on 01686 668670 email mts@myrick.co.uk or complete the relevant booking form below.