Excel Training – Advanced

  • When: November 28, 2017 9:30 am - 4:30 pm
  • Where: Manchester Law Society, 64 Bridge Street, Manchester, M3 3BN
  • Summary: At this advanced Excel one day training course our expert trainer from the RV Group will show you how to use H and V Lookups in the creation of catalogues and how to create, rearrange and format pivot tables and much more!
  • Details:

    Do you want to build on your existing knowledge of Excel? Following our very successful and popular intermediate Excel training courses we are now delighted to offer an advanced course.

    At this advanced Excel one day training course our expert trainer from the RV Group will show you how to use H and V Lookups in the creation of catalogues and how to create, rearrange and format pivot tables and much more!

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

     Areas covered include:

    VLookup and HLookup

    • Creating catalogues
    • V vs H Lookup
    • Restrictions of H and V Lookups

     Advanced list management

    • Extracting Records vs Filter
    • Subtotals

     Database functions

    • DSum, DAverage, DMax, DProduct

     Outlining documents

    • Creating an automatic Outline
    • Grouping Rows or Columns
    • Creating Subtotals

     Creating a view

    • Creating a View
    • Storing the View

     Templates

    • Using templates
    • Built-in templates

     Consolidation of data

    • Consolidating the Data by Position
    • 3D Functions/Formulae

    Data validation

    • Setting Entry Rules
    • Creating Lists
    • Displaying errors

     Pivot tables

    • Creating a pivot table
    • Rearranging pivot tables
    • Formatting pivot tables
    • Pivot charts

     Analytical options

    • Goal Seek and Solver
    • Scenarios

     Protecting & sharing files

    • Sharing a file
    • Tracking changes
    • Accepting or rejecting changes
    • Inserting comments

    Macros

    • Recording and running Macros
    • Assigning Macros to Quick Access Toolbar
    • Creating Macro buttons

    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 Advanced 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