Your browser is not optimized for viewing this website.

More information »

Manchester Community College

NCCP354M Microsoft Excel Level II

with CTBD Instructor

$145

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: 13700 Via Zoom: Oct 19 - 22nd, 2020
    Mon - Thu from 9:30 am - 11:00 pm

Manchester Community College

603-206-8162

1066 Front Street
Manchester, NH 03102 Get directions

Room: Via Zoom

Location map for Manchester Community College




Forgot password?