Your browser is not optimized for viewing this website.

More information »

Manchester Community College

NCCP354M Microsoft Excel Level II

with CTBD Instructor


Summer Excel classes will be conducted via Zoom online meetings.

This class covers the following excel topics:

Working with Multiple Worksheets and Workbooks Simultaneously:  Use 3-D References, Use Links and External References, Consolidate Data

Using Advanced Worksheet Functions: Conditional & Logical Functions with If / Nested If / And/OR, VLookup, Apply Cell and Range Names

Goal Seek

Conditional Formatting: Creating Rules to Highlight Cells, Using Icon Sets with Inequalities

Presenting Data with Charts:  Using Sparklines, Review Chart Basics, Evaluate Formatting Options, Combine Charts, Add Graphical Elements (Trend line) 

Analyzing Data Using PivotTables, Slicers, and PivotCharts: Create a PivotTable Report, Filter Data Using Slicers, Analyze Data Using PivotCharts

Customizing and Enhancing the Excel Environment: Customize the Excel Environment, Manage Themes, Create and Use Templates, Apply Spreadsheet Security

And More: Controlling Page Breaks, Use Page Setup to Repeat Headings (Rows/Columns), Automate Tasks with a Simple Macro

This course is WIOA Certified.

  • CRN: 31125 Via Zoom: Jul 13 - 15th, 2020
    Mon and Wed from 9:00 am - 12:00 pm

    Only 17 hours left to register!

  • CRN: TBA Via Zoom: Aug 10 - 12th, 2020
    Mon and Wed from 9:00 am - 12:00 pm
  • CRN: 13700 Via Zoom: Sep 14 - 16th, 2020
    Mon and Wed from 9:00 am - 12:00 pm

Manchester Community College


1066 Front Street
Manchester, NH 03102 Get directions

Room: Via Zoom

Location map for Manchester Community College

Forgot password?