Microsoft Office Classes

Software Applications

We offer three levels of Excel training to help you get your data in a row.

Microsoft Office

Our rotating course offerings include:

* Designates upcoming class dates listed

Prerequisite: Basic Computer Class (OFFT-3502) or equivalent experience

After an introduction to spreadsheet terminology and Excel’s window components, you will learn how to use the Help system, navigate worksheets and workbooks, enter and edit text, values, formulas, and pictures, and save workbooks in various formats and much more.

Prerequisite: Excel Basic or equivalent experience

Learn how to work with large worksheets and use
multiple worksheets and workbooks efficiently. Discover advanced formatting techniques such as applying special number formats and using workbook styles and themes. In addition, you will learn how to create outlines and subtotals and how to create and apply cell names. You will sort and filter data and create and format tables and much more.

Prerequisite: Excel Intermediate or equivalent experience

You will build on the skills acquired in the basic and intermediate courses. You will work with advanced functions and formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. Learn about data validation and how to use advanced data filtering. You will apply advanced chart formatting options and create more complex charts and much more.

Prerequisite: Basic Computer Class (OFFT-3502) or equivalent experience

This software is designed to help you move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make your work easy and even fun. In this course you’ll learn how to create and edit simple documents, format documents, add tables and lists, add design elements and layout options, and proof documents.

Course Offerings

Check back soon.

Prerequisite: Word Basic or equivalent experience

You will work with features such as formats, styles and templates to create professional documents with a consistent look and feel. You will add visual interest to your documents by using the tables and charts features. Quick Parts and templates provide efficiency and consistency when adding content, and long complex documents can be simplified and managed in Master Documents. Finally, you will use the mail merge feature to automate sending individual letters to customers.

Course Offerings

Check back soon.

This course provides an introduction to Power Automate and Power Automate Desktop, offering participants the ability to streamline repetitive tasks with little or no programming experience. Students will learn to build automated workflows and exercise light computational logic in a user-friendly environment. This program enables non-coders to create customized solutions to enhance efficiency, optimize processes, and increase productivity through automation.

This course is designed to help you master Microsoft® Teams®, the key communications tool in the suite of Microsoft® 365® productivity apps. Microsoft Teams enables individuals and organizations to chat, share ideas, collaborate on files, and essentially, work together. You can use Teams to have a quick chat with a colleague, participate in a virtual meeting, make an online call, and share files and resources.

Get started with OneDrive for Business, the cloud-based file management system included with Microsoft Office. Covering both the desktop client app and the browser version, this course shows how to upload, share, copy, delete, and download files and folders, integrate with Office 365 Online and working on files simultaneously with coworkers.

Adobe

Our rotating course offerings include:

* Designates upcoming class dates listed

Prerequisite: Word Basic or equivalent experience

Learning the ins and outs of Adobe Acrobat DC Pro will simplify your life! Learn how to create Adobe PDF files, create Adobe PDFs from Microsoft Office files, and combine files in PDF portfolios. Almost any document, text file, file created in a page layout application, scanned document, Web page, or digital photo can be converted to Adobe PDF using Acrobat software. Learn the best way to create a PDF for specific situations.

Prerequisite: Introduction to Photoshop CC (GDMA‑3620)

With Adobe Lightroom, you have all the tools you need to bring out the best in your photography. Learn how to use the library module for importing, viewing, ranking, and rating photographs. Once photographs have been imported and tagged, learn about the Develop module and practice making one-click enhancements, correcting exposure, retouching distractions, and performing localized adjustments. Photos are taken to be shared with family, friends, and colleagues. Course also includes an introduction to creating panoramas, books, slideshows, and custom print layouts.

Prerequisite: Windows Operating System experience and knowledge of Adobe CC software

This class introduces the fundamentals of InDesign CC. It focuses on the core features of InDesign, including introducing the workspace, panels, document creation, working with pages, importing graphics, importing and editing text, and working with color.

While taught in a Windows environment, the skills learned in this class are easily transferred to a Macintosh environment.

Course Offerings

Check back soon.

Prerequisite: Basic Computer Class (OFFT-3502) or equivalent experience and knowledge of Adobe CC software

Learn to master the fundamentals of Adobe Illustrator. There will be plenty of hands-on learning by creating vector graphics and using the software tools. This class is for the beginner or anyone looking to brush up on their skills.

Prerequisite: Experience navigating in Mac or PC environments

Ready to get up close and personal with the top choice of professional editors, designers and photographers to create powerful images? Whether you’ve tooled around in Photoshop just a bit or have never even opened the application, this is the class for you. We’ll learn about contrast, saturation, color correction, making selections, working with layers, blend modes, and adding text.

While taught in a Windows environment, the skills learned in this class are easily transferred to a Macintosh environment.

Prerequisite: Experience navigating in Mac or PC environment

This class introduces the fundamentals of Adobe Premier Pro Creative Cloud. It will focus on key skills to take a project from the beginning to end, including the basics on things like organizing media, using audio, creating transitions, producing titles, and adding effects.

QuickBooks

Our rotating course offerings include:

* Designates upcoming class dates listed

Prerequisite: Microsoft Windows experience

Learn how to use the basic features and functions of QuickBooks Pro software. You will create a company, set up preferences, set up and invoice customers, manage vendors and pay bills, work with banking transactions (deposits, transfer funds, etc.), perform reconciliations, and review basic financial and other system reports. This basic course does not configure or customize the software for your business.

Prerequisite: QuickBooks: Basic or equivalent experience

Expand your understanding of QuickBooks Pro through learning how to manage inventory, set up and manage sales taxes, prepare estimates, perform job costing, work with Balance Sheet accounts, set up budgets, process payroll and related reporting, and advanced customization options. A portion of this course allows for discussion and/or tailoring of software for your organization’s needs.

Prerequisite: Microsoft Windows experience

Learn about the features of QuickBooks online and how these can be used to manage the accounting for your small business or organization. You will learn how to navigate the application, set up a company file, set up and invoice customers, manage vendors and pay bills, work with banking and credit card transactions, and utilize reports from the system.

Part 1 will get you started on QuickBooks Online. Part 2 will bring it all together and help you fine tune QuickBooks online to your business needs.

This course is taught by a CPA and is intended for business owners, managers and others looking to gain a basic understanding of accounting used in small businesses or organizations. We will explore the various types of business entities, basic business registration and compliance requirements, general bookkeeping and accounting concepts, components of financial statements, budgeting and basic income tax accounting.

Online Learning Opportunities

If you’re interested in increasing your financial awareness while also gaining a marketable skill, this series of courses is perfect for you. You will learn the basics of double-entry bookkeeping, while also learning how to analyze and record financial transactions, as well as prepare various financial reports at the end of the fiscal period.

For details or to register visit: www.ed2go.com/sccne.

Small business owners should be using QuickBooks to manage invoices, pay bills and track expenses. If you want to take control of your business’s finances, this course will introduce you to QuickBooks 2019 and teach you the accounting software’s more advanced features.

For details or to register: www.ed2go.com/sccne.

 

Business & Professional Development Schedule