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
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.
Manchester Community College
1066 Front Street
Manchester, NH 03102 Get directions
Room: Via Zoom