Computer and Statistics Center


MS Excel
MS Excel for Beginners

The course is structured as an introduction to Excel for the beginner user covering some intermediary topics as well such as: working with tables, creating charts, use of functions and formulae.

You can rate this course here:

Course details

Level: Beginner/Intermediate
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


Course outline
Course material on Moodle: CEU E-Learning Course on Excel

Day 1: The basics

  • Familiarization with the Excel workspace. Workbooks and worksheets - copy paste and move data/sheets (from the internet, within the same book and in different ones)
  • Text editing , column and row fitting. Data, text and dates
    • freeze, hide and split columns/rows (the Window menu)
    • auto complete, auto fill and auto correct
    • printing view, centering, format painter
  • Formatting:
    • cell merging, alignment, wrap, orientation
  • Arranging our data
  • Sorting the data
    • Filtering options

Day 2: Charts

  • Arranging our data

    • Naming cells and adding comments
    • Sorting the data
    • Filtering options
  • Creating charts
    • Data tables
    • Chart formatting (style, title, value axis, appearance, etc.)

Day 3: Formulas

  • Data management. 
  • Basic formulas
  • Relative and absolute references
  • Basic math functions


Useful online resources (grouped by category)

Pivot table links:

Online Excel resources/tutorials:

Excel advanced course page


Other resources/tips:

NOTE: all links open in new windows.

Join us on Facebook:
Join us


QR code


and on Yammer CEU.