Skip to main content

Microsoft Excel Intermediate

Microsoft Excel Intermediate

  • A hands-on, instructor-led Microsoft Excel training course allowing people with an existing knowledge of Excel fundamentals to improve their skills and create better spreadsheets. Delegates will learn how to create advanced tables and spreadsheets, alongside gaining the capability to analyse, share and present this data with Excel. This is achieved through open learning, discussion and practice with an expert trainer in a professional classroom environment.

     

    Pricing
    • 1 Day of group training is £799 + VAT per day
    • 2 Days of group training is £699 + VAT per day
    • 3 Days of group training is £649 + VAT per day
    • Solo training is available for £350 + VAT per day

Whats covered in this course

  • Working with Multiple Worksheets

    • Using multiple worksheets

    • Linking worksheets

    • Managing workbooks

  • Working with Large Spreadsheets

    • View options

    • Hiding/displaying data

    • Printing large worksheets

    • Outline a Worksheet

  • List Management

    • Sorting individual and multiple columns

    • Create a custom sort

    • Filtering

    • Advanced filtering

  • Advanced Formatting

    • Dates

    • Styles

    • Conditional Formatting

    • Custom Formatting

  • Advanced Functions

    • Logical Functions (E.g. IF)

    • Lookup Functions

  • Documenting and Auditing

    • Comments and Text Boxes

    • Formula Auditing Features

  • Advanced Charts

    • Combination Charts

    • Adding and removing data

    • Moving a chart

    • Other chart options

What Etopia clients are saying about our training courses

  • "I have just attended the day myself and have found it very beneficial; Callum took a gentle steady pace with us all which we really appreciated. Overall it has been a great day.
    ★★★★★".

    Kim Donaldson, St Columba's Hospice, Excel Training.

  • "The course was very thorough and I have a much better understanding of Excel
    ★★★★★".

    Kevin Brown, IFT, Excel.

  • "Irene was so knowledgeable and I really feel I will use some of what I have learned. She was an excellent trainer
    ★★★★★".

    Angela Mayne, Crown Office, Excel Advanced.

  • "I have already set up a macro that I use daily and I am looking forward to the month end so that I can use a pivot table!
    ★★★★★".

    Angela Houliston , Edinburgh Assay Office, MS Excel Advanced.

  • "Beyond my expectations. explained patiently and reinforced the concepts - great trainer.
    ★★★★★".

    Neil Stewart, Fairfield Technologies, MS Excel.

  • "Just thought I would drop you a note to say how much I enjoyed yesterday’s course. Irene was so knowledgeable and I really feel I will use some of what I have learned. She was an excellent trainer.
    ★★★★★".

    Angela Mayne, Crown Office, Excel Advanced.

  • Live Online Training

    A fully interactive, instructor-led training course you can attend from the comfort of your own home or office. Enjoy an interactive learning session online with our most convenient and accessible method yet.

  • Classroom Training

    We regularly host training courses in our city-centre venue. Join our experienced trainers in person for a fully interactive training session, and enjoy access to our comfortable breakout room and on-site café.

  • Training at Your Workplace

    Looking for private training in central Scotland? Our qualified trainers can make the trip to your office, providing professional on-site training in an environment that's comfortable and familiar to you.

Get in touch

Send an enquiry or call us on 0141 730 0025

X
Thank you. Your message has been sent and a member of our team will be in touch shortly.