Microsoft Excel 2010 Training (Advanced Level)

Other levels, years and dates are available upon request


In this course students will automate some common Excel tasks, Apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.


Key Topics

      Recap on Basics

    • Absolute vs Relative Calculations

    • Basic Formulas

    • Linking Formulas



    • If Statements, Nested If Statements, If And / If Or

    • VLookup and HLookup

    • PMT

    • Upper/Lower/Proper

    • Left/Right/Mid/Concatenate

    • Date/Times

    • Auditing Bar


      Data Analysis

    • Using Tables/Pivot Tables

    • Sorting/Filtering

    • Subtotals

    • Goal Seeker

    • Scenarios


      Customising Excel

    • Excel Options

    • Custom Views

    • Workspaces


      Protection of Data

    • Data Validation

    • Conditional Formatting

    • Track Changes

    • Protecting Cells/Worksheets/Workbooks



    • Creating, Editing & Assigning a Basic Macro

    • Using Input Boxes



  • Price: £225.00
  • Duration: 1 Day
  • Start Time: 9.30am
  • End Time: 4.30pm

Book Your Place

Please choose one of the following date(s)/locations that you would like to attend.

Courses in Dudley

Day 1  
27th June 2018 Book