TMMBA Excel Review Home Page



	Back to home


	Spring 2013: MSIS 542



	Courses: IS 300 IS 310 IS 320 IS 445 IS 460 IS 579 (ERP) IS 579 (Java) IS 579 (Web) MSIS 503 MSIS 531



	Workshops: EMBA Math Review EMBA Excel Review TMMBA Excel Review TMMBA Stats Review

TMMBA Excel Review Home Page

General Info:

Syllabus
Tutorial logistics

Tips & Tricks

Class Notes:

Prior to class:
Overview: Managing files in Windows, Using common Office features
Tutorial 1: Intro to Excel (lecture notes, tutorial files)

Session 1:
Tutorial 2: Formulas and Functions: Tutorial (notes, files), Case (notes, files)
Tutorial 3: Formatting Workbooks: Tutorial (notes, files), Case (notes, files)

Session 2:
Tutorial 4: Charts and Graphics: Tutorial (notes, files), Case (notes, files)
Tutorial 5: Excel Lists: Tutorial (notes, files), Case (notes, files)

Session 3:
Tutorial 6: Multiple Worksheets: Tutorial (notes, files)
Tutorial 8: Excel Applications: Tutorial (notes, files), Case (notes, files)
Tutorial 9: Data Tables/Scenario Management: Tutorial (notes, files), Case (notes, files)

Session 4:
Tutorial 11: Importing Data: Tutorial (notes, files, Sunrise data), Case (notes, files)
Tutorial 12: Excel and VBA: Tutorial (notes, files)

All Tutorials and Cases:

Tutorials: notes, files
Cases: notes, files