Microsoft Excel 2010 Training (Advanced Level)

Other levels, years and dates are available upon request

Overview

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

 

      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

 

      Macros

    • 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  
15th March 2018 Book  
27th June 2018 Book