Your browser is not optimized for viewing this website.

More information »

Manchester Community College

Filter by Category



Computer Skills

NCCP353M Microsoft Excel Level I

$145

with Woody Pringle

Calendar Next available session starts Jul 6, 2020 at 9 am
2 additional sessions through Sep 9, 2020

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.

NCCP11M Keyboarding

$160

with Carol Rodrigues

Calendar Next available session starts Jun 8, 2020 at 9 am, runs for 3 weeks

This course is designed for students who want to learn how to use touch-type to increase their speed and efficiency on the keyboard. The open, modular-style manual is designed for quick scanning in the classroom, and is filled with interactive exercises that allows students to explore the intricacies of KAZ (Keyboarding A to Z). Students need to have access to a computer at home to practice.

NCCP354M Microsoft Excel Level II

$145

with Woody Pringle

Calendar Next available session starts Jul 13, 2020 at 9 am
2 additional sessions through Sep 16, 2020

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.

NCCP350M - Microsoft Word Level I

$145

with Kimberly Campion

Calendar Next available session starts Jun 11, 2020 at 1 pm

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.

NCCP351M Microsoft Word Level II

$145

with Kimberly Campion

Calendar Next available session starts Jun 25, 2020 at 1 pm

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.

 

NCCP73M QuickBooks I 2018

$225

with Carol Rodrigues

Calendar Next available session starts Jul 1, 2020 at 8:30 am
2 additional sessions through Aug 3, 2020

 

This course will teach the basics of QuickBooks, getting started, setting up a company and inventory, invoices, processing payments, working with bank accounts, and entering and paying bills.

Prerequisites: You can successfully complete this training without any prior software knowledge or computer experience. A basic understanding of the computer operating system is recommended.

Required Book Information: "Get Going With QuickBooks® 2018 for Windows" purchase at Logical Operations.

OR both books can be seen here:

https://store.logicaloperations.com/catalogsearch/result/?q=Keep+Going+with+QuickBooks+2018

Each book is written to assume the user has no prior computer skills. If you are using the software for the first time, you will be introduced to its primary features. If you are familiar with the software, you will quickly learn the new features and functionality of this version. Regardless of your skill level, you will learn with the greatest of ease.

This course is WIOA Certified.

NCCP84M QuickBooks II 2018

$145

with Carol Rodrigues

Calendar Next available session starts Jul 14, 2020 at 8:30 am
1 additional session on Aug 12, 2020

This course is in more detail than QuickBooks Level I. This course will teach advance steps in QuickBooks, customizing forms, using other QuickBooks accounts, creating reports, creating graphs, doing payroll with QuickBooks and estimating time tracking and job costing.

Prerequisites: You can successfully complete this training without any prior software knowledge or computer experience. A basic understanding of the computer operating system is recommended.

Required Book Information: “Keep Going With QuickBooks® 2018 for Windows" purchase at Logical Operations.

OR both books can be seen here:

https://store.logicaloperations.com/catalogsearch/result/?q=Keep+Going+with+QuickBooks+2018

Each book is written to assume the user has no prior computer skills. If you are using the software for the first time, you will be introduced to its primary features. If you are familiar with the software, you will quickly learn the new features and functionality of this version. Regardless of your skill level, you will learn with the greatest of ease.

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.

 





Forgot password?