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:
http://lacher.com/toc/tutpiv.htm

Online Excel resources/tutorials:
http://www.baycongroup.com/el0.htm
http://www.mrexcel.com/articles.shtml
http://math.about.com/od/excel/
http://www.excel-easy.com

Functions:
http://www.bettersolutions.com/excel.htm
http://www.meadinkent.co.uk/excel.htm

Other resources/tips:
http://www.pdfconverter.com/resources/articles/Excel2007tutorial/

NOTE: all links open in new windows.