COMP 9909 Microsoft Excel for Business III
Students learn advanced spreadsheets formulas and formatting techniques and will concentrate on various Excel applications including formula auditing, PivotTables, PivotCharts, and macros.
After successful completion of this course, students will be able to:
- Outcome 1: Automate repetitive tasks using the Excel macros options.
- Outcome 2: Perform advanced formatting and formulas in Excel.
- Outcome 3: Import and export text files using Excel.
- Outcome 4: Create PivotTables, PivotCharts and Sparklines in Excel.
- Outcome 5: Explain Excel functions related to accounting and office support.