Office Productivity

New Basic Computer Essentials
Feel like you need to know more about computers? This course is the starting point and is targeted to individuals who do not have any background, knowledge, or experience in computers and who need to use personal computers at home or the office. Learn how to use a computer in a fun and relaxed environment. A step-by-step approach will be utilized to cover the Windows operating system, word processing, working with files, Internet and email. This course will provide fundamental computer competencies to survive and prosper in today’s fast-changing world. No previous computer experience necessary.

Business Applications Certificate
This certificate is designed for those who want to become a bookkeeper or for small business owners who would like to understand bookkeeping better. Increase your skills in payroll, Quickbooks, Excel, and tax knowledge to enable you to perform bookkeeping accurately and efficiently. GET A TUITION DISCOUNT WHEN REGISTERING FOR THE ENTIRE SERIES!

Word Basics
In this course, you will gain basic proficiency with Microsoft Word. Discover the best and fastest ways to perform everyday tasks. Learn how to create and edit documents, format characters and paragraphs, create and manage tables, control page layout, work with web features, instant message, and much more. You’ll be able to practice what you learn in this hands-on course. New users of previous Word versions will also benefit. This course is approved for the Business Bookkeeping Certificate and Business Applications Certificate.

Word Intermediate
Topics covered include working with sections and columns, formatting tables, working with Excel data, working with styles, headers and footers, printing labels and envelopes, working with graphics and objects, creating document templates, and managing document revisions. Pre-requisite: Word Basics or equivalent knowledge. This course is approved for the Business Applications Certificate.

Word Advanced
Topics covered in this class include working with forms, working with large documents, creating macros, customizing menus and toolbars, using XML features, and sharing Word documents. Pre-requisite: Word Intermediate or equivalent knowledge. This course is approved for the Business Applications Certificate.

Outlook Basics
Are you overwhelmed by emails, meetings, and to-do lists? In this course, you'll learn how to manage the flood of emails, create folders and archives, keep track of your contacts, and use Outlook's Calendar and Alert features. Find out how to customize Outlook so it perfectly meets your needs, and discover how to automate your work with rules. Whether you're new to Outlook or you've been using it for years, you're sure to learn something useful in every lesson. This course is approved for the Business Applications Certificate.

PowerPoint Basics
PowerPoint is used to create presentations that can combine text, graphics, charts, clip art, and WordArt. These presentations can then be shown at internal business meetings, sales calls, and training events. Additional topics include building new presentations, formatting slides, using drawing tools, working with graphics, using tables and charts, and presentations. Experience with Windows is recommended. New users of previous PowerPoint versions will also benefit. This course is approved for the Business Application Certificate.

Excel Basics
Work with numbers? Then you need to learn Excel. In this class, you will use Excel 2016 and discover dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. You’ll benefit from hands-on activities covering creating and editing workbooks, modifying worksheets, using calculations, formatting worksheets, and managing large workbooks. Experience with Windows is recommended. New users of previous Excel versions will also benefit. This course is approved for the Business Bookkeeping Certificate and Business Applications Certificate.

Excel Intermediate
Continue with your Excel proficiencies by learning the benefits of the more advanced features of Excel 2016. Topics covered include using multiple worksheets and workbooks, customizing Excel, working with functions, list and data analyzing, and management. You will also be working on visualizing data with charts and using PivotTables and PivotCharts. Pre-requisite: Excel Basics or equivalent knowledge. This course is approved for the Business Bookkeeping Certificate and Business Applications Certificate.

Excel Advanced
In Excel 2016 Advanced, students will discover how to forecast data. Learn the advantages of working with multiple worksheets and workbooks in consolidating data and using lookup functions and formula auditing. This class will not only go through the automating workbook functionality but also give you the know how to share and protect workbooks and create Sparkline and mapping data. Pre-requisite: Excel Intermediate or equivalent knowledge. This course is approved for the Business Applications Certificate.

Access Basics
This course will take you from knowing little or nothing about databases and Access to a basic level of understanding. Topics include database concepts, databases and tables, fields and records, data entry rules, simple queries, using forms, creating and modifying reports, and much more. You'll practice what you learn in this hands-on course. This course is approved for the Business Applications Certificate.

Access Intermediate
Topics covered include relational databases, working with related tables, complex queries, advanced form design, advanced reports, charts in forms and reports, PivotTables and PivotCharts, and internet integrations. You'll practice what you learn in this hands-on course. Prior knowledge of Access required. This course is approved for the Business Applications Certificate.

Access Advanced
Students will learn how to: query with SQL; use crosstab, parameter, and action queries; create and run macros; import, export, and link database objects; optimize, replicate, and synchronize databases; and maintain database security. Pre-requisite: Access Intermediate or equivalent knowledge. This course is approved for the Business Applications Certificate.

CompTIA Network + Certification Prep
This course will teach you everything you need to take and pass the CompTIA Network+ certification exam (N10-007). You will learn about the OSI seven-layer model, protocol suites, modern network operating systems, network hardware, cabling standards, remote connectivity, internet connections, cloud computing, network security, network troubleshooting, and more.

Introduction to SQL
In this course, you'll learn about the basic structure of relational databases, how to read and write simple and complex SQL statements, and advanced data manipulation techniques. Discover how to use SQL to filter retrieved data and sort and retrieve data from tables. Learn how to use SQL to create and maintain tables as well as how to create and use views to simplify complex queries, summarize data, and manipulate data stored in tables.

Introduction to PC Troubleshooting
Don't spend your hard-earned cash on expensive PC repairs! The vast majority of the problems people experience with their computers are completely avoidable, and most can be solved with nothing more than a few minutes of your time. Intro to PC Troubleshooting takes you step by step through the typical hardware and operating system problems encountered by technicians, teaching troubleshooting techniques to decipher any problem, and giving you the skills you need to solve them.

New SQL Certificate
Structured Query Language (SQL) is the industry standard database programming language. It is one of the most in demand skills in occupations that require interaction with data and analyzing data. Through your knowledge of Structured Query Language, you will become more marketable in computer related career fields that pertain to database administration. Learning SQL can also lead to a job that is specific to analyzing data such as a data analyst, a quality assurance analyst, or a business analyst. You’ll first learn about relational database structures, the history and uses of Structured Query Language, and how to use Structured Query Language to create a database, add records to database tables, and how to use SQL queries to extract meaningful data from database tables. You will quickly progress from creating simple SQL queries that query a single table to querying multiple tables simultaneously. You’ll also learn how to alter data in a database and how to gather significant statistics from data stored in a database. Finally, you'll learn techniques that will enable you to write powerful queries that perform complicated searches and sorts on your data. This certificate will enhance your competitiveness in the field of database administration and data analyst jobs.