Computer and Statistics Center

 

MS Excel
MS Excel Intermediate

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

go to top

Course outline

Day 1 -Revisiting some topics of the beginner training

  • Absolute and relative addressing
  • Working with data
  • Creating charts
  • Functions

Day 2 -Application of functions

  • Functions and formulae:
    • calculate percentage, percentage change
    • calculating average, sum,  minimum, maximum
    • conditional formatting
  • Advanced functions and formulae:
    • The PMT financial function
  • 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

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

 

QR code

 

and on Yammer CEU.