Excel Training – Intermediate

  • When: October 31, 2017 9:30 am - 4:30 pm
  • Where: Manchester Law Society, 64 Bridge Street, Manchester, M3 3BN
  • Summary: Are you looking for success with spreadsheets? Become fantastic with formulae? Join us for a practical Excel training course with RV Group
  • Details:

    In this one day course an expert trainer will get you up to speed on conditional formatting, working effectively with large worksheets, and working efficiently on your databases.

    Numbers on this course are strictly limited to ensure you receive bespoke and personal tuition from our trainer.

    Areas covered include:

    Cell referencing

    • Amending cell references
    • Naming ranges
    • Absolute and relative cell referencing
    • Making a cell address absolute

    Logical Processing

    • Conditional functions – IF statements
    • Nested IF statements
    • Using AND and OR with IF statements
    • The Insert Function commands

     Statistical functions

    • Using Sumif and Countif Functions
    • Inserting/editing comments

     Editing large worksheets

    • Setting panes with freeze panes
    • Splitting worksheets

     Conditional formatting

    • Applying conditional formatting
    • Applying pre-set styles
    • Creating or amending existing styles
      Databases
    • Database rules
    • Entering records
    • Adjusting order of records
    • Searching the database
    • Filtering records
    • Totalling filtered lists
    • Summarising data in a database list

     Linking data

    • Linking cells within spreadsheets
    • Linking cells between spreadsheets
    • Linking documents
    • Changing cell references

     Creating styles

    • Creating a Number Code
    • Removing a Code

     Protecting cells

    • Protecting cells in a sheet or file
    • Protecting the sheet
    • Protecting the workbook
    • Locking individual cells
    • Hiding formulae

    Cost to attend:

    MLS Members £125.00 + VAT (£150.00) Non-members £175.00 + VAT (£210.00)

    Price includes light refreshments and course materials, please note lunch is not provided

    To book your place please email VictoriaRidge@manchesterlawsociety.org.uk or complete and return the Intermediate Excel Training Course booking form

    To book online with a credit or debit card please click here.
    Please note ther
    e is an additional 3% charge to pay by credit card and a 2% charge to pay by debit card.

    By booking a place on this course you are agreeing to our terms and conditions details of which can be found here.

Comments are closed

Sorry, but you cannot leave a comment for this post.

 

Membership

View more information regarding the benefits of membership to Manchester Law Society