Your browser is not optimized for viewing this website.

More information »

Manchester Community College

Filter by Category



Computer Skills

NCCP351M Microsoft Word Level II

$145

with Kimberly Campion

Calendar Next available session starts Oct 15, 2020 at 1 pm
2 additional sessions through Dec 17, 2020

Summer Excel classes will be conducted via Zoom online meetings.

This course expects a base knowledge from participants in using Microsoft Word.  Advanced topics will be covered such as formatting a document, using templates, marking a document, inserting objects, mail merge, and other special features.  This class will take your basic knowledge of Word to a new level.

This course is WIOA Certified.

 

NCCP350M - Microsoft Word Level I

$145

with Kimberly Campion

Calendar Next available session starts Oct 1, 2020 at 1 pm
2 additional sessions through Dec 3, 2020

Summer Word classes will be conducted via Zoom online meetings.

Microsoft Word is a word processing program that allows for the creation of simple and more advanced documents.  This course focuses on the basics of Microsoft Word including opening documents, the toolbar and saving files.  Further, participants will learn about creating documents, formatting, page layout options, how to proof a document and creating tables.

 

This course is WIOA Certified.

NCCP353M Microsoft Excel Level I

$145

with CTBD Instructor

Calendar Next available session starts Oct 5, 2020 at 9:30 am

Summer Excel classes will be conducted via Zoom online meetings.

This class covers the following excel topics:

Getting Started with Excel: Performing Calculations in an Excel Worksheet, Modifying an Excel Worksheet, Modifying the Appearance of a Worksheet, Printing Excel Workbooks, Introduction to Charts & Graphs, Managing an Excel Workbook

Performing Calculations in an Excel Worksheet: Learn How to use Basic Math in Excel, Create Formulas with Sum/Max/Min/Average, Use Formula View, Understand Relative and Absolute References

Modifying an Excel Worksheet: Edit Worksheet Data, Find and Replace Data, Manipulate Worksheet Elements

Modifying the Appearance of a Worksheet: Apply Font Properties, Add Borders and Colors to Cells, Align Content in a Cell, Apply Number Formatting, Apply Cell Styles, Insert Comments

Printing Excel Workbooks: Define the Page Layout, Learn to use Header/Footer, Add File Pathway Documentation, Print 

Introduction to Charts & Graphs: Create and Modify Charts, Use Chart Layout Tools

Managing an Excel Workbook: Manage Worksheets with Data Filters, Apply Multi-Level Sort, Use the Sub-Totals View, Discover Pivot Tables

This course is WIOA Certified.

NCCP354M Microsoft Excel Level II

$145

with CTBD Instructor

Calendar Next available session starts Oct 19, 2020 at 9:30 am

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.

Computer Programming Languages Online

$675

with ON LINE

This program provides a background in programming and logic, Microsoft Access and Visual Basic, and Java to help prepare students for entry-level positions as a computer programmers, website or software developers, or database managers. You’ll gain experience with real programs used in the technology field today.  Applicable skills:

Learn the basics of computer programming and logic. Understand the basic logic common to all programming languages.

Create loops; create, search, and sort arrays; create modules and hierarchy charts. Use Boolean expressions, validate input Design graphical user interfaces. Create new Access databases, create forms and reports, sort and filter your data with queries, analyze your data.

Use the Java programming language to program applets and create animations and graphics for use on the Internet. Use Swing components and create Java programs using layout managers.

Apply Visual Basic programming algorithms and data structures to solve real-world problems. Apply object-oriented programming concepts to create new code libraries and use existing code libraries.

Design a complex user interface for a Windows Forms application.

On average this course is 402 hours of independent, online instruction.

For more detailed information: Computer Programming Languages PROGRAM OUTLINE

This course is WIOA Certified.

 

NCCP363M Microsoft PowerPoint

$75

with CTBD Instructor

PowerPoint is a digital presentation program.  This course will cover creating a presentation, designing a presentation, using animation, charting, using SmartArt, and running a presentation.  This course will give you the tools to create professional presentations.

This course is WIOA Certified.

Full Course

NCCP364M ABCs of PC Technology, Google, MS Office, and Windows

$75

with Woody Pringle

This course is designed to bring the novice up-to-speed with the now. Reviewing the what you think “kids” know about computers - the class explores the skills needed for today’s workplace.

Computer Technology

  • A quick big-picture overview of everything
  • Terms & concepts translated for humans

Folder Management

  • Create File Folders, Subfolders, Desktop Shortcuts
  • Save files to folders
  • Copy and paste files 

Google and YouTube

  • Learn to lookup information and find solutions to problems by using Google and YouTube
  • Identify the Components of the Outlook

Explore MS Office - Specific skill sets include creating simple Word and Spreadsheet files and saving to folders.

  • Identify the Structure if MS Word
  • Create and Save a Document
  • Learn to Copy, Cut, and Paste
  • Use more Keyboard Shortcuts
  • Identify the Elements of the Excel Screen
  • Navigate and Select Cells in Worksheets
  • Create a Basic Worksheet
  • Add, Rename, Move, and Delete Worksheets
  • Learn How to use Basic Math in Excel

 

Review Email Basics as needed

Other Technology and PC Skills provided as needed or by request.

WIOA Approved 

Full Course

NCCP370M Microsoft OneNote

$75

with CTBD Instructor

Microsoft OneNote is a digital notebook that enables you to enter and organize text, files, videos, audio files, perform simple calculations, add links and insert drawings in structured way. Notebooks can be shared with multiple users so you can work more efficiently. OneNote contains an easy to use search feature to find data in a notebook. This workshop will show you how to create, manage and navigate a OneNote notebook.

This workshop will cover the following topics: 

  • Navigating OneNote
  • Creating a notebook
  • Organizing a notebook by creating sections and pages
  • Adding text and inserting images
  • Inserting video/audio files
  • Attaching files such as Excel or Word into a notebook
  • Adding a tag to a note
  • Using drawing tools
  • Password protecting a section
  • Sharing notebooks

 

 

Full Course




Forgot password?