MCT142 - MS Excel Level II

Outline info
Last revision date 2018-09-24 01:06:42.88
Last review date 2018-11-07 14:37:42.604

Subject Title
MS Excel Level II

Subject Description
This second level course covers some of the more advanced features of Excel. Topics include: working with illustrations, customized formatting, working with tables and databases, and collaborating with others.

Credit Status
Participating students who attend at least 70% of scheduled classes receive a document confirming he/she attended this course.

Learning Outcomes
Upon successful completion of this subject the student will be able to:

1. Insert, modify and format clip art images, pictures and shapes.
2. Customize charts.
3. Audit worksheets.
4. Work with database functions in Excel.
5. Consolidate and summarize data.
6. Create groups and subtotals from the data in the worksheet.
7. Work with shared workbooks including adding protection or tracking changes.
8. Change workbook properties and use the Document Inspector appropriately.
9. Set up a what-if scenario.
10. Use the Goal Seeking and Solver tools.
11. Work with a single or two variable data table.
12. Create, modify and format PivotTable or PivotCharts.

Cheating and Plagiarism
Each student should be aware of the College's policy regarding Cheating and Plagiarism. Seneca's Academic Policy will be strictly enforced.

To support academic honesty at Seneca College, all work submitted by students may be reviewed for authenticity and originality, utilizing software tools and third party services. Please visit the Academic Honesty site on for further information regarding cheating and plagiarism policies and procedures.

All students and employees have the right to study and work in an environment that is free from discrimination and/or harassment. Language or activities that defeat this objective violate the College Policy on Discrimination/Harassment and shall not be tolerated. Information and assistance are available from the Student Conduct Office at

Accommodation for Students with Disabilities
The College will provide reasonable accommodation to students with disabilities in order to promote academic success. If you require accommodation, contact the Counselling and Disabilities Services Office at ext. 22900 to initiate the process for documenting, assessing and implementing your individual accommodation needs.

MCT140 or MCW140 or equivalent experience.

Topic Outline
Advanced Formatting

  • Conditional Formatting
  • Using Custom Cell Formats
  • Internationalization
  • User Defined Styles
  • +Body and +Heading Fonts

Advanced Functions and Formulas
  • Working with Names Ranges
  • What are Functions?
  • Using Lookup Functions
  • Date and Time Functions
  • Checking for Formula Errors
  • Data Validation

Data Analysis Using Pivot Tables and Business Intelligence
  • Creating and Managing PivotTables
  • Using Data Slicers with a PivotTable
  • Pivot Charts
  • Business Intelligence

Workbook Management Features
  • Linking External Workbooks
  • Consolidating Data
  • Workgroup Functions
  • Using Comments
  • Protecting Your Workbook

Advanced Charts, Functions and What-If Analysis
  • Advanced Chart Elements
  • Using Advanced Functions and Features
  • What-If Analysis
  • Structured References

Data Filtering, Macros, and Forms
  • Advanced Filtering
  • Working with Templates
  • Accessing Hidden Ribbon Tabs
  • Macros
  • Adding Form Controls
  • Changing Excel Formula Calculation Options

Mode of Instruction
Classroom instruction and extensive hands-on experience will be provided with each participant having exclusive use of a computer. Additional modes of instruction will include class discussion and question and answer period. 

Prescribed Texts
The following course materials will be provided:
Excel 2016 Expert 

Required Supplies

Promotion Policy

Grading Policy
A+ 90%  to  100%
A 80%  to  89%
B+ 75%  to  79%
B 70%  to  74%
C+ 65%  to  69%
C 60%  to  64%
D+ 55%  to  59%
D 50%  to  54%
F 0%    to  49% (Not a Pass)
EXC Excellent
SAT Satisfactory
UNSAT Unsatisfactory

For further information, see a copy of the Academic Policy, available online ( or at Seneca's Registrar's Offices.

Modes of Evaluation
There is no formal testing or process to evaluate the students understanding. It is up to the student to evaluate his/her own progress.  Students must attend 70% of classes to receive a document confirming he/she attended this course.

Approved by: Sharon Estok, Denis Gravelle