Microsoft Office

Prerequisite: Windows Introduction or equivalent knowledge, and previous level class or equivalent knowledge for intermediate and advanced levels

Introduction: Learn the basic functions and features of Access, database concepts, the Access environment, and the Help systems. Design and create databases and create queries, forms, and reports.
Access Introduction »

Intermediate: Normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculate fields, and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use PivotTables and PivotCharts.
Access Intermediate »

Advanced: Learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; interact with XML documents; create hyperlink fields; optimize, split, and backup databases; password protect and encrypt databases; and set Access options and properties. 
Access Advanced »

Students learn how to use Excel 2013 advanced PivotTable functionality to analyze your raw data.

Topics to be covered include: preparing data and creating PivotTables, analyzing data using PivotTables, working with PivotCharts.

Prerequisite: Excel 2013 Intermediate or equivalent knowledge.

Use Power Pivot Tables to organize, manipulate and report on large amounts of data quickly.

Pre-requisite: Excel 2016 Intermediate, or equivalent knowledge. 

Data Analysis with Excel 2016 Power PivotTables »

Prerequisite: Windows Introduction or equivalent knowledge, and previous level class or equivalent knowledge for intermediate and advance levels

Introduction: Learn the basic functions and features of Excel: spreadsheet terminology, the Excel environment, and the Help system. Create, edit, format, and print basic Excel worksheets.
Excel Introduction »

Intermediate: Learn how to use multiple worksheets and workbooks efficiently, and work with more advanced formatting options including styles, themes, backgrounds, outlines and subtotals, create and apply cell names, work with tables, save workbooks as Web pages, insert and edit hyperlinks, and learn to share workbooks by email. Also covered are advanced charting techniques, worksheet auditing and protection, file sharing and merging, workbook templates, and PivotTables and PivotCharts.
Excel Intermediate »

Advanced: Learn advanced formulas, lookup functions, data validation and database functions, importing and exporting data, and how to query external databases. Explore the analytical features of Excel, running and recording macros, SmartArt graphics, and conditional formatting with graphics.
Excel Advanced »

This course is a combination of the Excel 2016 Introduction, Intermediate and Advanced courses.

Prerequisite: Windows Introduction or equivalent knowledge.

Excel 2016 Complete »

Prerequisite: Windows Introduction or equivalent knowledge

Learn the basics of MS Office Word, Excel, PowerPoint, and Access by doing hands-on projects. Create and edit Word documents, produce an Excel spreadsheet with basic formulas and functions, create a PowerPoint presentation, and develop an Access database.
Microsoft Office Introduction »

Prerequisites: Windows Intro or equivalent knowledge and an understanding of project management concepts.

Create a project plan during the planning phase of a project and then update during the execution, monitoring, and controlling phases.
Microsoft Project »

Prerequisite: Windows Introduction or equivalent knowledge, and previous level class or equivalent knowledge for the advanced level

Introduction: Customize PowerPoint by modifying the Ribbon and changing application settings, apply themes and templates, and work with SmartArt graphics and tables. Add multimedia content and interactive elements to slides, and learn about presentation distribution options including PDF, HTML, and online broadcasts. Finally, integrate PowerPoint with Word and Excel.
PowerPoint Introduction »

Advanced: Learn  to use some of the more advanced features of PowerPoint including modifying the PowerPoint environment, customizing design templates, adding SmartArt, adding media and animations, collaborating on a presentation, customizing a slide show, and securing and distributing a presentation.
PowerPoint Advanced »

Prerequisite: Windows Introduction or equivalent knowledge, and previous level class or equivalent knowledge for intermediate and advanced levels

Introduction: Learn to create and edit simple documents; format documents; add tables and lists, design elements, layout options; and proof documents.
Word Introduction »

Intermediate: Learn to customize documents using tables, charts, styles, themes, and Quick Parts and automate tasks using templates and mail merge.
Word Intermediate »

Advanced: Manipulate images, collaborate and track revision, use cross-referencing and linking, secure a document, use forms, and create macros.
Word Advanced »

For course details, For course details, visit http://www.ed2go.com/ccbconline/ and search for the course title.

• What’s New in Microsoft Office?
• Introduction to Microsoft Access
• Intermediate Microsoft Access
• Introduction to Microsoft Excel
• Intermediate Microsoft Excel
• Advanced Microsoft Excel
• Introduction to PowerPoint
• Introduction to Microsoft Word
• Intermediate Microsoft Word