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

Course material on Moodle:

CEU E-Learning Course on Excel

Course outline

Day 1 -Revisiting some topics of the beginner training

• Absolute and relative addressing
• Working with data
• Creating charts
• Functions and formulae:
  • calculate percentage, percentage change
  • calculating average, sum,  minimum, maximum (AVERAGE, SUM, MIN, MAX)
  • conditional formatting

Day 2 -Application of functions

• Advanced functions and formulae:
• Financial calculations
  • The PMT financial function
• Using functions for further calculations
  • VLOOKUP
  • TRUE, FALSE
  • Goal Seek

Day 3 - Working with data

• Pivot-tables
• Creating charts from Pivot-tables
• Working with multiple sheets
• Working with multiple workbooks
• Recording macros
• Buttons with macros

Useful online resources (grouped by category)

Pivot table links:
http://lacher.com/toc/tutpiv.htm

Online Excel resources/tutorials:

https://www.excelcampus.com/
http://www.baycongroup.com/el0.htm
http://www.mrexcel.com/articles.shtml

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

Youtube links:

https://youtu.be/lxq_46nY43g

https://youtu.be/9NUjHBNWe9M

 

NOTE: all links open in new windows.