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 in SITS


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


Related courses at CEU:

Microsoft Excel Intermediate (COMP1000)
Statistics Primer (COMP1029) - statistics course based on Excel

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.