Excel Intermediate Online

Duration: 3 days – 2 hours and 15 minutes each morning

Course Description:

This course has been developed for people wanting to utilise Excel to perform calculations using a variety of common worksheet functions, filter, sort and summarise database lists, format and modify charts, and conditionally format cells.

Performance Based Objectives  

  • Understand and use a range of common worksheet functions
  • Understand and utilise Absolute Referencing
  • Organise a database list by advanced filtering and subtotalling
  • Utilise Conditional Formatting to change cell appearance
  • Create and modify charts to create static dashboards

Course prerequisites

Participants will need to have attended or be familiar with the topics covered in the Microsoft Excel Introduction course.

Course Outline

Functions and Formulas

  • Absolute cell referencing
  • Function syntax
  • Common statistical functions
  • The COUNTIF function
  • The SUMIF function
  • The IF Function

Working with date and time

  • Date functions – TODAY and NOW
  • EDATE and NETWORKDAYS
  • Work with time values
  • AutoFill date sequences

Conditional formatting

  • Format cell value
  • Format using a formula
  • Editing conditional formatting rules
  • Adding sparklines

Advanced sorting and filtering

  • Sorting custom lists
  • Sorting by colour
  • Complex filtering criteria
  • Searching for criteria
  • SUBTOTAL function
  • Subtotalling a list
  • Creating a simple PivotTable

Advanced charts

  • Creating a chart sheet
  • Switch columns/rows
  • Create a dual axis chart
  • Changing a series chart type
  • Moving a chart
  • 3D charts
  • 3D chart rotation
  • Create a simple, static dashboard

 

 

Book your place today: ymorselli@cita.ie – 086 0144853

For training dates and details please see our Course Schedule