Excel Intermediate

This course is part of the library from IMPROVE. No need to worry about which course is right for you….purchase the whole library for a subscription fee AND we will set it up for you, get you started and will be on hand as part of a managed service…all starting from £45 + VAT per month for 20 employees! Prices are based on the size of your organisation with access for all of them to over 50 courses on a range of IT and non-IT topics.

Description

Modules:

  • Linked Pictures
  • Adding Comments to Cells
  • Protection
  • Templates
  • Formatting as Table
  • Format as Table (further options)
  • Conditional Formatting with Numbers (introduction)
  • Conditional Formatting with Text (Introduction)
  • Conditional Formatting with Dates (Introduction)
  • Find a Pattern using Databars Colour Scales and Icon Sets
  • Manage Rules
  • Adding Calculations between Workbooks (Links)
  • Maintaining Calculations between Workbooks (Links)
  • Sort a list (Using Data Sort)
  • Sort a List by Colour
  • Remove Duplicates
  • Splitting Cell Contents (Text to Columns)
  • Sparklines
  • Sparkline Options
  • Page Break Preview