Business Solutions

Students learn to protect themselves and their organization from technology-related risks. They will gain information on how to understand security compliance considerations, social engineering, malware, and various other data security-related concepts. Students will also explore the hazards and pitfalls and learn how to use technology safely and securely.

Topics to be covered include: identifying the need for security, securing devices, and using the internet securely.

Prerequisite: Windows Intro or equivalent knowledge.

This course is designed to enable non-technical managers to learn about threats and vulnerabilities, safeguards, common attacks, viruses, malware and spyware, disaster recover planning, Intrusion Detection/Prevention, basic security architecture, introductory forensics, and cyber terrorism. At the end of this course, students will have the knowledge needed to practice safer computing and safeguard their business and work information.

Topics to be covered include: introduction to cybersecurity, threats and vulnerabilities, information assurance, and disaster recover planning.

This is an online course offer in partnership with LERN.

Students learn how to take advantage of some of the higher level functionality in Excel to summarize table data by using functions, charts, and PivotTables and display those elements in a dashboard format.

Topics to be covered include: creating advanced formulas: automating workbook functionality; applying conditional logic; visualizing data with basic charts; advanced charting techniques; and analyzing data with PivotTables, Slicers, and PivotCharts.

Prerequisite: Excel 2013 Intro or equivalent knowledge.

Students learn how manage and distribute company communications using the Mail Merge feature in Word 2013 and the database features in Excel 2013. Student will learn how to create and maintain a client list in Excel 2013, use Word 2013 to create a document with custom merged fields from Excel, and then save it as a template to reuse later.

Topics to be covered include: creating and maintaining an Excel worksheet database, creating a letterhead template, use a template to create a letter, use Mail Merge, and merge envelope data.

Prerequisite: Intro level courses in Word 2013, and Excel 2013 or equivalent knowledge.

Students learn how to create a worksheet database and learn a variety of filter techniques to manage a worksheet database using Excel 2013.

Topics to be covered include: preparing, sorting, and maintaining a list; finding data; and sorting and filtering data.

Prerequisite: Excel 2013 Intro or equivalent knowledge.

Students learn how to take advantage of the many templates available in Microsoft Office 2013 for business use. Students will also learn how to create and manage templates.

Topics to be covered include: exploring Word, Excel, and PowerPoint templates; customize templates; create templates; manage templates.

Prerequisite: Intro level courses in Word 2013, Excel 2013, and PowerPoint 2013 or equivalent knowledge.

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

• Introduction to Microsoft Outlook
• Introduction to Microsoft Project
• Introduction to QuickBooks
• Intermediate QuickBooks

Students learn how to create a variety of charts with emphasis on selecting appropriate chart types and enhancing them by using various chart options.

Topics to be covered include: picturing Excel data in a chart, create a chart from Excel data using the Chart Wizard, explore various chart types, create embedded and linked Excel chart objects to other Microsoft Office applications.

Prerequisite: Excel 2013 Intro or equivalent knowledge.

Students learn how to create and use an Evernote account to get digitally organized from storing photos, PDFs, notes, and web sites to creating a business card list and reminders.

Topics to be covered include: create and edit notes, create a notebook, searching notebooks and notes, desktop and cell phones.

This is an online course offer in partnership with LERN.

Students learn how to be more productive using Google’s variety of web based applications and tools, including Gmail, Google Calendar, Drive, Hangouts, Documents, Spreadsheets, Presentations, and more. Students learn time saving tips and strategies to get more done at work.

Topics to be covered include: Google Mail; Google Calendar; Using Google Drive: Documents, Spreadsheets, Forms, Presentations; and Google Hangouts, Sites, Search, Chrome.

This is an online course offer in partnership with LERN.

Students learn the capability of Google Drive and its productivity applications and work with Google Apps environment. Students will use Google Apps to create, manage, store, and share various types of files.

Topics to be covered include: navigate Google Apps; store documents using Google Drive; collaborating using Google Docs, Slides, and Drawings; collaborating using google sheets and forms; communicating using Google Hangouts; managing schedules using Google Calendar; collaborating using Google Sites.

Prerequisite: Windows Intro or equivalent knowledge.

Students learn how to develop and manage project plans using Microsoft Project 2010. Students learn how to create and modify task lists, establish a project schedule, create calendars, assign resources to tasks, track costs, and work with different views and tables. Students will also apply filters and groups, and sort task and resource data and learn how to resolve resource conflicts. Students then work with templates, create baseline plans, monitor and update projects, analyze project statistics, handle delays and conflicts, create reports, consolidate project files, share resources, and customize Project.

Topics to be covered include: creating and modifying tasks; task scheduling; resource management; views and tables; filters, groups, and sorting; finalizing the task plan; using templates and importing data; managing a project; analyzing and adjusting the plan; working with reports; customizing Project; managing multiple projects; exchanging project information.

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

Students learn how to create a project plan with Microsoft Project 2013 during the planning phase of a project and then update a project plan during the execution, monitoring, and controlling phases of a project.

Topics to be covered include: starting a project, working with calendars, working with tasks, working with resources, delivering a project plan, managing the project environment, managing task structures, generating views, and producing reports.

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

Students learn the fundamentals of using QuickBooks 2016 to track the finances of a small business.

Topics to be covered include: Getting started with QuickBooks, setting up a company, working with lists, setting up inventory, selling your product, invoicing for services, processing payment, working with bank accounts, and entering and paying bills.

Prerequisite: Windows Introduction or equivalent knowledge.

Students go beyond the fundamentals of using QuickBooks 2016 to track the finances of a small business.

Topics to be covered include: memorizing transactions, customizing forms, using other QuickBooks accounts, creating reports, creating graphs, tracking and paying sales tax, and preparing payroll with QuickBooks.

Prerequisite: QuickBooks 2016 Introduction or equivalent knowledge.