Jump directly to main content Jump directly to menu

Excel Intermediate

Customised programme

Key Information

  • Course Level

    Level 2

  • Delivery

    Part-Time

  • Duration

    1 Day (9.00am – 4.00pm)


Apply or Enquire

The course covers the following –

  • Introduction
  • Work Related Spreadsheets
  • Working Example
  • Quick Access Toolbar
  • Formula Auditing
  • Named Ranges
  • Data Validation (using Named Ranges
  • Absolute Values (‘Locking’ the cell reference)
  • Data Transfer between Worksheets and Spreadsheets
  • Conditional Formatting
  • IF Statements and Formulas
  • VLOOKUPs
  • Inserting Charts
  • Pivot Tables
  • Paste Options / Clipboard
  • Date and Time Functions
  • Placing Existing Data into a ‘Table’
  • Themes
  • Adapting the view of the Spreadsheet
  • Inserting ‘Screen-Shots’
  • SmartArt Graphics
  • What-If Analysis
  • Version History
  • Show Changes
  • Work Related Spreadsheets

There is also an opportunity during the last section of the workshop to work on Excel with specific work related issues.

N/A

N/A

Financial Support

Depending on your situation, you may be able to access a range of financial support available.

Course Fees

UK

We do not currently have fee information available for this course. Please contact us for further information.

 

Apply or enquire about this course-

Please use the following links to make an enquiry about this course.

Make an enquiry Call 01724 294040