Computer and Statistics Center

 

MS Excel
MS Excel Advanced

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: Istvan Kocsis
Duration: 4 days
Requirements for pass: minimum attendance - 3 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
  • Using functions
  • Working with data
  • Creating charts

Day 2 -Application of functions

  • 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

Day 4 - Data analysis & optimization

  • Data analysis:
    • Goal seek
    • Data tables (one variable and multi-variable)
  • Optimization:
    • Application of Excel Solver go to top

Day 5 - Exam–Excercise

  • Preparing an Excel sheet solution using the knowledge acquired during the training

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.fgcu.edu/support/office2000/excel/

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