Computer Courses

Whether you are considering a job change or need to learn something new in your current role, a short hands-on computer course can be a great way to upskill and advance your career. See also graphic design and web design courses.

Applications

QuickBooks Intro

Learn how to manage your business more effectively with one software package. This class will cover the basics of QuickBooks along with tips to help you become more efficient in your day-to-day functions.

 

QuickBooks Intermediate

In this course, students will expand upon the skills learned in the introductory course and learn more about using QuickBooks to deal with physical inventory and payroll.

 

MS Word Intermediate

Learn how to use mail merge to integrate information from a data source into Word documents to create custom letters, labels, envelopes and more. Add a watermark to a document or use special effects with text. Format pictures with artistic effects and text wrap. Set up headers and footers and become familiar with page numbering options. Learn how to set up columns and control column breaks and paragraph grouping. Use themes and predefined styles or create custom styles to maintain consistent formatting, improve accessibility, and to generate a Table of Contents with ease.

 

MS Word - Advanced

In this course, take a closer look at tracking document changes, working with multiple reviewers, document sharing and access control as well as digital signatures. Explore personalization options to control AutoCorrect and recovery options. Learn how to automate repetitive tasks with macros and make custom keyboard shortcuts. Become familiar with some of the ways MS Word can interact and integrate with other applications in the MS Office suite.

 

MS PowerPoint - Advanced

Learn advanced PowerPoint skills, how to present the story of the data. Review the basics, and also learn design principles, how to create customized presentations, special effects, slide, notes and handout masters.

 

MS Excel Intro

This introductory course in MS Excel spreadsheets covers working with tables and creating and navigating worksheets, including entering, editing and formatting numbers, text, and dates. Learn how to write formulas and use functions for calculations. Create and format charts to visualize data and illustrate trends. Explore sorting and filtering while learning some helpful tools for working with large data sets.

 

MS Excel Intermediate

Apply more advanced workbook formatting using themes and styles, and learn to use custom number formats and conditional formatting. Add subtotals, nested functions, date and time calculations, text modification, and conditional functions to your Excel skillset. Explore the potential of lookup functions and analysis tools.

 

MS Excel Pivot Tables & Charts

The pivot table is one of the most useful spreadsheet tools for analyzing and summarizing data. Explore the visualization possibilities of Excel charts, pivot tables, and pivot charts.

 

MS Excel - Sorting & Filtering

Learn to use sorting and filtering options in MS Excel to rearrange and reorganize data to meet desired criteria without changing and moving it. Become familiar with using sort order to organize data as well as filtering to hide unneeded data.

 

MS Excel: Tips & Tricks

Learn how to work with Excel functions, Smart Tags, column and row adjustments, conditional formatting, rotate text in a cell, freeze and unfreeze cells, color code your worksheet tabs, and more. Review how to enter formulas in Excel and then copy them to another location.

 

MS Excel Financial Functions and What-If

In this fast-paced workshop, learn the basic financial functions frequently used in Excel and how to analyze potential changing circumstances based on altering variable inputs. Will study What-If Analysis tools, such as Scenario Manager, Data Tables, and Goal Seek.

 

MS Excel Advanced

Learn more advanced skills for working with tables and explore options for protecting workbook data. Become familiar with charting, financial functions and what-if analysis tools, scenarios and goal seeking. Create, format, and filter pivot tables to summarize data and create calculated fields.

 

MS Excel VBA Programming

Harnessing the power of VBA in MS Office can make you the MVP at your company! In this course, students will learn how to use macros to automate routine tasks and create custom functions in MS Excel, beginning from simple examples and working up to Visual Basic programming using dialog boxes and control structures.

 

MS Excel VBA Programming 2

With this advanced VBA course you will grow your arsenal of time-saving tricks to become the most essential member of your team! In this course, take a much deeper dive into automating Excel data analysis, with applications in business intelligence, finance and multi-sheet big data extraction.

 

Introduction to Microsoft Access 2019/Office 365

Build, edit, and maintain databases in Microsoft Access 2019/Office 365 using tables, reports, forms, and queries to give you fast access to all your important information. This hands-on course for beginners provides the skills to create an effective database for any type of information at home or on the job. This course is offered through Ed2Go.

 

Intermediate Microsoft Access 2019/Office 365

Develop a fully functional database in this hands-on Microsoft Access 2019/Office 365 course. Master advanced techniques for presenting data, automating common tasks, and building navigation as you work to create a database project from scratch. This course is offered through Ed2Go.

 

Introduction to Microsoft Project 2019/Office 365

Learn to effectively plan, implement, and control projects using Microsoft Project 2019/Office 365. This course will help you master the basics to create and share a project schedule, track costs and resources, produce reports, and resolve problems to keep your projects on track. This course is offered through Ed2Go.

Programming

Java Programming Intro

If you have no prior computer programming experience, this course is for you. Topics covered include variables, data types, arithmetic operations and precedence, string operations, logical operations, loops, comments, operator input and more. You will also learn how to install JDK on Windows and design simple programs. Intermediate-level computer skills needed, but no prior programming experience required.

 

Python Programming Intro

Knowledge of Python can make you a rock star at work and the go-to person whenever a challenging problem arrives. Students will learn how to use the simple but powerful Python programming language to solve everyday problems through the creation of computer programs that automate tedious and sometimes complex tasks. Successful completion results in a digital badge that confirms your achievement.

 

Python Programming Intermediate

Python is a widely used programming language for data analysis and reporting because the language emphasizes productivity and code readability. This class expands concepts that are part of an introductory Python course and emphasizes the creation of scripts to support data analysis procedures and the automation of tasks. Students will learn procedures that can be used to interact with remote (Server) and local databases, efficiently process multiple data files, create supporting data structures, and generate reports in the form of spreadsheets, charts, or maps. During the lectures students will learn class concepts through discussions and in-class exercises that will rely on code templates provided by the instructor to complete data analysis and automation tasks. As part of the class students will have an opportunity to improve their coding skills by practicing debugging, breaking problems into small tasks, and interacting with objects and packages created by other people. Successful completion results in a digital badge that confirms your achievement.

 

Python Programming Advanced

Python Programming Advanced provides participants intermediate/advanced level topics of using the Python programming language. It builds upon the first two courses in the series.

 

HTML and CSS Basics for Web

This course is an introduction to Hypertext Markup Language (HTML5) and Cascading Style Sheets (CSS3), the languages giving structure and style to every website. Students will learn how to write HTML elements and CSS rule-sets, how to use them to build and style web pages, and where to find web-based resources for further learning. Topics include page building blocks, text elements, links, images, color, tables, forms, semantic layout, responsive design and accessibility. Students will build their skills continuously and cumulatively in the course, culminating with a final project of a 4-page basic website.

 

HTML/CSS Advanced

Today’s web designers must be able to work with responsive HTML/CSS frameworks, and Bootstrap is the premier framework at the core of most WordPress themes. This course will prepare you to pursue w3schools.com Bootstrap certification. The certification test, however, is not part of the course or course fee.

Computer-Aided Design

Sketchup Intro

Create three-dimensional models of your designs using the free program SketchUp Make. Topics covered include creating basic geometry, understanding stickiness in SketchUp and how to use it to your advantage, using the drawing tools, creating and working with groups and components, texturing your model, creating scenes, and managing styles. The features and benefits of SketchUp Pro will be introduced along with additional resources for further study. Successful completion results in a digital badge that confirms your achievement.

 

AutoCAD Intro

In this class we will discuss and demonstrate the process of Computer Aided Design using the industry-standard Autodesk AutoCAD. Students learn how to customize the software while incorporating AutoCAD into their design process using graphic standards. Topics include document setup, 2-dimensional drawing, modifications, dimensioning, and document layout for printing.

 

AutoCAD 2021 Certified User

This 100% online AutoCAD 2021 training course will teach you how to create and edit a simple drawing, with a focus on the 2D tools within AutoCAD. Once you master the basic 2D skills, you will move on to explore more advanced efficiency tools, complex objects, using external reference and image files, collaboration tools, publishing, and enhancing productivity with simple customization. The course content is heavily focused on hands-on exercises which require that the software be installed. On course completion, you will meet the requirements needed to take the Autodesk AutoCAD Certified User exam. This course offers enrollment with a voucher. The voucher is pre-paid access to sit for the certifying exam upon eligibility. This course is offered through Ed2Go.

 

AutoCAD 3D 2021

If you know how to use AutoCAD 2D commands, it's time to master the concepts and methods of 3D modeling. This 100% online course will teach you the fundamentals of AutoCAD 3D and explores the main features of the advanced 3D modeling workspace. The course content is heavily focused on hands-on exercises, so you will need to have the software installed on your computer to practice your new skills. All examples and exercises are taken from a variety of fields where AutoCAD is used. This course is offered through Ed2Go.

 

Autodesk Revit Architecture 2021

Autodesk Revit for Architecture is one of the leading Building Information Modeling (BIM) software products for architectural firms. This 100% online course will teach you the fundamentals of Autodesk Revit Architecture software and fully prepare you to pass the Autodesk Revit Certified User for Architecture exam. You will learn how to navigate the interface and use the fundamental design functions available in Revit. The course content is heavily focused on hands-on exercises which require that the software be installed. This course offers enrollment with a voucher. The voucher is pre-paid access to sit for the certifying exam upon eligibility. This course is offered through Ed2Go.

OnBase
class using computers

 

Obtain a Hyland OnBase System Admin certification in two weeks!

OnBase Certified System Administrators (OCSA) are in high demand. If you are interested in technology and the many different opportunities that are available in the Content Services industry, then this is the course for you.

Becoming an OnBase Certified System Administrator can open up new career opportunities for you. This course will train you to effectively use, maintain, administer, and configure business process automation in OnBase, an enterprise information platform for managing content, processes and cases.

Once trained in OnBase, you will have the tools you need to work with organizations to help them use technology to improve their processes. Each student who successfully completes the class will get exclusive access to a virtual career fair hosted by Naviant, connecting them with employers looking for this specific skill set.

Summer 2021 Training Session - Dates Coming Soon!

Registration

Use the course links above to locate an upcoming section and enroll online, or phone (608) 258-2301 menu option 2 for registration assistance.