NHCU 8003 - Office 2007 New Features
Students will learn how to use the most commonly used features of the applications in Microsoft Office 2007.
NHCU 8008 - Outlook 2007 - Level 1
This course will concentrate the principles of Outlook 2007 including e-mail and contact management; creating tasks, appointments and events; meeting requests and responses.
NHCU 8009 - Outlook 2007 - Level 2
This course will concentrate on the aspects of Outlook 2007 involving messages, creation of folders, program customization, organization of items and mail.
NHCU 8015 - Access 2003 - Level 1
This course will concentrate on establishing table relationships, designing forms, producing reports, controlling data entry, creating flexible queries, improving your forms, and customizing your reports. Participants of the course will focus on querying, planning, and building the structure of a database; also, finding, joining, and managing data.
NHCU 8018 - Access 2007 - Level 1
The course will build knowledge of Access 2007 consisting of designing, building and querying a database; managing data in a table and sharing across applications. The course will also cover topics such as generating reports, controlling data entry, joining tables, creating flexible queries, customizing reports, designing and improving forms.
NHCU 8019 - Access 2007 - Level 2
The course will build knowledge of Access 2007 consisting of structuring existing data, writing advanced queries, simplifying tasks with macros, effectively using forms, making reports more efficient, and maintaining an Access database.
NHCU 8020 - Access 2007 - Level 3
The course will build knowledge of Access 2007 consisting of integrating access into your business, automating a business process with VBA, managing switchboards, distributing and securing databases, and sharing a database using a SharePoint list.
NHCU 8021 - Access 2010 Part 1
In this course, students will learn how to use Access 2010 to manage your data, including creating a new database, constructing tables, designing forms and reports, and creating queries to join, filter, and sort data. This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access 2010, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.
NHCU 8022 - Access 2010 Part 2
Students will expand their knowledge of Microsoft Access 2010 to include relational database design, writing advanced queries, structuring existing data, sharing data across applications, and customizing reports. This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, creating advanced queries and reports, or integrating Access with other programs.
NHCU 8028 - Excel - Business Data Analysis (Pivot Tables)
The focus of this course will be to develop knowledge of data lists and drilldowns, creating and formatting a pivot table, using calculations and formulas, also, generating groups and pivot chart.
NHCU 8029 - Excel 2003 - Level 1
The objective of this course is to teach participants to modify and format a worksheet, use of the functions, print, create charts, understand web features, enter and edit data.
NHCU 8030 - Excel 2003 - Level 2
This course will concentrate on working and using multiple worksheets, customizing excel, advanced formatting, list management, charting, using templates, documenting and auditing.
NHCU 8031 - Excel 2003 - Level 3
The course will prepare participants to work with advanced formulas, lookups and data tables, advanced list management, PivotTables and PivotCharts, macros, interactive web pages, and SharePoint services. Another focus of the course will be using analytic options, also, exporting and importing.
NHCU 8032 - Excel 2007 - Level 1
The course will focus on modifying a worksheet, using functions, formatting, printing, creating charts, managing large workbooks, also, entering and editing data.
NHCU 8033 - Excel 2007 - Level 2
The focus of the course will be using multiple worksheets and workbooks, lists, tables, internet features, templates, settings, cell and range names, and subtotals. Participants will experience advanced charting, formatting, documenting, and auditing outlining.
NHCU 8034 - Excel 2007 - Level 3
The course emphasis will be lookups and data tables, advanced list management, interactive web pages, exporting and importing, furthermore, using analytic options and SharePoint services. The course will also call for working with advanced formulas, PivotTables, PivotCharts, and macros.
NHCU 8035 - Excel 2010 - Level 1
Level 1 - In this course, students will use Microsoft® Office Excel® 2010 to create spreadsheets and workbooks that they can use to store, manipulate, and share data.
NHCU 8037 - Excel 2010 - Level 3
Students will work with advanced formulas, as well as look-up functions such as VLOOKUP, MATCH, and INDEX; will learn about data validation and database functions such as DSUM; will learn how to import and export data, and how to query external data bases.
NHCU 8040 - PowerPoint 2007 - Level 1
This course will teach the principles of creating new presentations and formatting slides; drawing objects, graphics, tables and charts; modifying, proofing and delivering presentations.
NHCU 8041 - PowerPoint 2007 - Level 2
The course will prepare participants to use custom presentation options, graphic and multimedia content, also, to personalize SmartArt graphics and tables. Additionally, participants will focus on distributing a presentation, integrating Microsoft Office files, action buttons and custom slide shows.
NHCU 8043 - PowerPoint 2010 - Level 1
Participants of this course will create new presentations, format slides, use drawing objects, work with graphics, produce tables and charts, modify presentations, proof and deliver presentations within PowerPoint 2010.
NHCU 8046 - Project 2007 - Level 1
The course will focus on Project 2007 duties such as scheduling, working, and finalizing tasks; managing resources; using views and tables; employing filtering, grouping, and sorting.
NHCU 8047 - Project 2007 - Level 2
This course will place emphasis on tracking project work, analyzing and adjusting the plan, formatting and reporting, customizing the project environment, managing multiple projects, project communications, and exchanging project data.
NHCU 8048 - Project 2010 - Level 1
The course concentrates on task scheduling, resource management, views and tables, finalizing task plans, principles of filters, also, groups and sorting.
NHCU 8053 - Word 2007 - Level 1
This course will focus on topics within Microsoft ®Word 2007 inclusive of getting started, navigation and selection techniques, editing and formatting text, tables, page layout, proofing and printing documents, and graphics.
NHCU 8054 - Word 2007 - Level 2
This course will focus on topics within Microsoft Word 2007 inclusive of styles, sections and columns, formatting tables, printing labels and envelopes, templates and building blocks, graphics, managing document revisions, and web features.
NHCU 8055 - Word 2007 - Level 3
This course will focus on topics within Microsoft Word 2007 inclusive of mail merge, objects and backgrounds, forms, macros, toolbar and keyboard customization, long documents, and XML features.
NHCU 8101 - Windows 7 - Level 1
Students will log on to Windows 7, explore its interface, identify the different components in the interface, customize the Windows 7 desktop, manage files and folders, use the common tools, and browse the internet.
NHCU 8112 - 6292 Installing and Configuring Windows 7 Client
This three-day instructor-led course is intended for IT professionals who are interested in expanding their knowledge base and technical skills about Windows 7 Client. with wireless network connections, and secure Windows 7 desktops. Concentration will be placed on actions in Windows 7 including installing, updating and migrating; configuring disks, device drivers, file access, printers, mobile computing and remote access; also, optimizing maintaining client computers.