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.
Upon successful completion of this course, the student will be able to:
Effective as of Spring/Summer 2016
If you have a comment or question about this course, please complete and submit the form below.
Interested in being notified about future offerings of COMP 0269 - MS Excel Workshop 3? If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.