Computer and Statistics Center


MS Excel
MS Excel Intermediate

The course deals with familiarizing the intermediate and advanced users with the more complex features Excel offers.

See also the Excel beginner course page

You can rate this course here:


Course details

Level: Intermediate/Advanced
Instructor: Aniko Balogh
Duration: 3 days
Requirements for pass: minimum attendance - 2 days
When the course is offered: see the list of courses for the current semester and/or the InfoSys

go to top

Course outline

Day 1 -Revisiting some topics of the beginner training

  • Absolute and relative addressing
  • Working with data
  • Creating charts
  • Functions

Day 2 -Application of functions

  • Functions and formulae:
    • calculate percentage, percentage change
    • calculating average, sum,  minimum, maximum
    • conditional formatting
  • Advanced functions and formulae:
    • The PMT financial function
  • Financial calculations
  • Using functions for further calculations
  • Working with multiple sheets
  • Working with multiple workbooks

Day 3 - Working with data

  • Reporting, subtotals
  • Outlines
  • Pivot-tables
  • Creating charts from Pivot-tables

Useful online resources (grouped by category)

Pivot table links:

Online Excel resources/tutorials:


Other resources/tips:

NOTE: all links open in new windows.

Join us on Facebook:
Join us


QR code


and on Yammer CEU.