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.
Below is one offering of this course for the Fall 2020 term.
Dec 05 1 Day
Upon successful completion of this course, the student will be able to:
Effective as of Spring/Summer 2016
The BCIT bookstore carries textbooks, general reference books, software, and stationery. Please visit bcit.ca/bookstore for more information.
Books for Fall 2020 offerings of this course are available in the following BCIT online bookstores. Please choose the bookstore appropriate for the offering you are considering.
If you are taking this course at the BCIT Downtown Campus (DTC), please purchase books for this course at the BCIT Downtown Campus Bookstore.
|No Book/Course Material Required For This Section|
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.