• Professor helping a student in a computer class

Work more efficiently

Whether 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

Microsoft Office 2010 Introduction

Students learn the basics of Word, Excel, PowerPoint, and Access by doing hands-on projects. First they learn to navigate Word and use editing techniques to create and edit letters. Next they will produce a worksheet with basic formulas and functions in Excel. Students then create a PowerPoint presentation. Then they will create an Access database.

Topics to be covered include: creating, editing, saving, and printing a document; creating an envelope; creating WordArt and using Clip Art; creating and editing a spreadsheet; using Excel formulas, functions, and charts ; creating a PowerPoint presentation; delivering a slide show; creating an Access database; working with tables in Access; and previewing and printing data in Access.

Prerequisite: Windows Introduction or equivalent knowledge.

Microsoft Office 2013 Introduction

Students learn the basics of MS Office 2013 Word, Excel, PowerPoint, and Access by doing hands-on projects. First they learn to navigate Word and use editing techniques to create and edit letters. Next they will produce a worksheet with basic formulas and functions in Excel. Students then create a PowerPoint presentation. Then they will create an Access database.

Topics to be covered include: creating, editing, saving, and printing a document; creating an envelope; creating WordArt and using Clip Art; creating and editing a spreadsheet; using Excel formulas, functions, and charts ; creating a PowerPoint presentation; delivering a slide show; creating an Access database; working with tables in Access; and previewing and printing data in Access.

Prerequisite: Windows Introduction or equivalent knowledge.

Access 2010 Introduction

Students learn the basic functions and features of Access 2010. Students will be introduced to database concepts, the Access environment, and the Help systems. Students will then learn how to design and create databases and create queries, forms, and reports.

Topics to be covered include: database concepts, the Access environment, planning and designing databases, tables, fields, records, queries, forms, and reports.

Prerequisite: Windows Introduction or equivalent knowledge.

Access 2010 Intermediate

Students learn how to 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.

Topics to be covered include relational databases, related tables, complex queries, advanced form design, reports and printing, charts, and PivotTables and PivotCharts.

Prerequisite: Access 2010 Introduction or equivalent knowledge.

Access 2010 Advanced

Students 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.

Topics to be covered include querying with SQL; advanced queries; macros; advanced macros; importing, exporting, and linking; and database management.

Prerequisite: Access 2010 Intermediate or equivalent knowledge.

Access 2013 Introduction

Students learn the basic functions and features of Access 2013. Students learn to navigate the Access 2013 environment, explore the Help system, create a new database, construct data tables, design forms and reports, and create queries.

Topics to be covered include the Access 2013 environment, working with table data, querying a database, creating advanced queries, generating reports, and customizing the Access environment.

Prerequisite: Windows Introduction or equivalent knowledge.

Access 2013 Intermediate

Students expand their knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports.

Topics to be covered include designing a relational database, joining tables, organizing a database for efficiency, sharing data across applications, and advanced reporting.

Prerequisite: Access 2013 Introduction or equivalent knowledge.

Access 2013 Advanced

Students learn advanced Access features such as, database management, advanced form design, packaging a database, encrypting a database, and preparing a database for multi-user access.

Topics to be covered include implementing advanced form design, using data validation, using macros to improve user interface design, using advanced database management, distributing and securing a database, and managing switchboards.

Prerequisite: Access 2013 Intermediate or equivalent knowledge.

Excel 2010 Introduction

Students learn the basic functions and features of Excel 2010. Students are introduced to spreadsheet terminology, the Excel 2010 environment, and the Help system. They will then learn how to create, edit, format, and print basic Excel 2010 worksheets.

Topics to be covered include spreadsheet terminology, Excel 2010 environment, entering and editing data, modifying a worksheet, functions, formatting, printing, charts, and managing large workbooks.

Prerequisite: Windows Introduction or equivalent knowledge.

Excel 2010 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.

Topics to be covered include using multiple worksheets and workbooks, advanced formatting, outlining and subtotals, cell and range names, tables, web and sharing features, advanced charting, documenting and auditing, templates and settings, and PivotTables and PivotCharts.

Prerequisite: Excel 2010 Introduction or equivalent knowledge.

Excel 2010 Advanced

Students learn advanced formulas, lookup functions, data validation and database functions, importing and exporting data, and how to query external databases. Students also learn about the analytical features of Excel, running and recording macros, SmartArt graphics, and conditional formatting with graphics.

Topics to be covered include advanced functions, Lookups and data tables, advanced data management, exporting and importing, analytical tools, macros and custom functions, conditional formatting, and SmartArt graphics.

Prerequisite: Excel 2010 Intermediate or equivalent knowledge.

Excel 2013 Introduction

Students learn the basic functions and features of Excel 2013. Students learn to navigate the Excel 2013 environment, explore the Help system, and perform basic tasks associated with creating and saving worksheets. They will use formulas and functions to perform calculations, modify worksheets, search and replace data, check spelling, and format worksheets. Students will also work with multiple worksheets and customize Excel.

Topics to be covered include the Excel 2013 environment, entering and editing data, performing calculations, modifying a worksheet, formatting, printing, managing large workbooks, and customizing the Excel environment.

Prerequisite: Windows Introduction or equivalent knowledge.

Excel 2013 Intermediate

Students learn how to create advanced workbooks and worksheets with Excel 2013. Students learn how to create advanced formulas, analyze data with logical and lookup functions, organize data into tables, and visualize data using charts. Students also learn to analyze data with PivotTables, slicers, and PivotCharts; insert graphics; and enhance workbooks using themes and templates.

Topics to be covered include advanced formulas, Logical and Lookup Functions, tables, charts, PivotTables, Slicers, PivotCharts, graphics, themes and templates.

Prerequisite: Excel 2013 Introduction or equivalent knowledge.

Excel 2013 Advanced

Students learn how to use some of the more advanced features of Excel 2013 including automating common tasks, auditing workbooks to avoid errors, sharing data with others, analyzing data, and using Excel data in other applications.

Topics to be covered include automating worksheet functionality, auditing worksheets, analyzing and presenting data, working with multiple workbooks, and exporting Excel data.

Prerequisite: Excel 2013 Intermediate or equivalent knowledge.

PowerPoint 2010 Introduction

Students learn to customize PowerPoint by modifying the Ribbon and changing application settings, apply themes and templates, and work with SmartArt graphics and tables. Students will also add multimedia content and interactive elements to slides, and learn about presentation distribution options including PDF, HTML, and online broadcasts. Finally, students will integrate PowerPoint with Word and Excel.

Topics to be covered include: customizing PowerPoint, using graphics and multimedia, customizing SmartArt graphics and tables, actions buttons, custom slide shows, equations, distributing presentations, and integrating Microsoft Office files.

Prerequisite: PowerPoint 2010 Introduction or equivalent knowledge.

PowerPoint 2010 Advanced

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, students will integrate PowerPoint with Word and Excel.

Topics to be covered include customizing PowerPoint, using graphics and multimedia, customizing SmartArt graphics and tables, actions buttons, custom slide shows, equations, distributing presentations, and integrating Microsoft Office files.

Prerequisite: PowerPoint 2010 Introduction or equivalent knowledge.

PowerPoint 2013 Introduction

Students learn the basic functions and features of PowerPoint 2013. Students learn to navigate the PowerPoint 2013 environment, explore the Help system, and develop a PowerPoint presentation that includes text, graphics, objects, tables, and charts. Students also learn to apply transitions, print the presentation, and deliver the presentation.

Topics to be covered include: the PowerPoint environment, develop a PowerPoint presentation, perform advanced text editing, add graphical elements, modify objects, add tables, add charts, and prepare to deliver a presentation.

Prerequisite: Windows Introduction or equivalent knowledge.

PowerPoint 2013 Advanced

Students learn how to use some of the more advanced features of PowerPoint 2013 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.

Topics to be covered include: modifying the PowerPoint environment, customizing design templates, adding SmartArt to a presentation, adding media and animations to a presentation, collaborating on a presentation, customizing a slide show, and securing and distributing a presentation.

Prerequisite: PowerPoint 2010 Introduction or equivalent knowledge.

Word 2010 Introduction

Students learn the basic functions and features of Word 2010. Students will enter and edit text, create and save documents, and learn how to enhance the appearance of a document by using various formatting options. They will also create tables, insert headers and footers, proof and print documents, and insert graphics.

Topics to be covered include: exploring the Word 2010 environment, navigation and selection techniques, editing text, formatting text, tables, page layout, proofing and printing documents, and graphics.

Prerequisite: Windows Introduction or equivalent knowledge.

Word 2010 Intermediate

Students learn how to work with styles, sections, and columns and use the Navigation pane to work with outlines. Students will format tables, print labels and envelopes, and work with graphics. They will also use document templates, manage document revisions, and work with Web features.

Topics to be covered include: styles and outlines, sections and columns, formatting tables, printing labels and envelopes, templates and building blocks, graphics, managing document revisions, and web features.

Prerequisite: Word 2010 Introduction or equivalent knowledge.

Word 2010 Advanced

Students learn mail merges, create and use forms, and create master documents that include a table of contents, a table of figures, footnotes, endnotes, an index, bookmarks, cross-references, and Web frames. They will also create macros, customize the ribbon and Quick Access toolbar, and work with XML documents.

Topics to be covered include: using Mail Merge, objects and backgrounds, working with forms, using macros, customizing Word, long documents, and XML features.

Prerequisite: Word 2010 Intermediate or equivalent knowledge.

Word 2013 Introduction

Students learn the basic functions and features of Word 2013. Students learn to navigate the Word 2013 environment, explore the Help system, and use Word 2013 to create and edit simple documents, format documents, add tables and lists, add design elements and layout options, and proof documents.

Topics to be covered include: the Word 2013 environment, editing a document, formatting text and paragraphs, adding tables, managing lists, inserting graphic objects, controlling page appearance, proofing a document, and customizing the Word environment.

Prerequisite: Windows Introduction or equivalent knowledge.

Word 2013 Intermediate

Students learn how to create more complex documents that include lists, tables, charts, graphics, and newsletter layouts. Students will also merge data into documents to personalize correspondence and address envelopes and labels; and use macros to automate tasks.

Topics to be covered include: working with tables and charts, customizing formats using styles and themes, using images in a document, creating custom graphic elements, inserting content using Quick Parts, controlling text flow, using templates, using mail merge, and using macros.

Prerequisite: Word 2013 Introduction or equivalent knowledge.

Word 2013 Advanced

Students learn how to collaborate with others on documents; add reference marks and notes such as, captions, bookmarks, footnotes, citations and a bibliography; simplify and manage long documents with cover pages, an index, a table of content, outlines, and a master document; secure documents; and create forms.

Topics to be covered include: collaborating on documents, adding reference marks and notes, simplifying and managing long documents, securing a document, and forms.

Prerequisite: Word 2013 Intermediate or equivalent knowledge.

Online courses offered in partnership with ed2go

For course details, click on the following link and search for the course title. http://www.ed2go.com/ccbconline/
  • 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