Advanced Microsoft Excel Level 3

The Advanced Microsoft Excel Level 3 aims to introduce delegates to the powerful data summary features of Excel, What If? facilities, advanced, conditional and financial functions, automating a spreadsheet and web interactivity.

Who Is The Course Aimed At?

Delegates with a solid foundational knowledge of Excel who wish to explore the advanced features of Excel.

Course Content
  • Financial Functions: PMT, FV
  • Lookup Functions:
    – MATCH
    – INDEX
    – Data Tables
  • Conditional and Summary Functions
    – IF
    – COUNTIF
    – SUMIF
    – SUMPRODUCT
    – Automatic Subtotals
  • Pivot Tables and Pivot Charts
  • Macros, including:
    – Assigning Macros to a Toolbar Button
    – Editing VBA code
    – Creating a Function Procedure
  • Goal Seek
  • Scenarios and Scenario Manager
  • Web Interactivity, including:
    – Lookup tables on the World Wide Web
  • MsQuery
    – Querying External Databases
    – The Web Query
  • Workbook Hiding & Protection Facilities
Entry Requirements

Delegates should have a good all-round knowledge of Excel and have preferably attended both the introductory and intermediate Excel courses.

Level 3 Advanced Microsoft Excel
LevelLevel 3
LocationColchester
Duration1 Day Workshop
CampusColchester Institute
Start DateVarious dates throughout the year. Please contact us for dates
PriceFully-Funded. Contact us for more details

Disclaimer

All Fees and prices shown on the website are for courses starting in the 2018-19 academic year and correct at the time of entering/printing information, however these may be subject to change. The College cannot accept legal or financial liability as a result of any such changes. Fees for courses starting in the 2019-20 academic year will be added to the website from June 2019.

The course information describes programmes offered by Colchester Institute. The College takes all reasonable steps to provide courses as described, but cannot guarantee provision. The information is for guidance and does not form any part of a contract.

The College reserves the right to update and amend information as and when necessary. Colchester Institute will do its best to provide the courses shown, but may have to modify or withdraw a course depending on customer demand and other factors.

(Leisure Courses)