Microsoft Excel Level 4

The Microsoft Excel Level 4 course is designed for people who want to take their skills on to the next level having previously completed a Level 3 course.  It will progress on the skills learnt in order to set up a Dashboard for interacting with the data in a user friendly manor.

Course Content

Programme Objectives

  • Learning about using Excel as a Dashboards
  • Preparing data to use in a Dashboard
  • How to design the Dashboard report
  • Using Excel to create forms

Programme Content

  • Getting your data ready
  • Using Data Validation to stop input errors
  • Formatting your data for Reporting
  • Designing the Dashboard
  • Combining VLOOKUP to INDEX/MATCH
  • Revision of Formatting/Analysing a PivotTable report
  • Creating Multiple Pivot Table on one Dashboard
  • Applying Conditional Formatting
  • Adding Slicers to the data
  • Controlling Data with Slicers
  • Timelines
  • Adding Charts and Pivot Charts
  • Choosing the right Chart for your data
  • Formatting a Dashboard
  • Visualising mapped data in 3D Maps (aka Power Map)
  • Using Macros to add buttons to a Dashboard
  • Creating and Using interactive Forms
Entry Requirements

Pre-requisites:  Participants should have attended the Excel Level 3 course.

Microsoft Excel Level 4
LevelLevel 4
LocationColchester
Duration1 Day Workshop
CampusColchester Institute
Start DateVarious dates throughout the year. Please contact us for dates
Price£195. This includes refreshments, lunch, and parking

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)