- International Fees
International fees are typically 3.25 times the domestic tuition. Exact cost will be calculated upon completion of registration.
Course Overview
Following on from COMP 0261 plus COMP 0264, participants are shown advanced topics for using Excel in this intensive, hands-on seminar. Topics include: auditing worksheets, analyzing data with what if analysis including goal seek, solver and scenarios. Use of Consolidation and linking techniques. Advanced topics include: basic macros, collaboration, auditing, conditional formatting, data validation, protecting files, revision tracking and importing and exporting data to MS Word. Successful participants in all three One-Day Excel workshops will acquire a solid understanding of how to use MS Excel for a variety of tasks. COMP 0269 will be offered once a year in the Fall (September) term.
Prerequisite(s)
Credits
0.0
- Not offered this term
- This course is not offered this term. Notify me to receive email notifications when the course opens for registration next term.
Learning Outcomes
Upon successful completion of this course, the student will be able to:
- To enhance productivity and streamline Excel workflow.
- To work with multiple Excel worksheets and workbooks.
- To use formula auditing and lookup functions.
- To share workbooks and protect workbooks.
- To locate errors and use data validation.
- To use spark lines on charting.
- Import and export data to MS Word to automate workbook functionality using forms and macros.
- To use Automated Analysis Tools for What-If Analysis.
Effective as of Spring/Summer 2016
Programs and courses are subject to change without notice.