Work more efficientlyWhether you need to organize data, do multiple calculations, create a slideshow, or write a book; Microsoft Office has the application for you and CCBC has the class to help you learn how to use it. CCBC has a variety of courses and multiple levels to help use Microsoft Office with ease and work more efficiently.
Microsoft Office Courses
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 »
Data Analysis with Excel 2013 PivotTables
Topics to be covered include: preparing data and creating PivotTables, analyzing data using PivotTables, working with PivotCharts.
Prerequisite: Excel 2013 Intermediate or equivalent knowledge.
Data Analysis with Excel 2016 PivotTables
Use Power Pivot Tables to organize, manipulate and report on large amounts of data quickly.
Pre-requisite: Excel 2016 Intermediate, or equivalent knowledge.
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 »
Excel 2016 Complete
This course is a combination of the Excel 2016 Introduction, Intermediate and Advanced courses.
Prerequisite: Windows Introduction or equivalent knowledge.
Microsoft Office Introduction
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 »
Create a project plan during the planning phase of a project and then update during the execution, monitoring, and controlling phases.
Microsoft Project »
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 »
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 »
Online courses offered in partnership with ed2go
- 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