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

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:
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

Excel advanced course page

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.

Join us on Facebook:
Join us