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

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

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

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.