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.

New Microsoft OneNote, OneDrive, and Office Lens
Many Microsoft Office users have used Outlook for years for enhanced productivity and communications, but with the rise of Microsoft 365, they now have a whole new suite of tools than can expand productivity, organization, collaboration, and coordination. Three of the easiest tools to use are OneDrive (and the related OneDriveLive.com), OneNote, and the new Office Lens app for scanning and PDF creation. In this new program by Randy Dean, MBA, The E-mail Sanity Expert ®, he shows you how these natural extensions to your Microsoft Outlook tools can enhance your real-time productivity, increase the productivity of your related smart-phone/tablet devices, and move beyond individual productivity to deeper team productivity and collaboration.

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.

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.

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.

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

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.