IT Courses - Intermediate Excel

Venue: Broomfield Hall
Hours: 0.20
Cost (£): 100.00

Course Overview

Validated by Derby College, this one-day workshop aims to further enhance the skills of intermediate Microsoft Excel users.

Course Content

Section 1 – Beginners Refresher

  • A recap on beginner topics

Section 2 – Introduction to Charts

  • Charts and Sub Charts
  • Repositioning your Chart
  • Parts of the Chart
  • Formatting your Chart
  • Protection and Security
  • Using Cell Protection

Section 4 – Data Tools

  • Text to Columns
  • Remove Duplicates

Filtering and Sorting

  • Creating a List
  • Filtering a List
  • Sorting Data
  • Advanced Filtering

Section 6 – Cell Referencing and Using Functions

  • Cell Referencing
  • Types of Functions
  • How to insert a Function
  • Using Functions, including: CONCATENATE and &, COUNTIF, COUNTIFS, SUMIF and SUMIFS

Section 7 – Auditing and Error Checking

  • Displaying Formulas and Error Checking
  • Circular References

Section 8 – Consolidating Data

  • Linking between Worksheets
  • Linking between Workbooks
  • Linking to other Applications
  • Sharing Workbooks

Course Dates

Course Title Course Date
IT Courses - Intermediate Excel 18/12/2017 BOOK Now
IT Courses - Intermediate Excel 09/04/2018 BOOK Now
IT Courses - Intermediate Excel 11/06/2018 BOOK Now