Back to all courses

Microsoft Excel Intermediate

The aim of the course is to allow you to explore further formula options and display your data in charts for quick visual analysis. You will also learn how to work and manage lists of data.

Save to my Shortlist Save to shortlist Share Share

Certification:

College Certificated

Duration:

  • One day trainer-led or virtual
Enquire now

Who is this course for?

This course would benefit all levels of staff within an organisation.

What qualifications will I gain?

Fife College Certificate of Attendance

What will I learn on the course?

Creating charts:
  • Explore chart types
  • Change the chart layout
  • Move and resize charts
  • Add chart elements
  • Modify chart data
  • Add trendlines
  • Create chart templates
  • Create sparklines

Print and distribute:

  • Set print area and page breaks
  • Headers and footers
  • Margins and orientation

Intermediate formulas

  • Review of absolute and relative cell references
  • Create and use range names
  • Work with the insert function tool
  • Try a variety of functions from popular categories (Date, Logical, LookUp)

Manage data

  • Quick analysis
  • Outline and subtotals
  • Data validation
  • Flash fill
  • Import and export data

Tables

  • Create a table
  • Sort data
  • Filter data
  • Add rows and columns
  • Slicers
  • Remove duplicates
  • Overview of creating pivot tables

Intermediate formatting

  • Conditional formatting
  • Apply styles
  • Create and modify styles
  • Apply a theme

Collaboration

  • Cell comments
  • Version history
  • Protect worksheets
  • Protect workbook structure
  • File protection

Application Information

What further course options are available?

  • Advanced Excel
  • Summarising with lists
  • Formulas and functions
  • Analysing and presenting data
  • Charts and dashboards

How will this help my career?

This course enhances your proficiency within Microsoft Excel which they can take back into your workplace activities to improve productivity.