Computers/IT

Advanced Microsoft Excel 2019

Term: - CRN: - Course Number:

Location: Online Date: Days: Time: Instructor: C. Wambolt

This course will help you master many features in Microsoft Excel 2019 that most users don't know exist. You will learn the secret to using formula-based conditional formatting as a creative solution to common issues. You will also learn how to leverage Excel's Power Query tool to import and transform data from about any data source. By the time you finish this course, you will have mastered Microsoft Excel 2019 and will be able to better serve your company's data management needs.

This is an instructor-led 6-week online course. Lessons are available to view at your convenience. Click the “Register” button below for additional course details.

CPWE

Learn More

Advanced MS Word 2019

Term: - CRN: - Course Number:

Location: Online Date: Days: Time: Instructor: W. Wang

If you create business documents like letters, brochures, or newsletters, you know that their quality is representative of your organization. To create professional-quality documents efficiently and effectively, you have to use advanced word processing functions. This online course will teach you how to use Microsoft Word 2019, the newest version of Microsoft's widely-used word processing software.

Through hands-on lessons and modules, you will learn how to use a number of shortcuts and time-saving techniques to create complex documents. By the end of the course, you will know how to create and organize tables, manipulate graphics, and merge spreadsheets, amongst other functions, to turn Word into a simple desktop publishing tool.

This is an instructor-led 6-week online course. Lessons are available to view at your convenience. Click the “Register” button below for additional course details.

CPWE

Learn More

Keyboarding

Term: - CRN: - Course Number:

Location: Online Date: Days: Time: Instructor: K. Van Pelt

If you want to learn touch-typing or improve your existing typing skills, this is the perfect course for you! In these lessons, you'll use the Keyboarding Pro 5 program, a typing tutorial designed for personal computers, to learn how to touch-type—that is, to type text you read from a printed page or a computer screen without looking at your keyboard.

With the skills you master here, you'll become faster and more confident at the keyboard. By the end of the course, you'll know how to touch-type the alphabetic, numeric, and symbol keys; create, save, and edit word processing documents; and successfully take a timed writing test during a job interview.

This is an instructor-led 6-week online course. Lessons are available to view at your convenience. Click the “Register” button below for additional course details.

CPWE

Learn More

Computer Skills for the Workplace

Term: - CRN: - Course Number:

Location: Online Date: Days: Time: Instructor: D. Paquin

This course is designed to provide the fundamental computer competencies you need to survive and prosper in today's fast-changing workplace. You will learn how to implement the powers of modern office software to work faster and more efficiently. This course will focus on practical application for software most common to the workplace. By the time you finish, you will have learned why employers consider technological literacy so critical to the success of any organization.

This is an instructor-led 6-week online course. Lessons are available to view at your convenience. Click the “Register” button below for additional course details.

CPWE

Learn More

Introduction to Microsoft Excel

Term: - CRN: - Course Number:

Location: Online Date: Days: Time: Instructor: C. Wambolt

If you want to learn the 2019 version of Microsoft Excel, this course will introduce you to the program's basic functions and uses. Through hands-on lessons, you will learn numerous shortcuts to quickly and efficiently set up worksheets. You will also learn how to use the function wizard to calculate statistics, future values and more. In addition, you will get tips on sorting and analyzing data, creating three-dimensional workbooks and automating frequently-repeated tasks with macros and buttons. By the time you're done, you will know how to use this vital Office 2019 tool.

This is an instructor-led 6-week online course. Lessons are available to view at your convenience. Click the “Register” button below for additional course details.

CPWE

Learn More

Microsoft Office 2019 Value Suite

Term: - CRN: - Course Number:

Location: Online Date: Days: Time: Instructor: W. Wang

Each course within the Microsoft Office 2019 Value Suite will introduce you to the basic features and functionality of Microsoft Word, Excel and PowerPoint 2019.

Suite bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Suite bundles.

This is an instructor-led 72 hour online course. Lessons are available to view at your convenience. Click the “Register” button below for additional course details.

CPWE

Learn More

Introduction to Python 3 Programming

Term: - CRN: - Course Number:

Location: Online Date: Days: Time: Instructor: M. Orsega

Create foundational programming structures with Python. This course will provide the fundamentals of computer programming in Python 3 with topics that include basic decisions and loops, advanced data structures, object-oriented programming, and graphical user interfaces.

Whether you're interested in writing simple scripts, full programs, or graphical user interfaces, this course will give you the tools you need to use Python with skill and confidence.

This is an instructor-led 6-week online course. Lessons are available to view at your convenience. Click the “Register” button below for additional course details.

CPWE

Learn More

Introduction to Networking

Term: - CRN: - Course Number:

Location: Online Date: Days: Time: Instructor: D. Mahler

Learn to perform basic computer networking tasks such as DSL connectivity, configuring connections to an ISP and creating a private network. This course explains computer networking basics in easy-to-understand terms, using concepts common to everyday, non-computing experience.

This is an instructor-led 6-week online course. Lessons are available to view at your convenience. Click the “Register” button below for additional course details.

CPWE

Learn More

Introduction to PC Security

Term: - CRN: - Course Number:

Location: Online Date: Days: Time: Instructor: D. Mahler

Learn why you're at risk and what you can do to protect your precious personal and business data from the outside world. In this course, a security expert will teach you the fundamentals of PC and network security as you learn to install and configure a firewall to build an impenetrable moat around your computer or network.

This is an instructor-led 6-week online course. Lessons are available to view at your convenience. Click the “Register” button below for additional course details.

CPWE

Learn More

CompTIA A+ Training Boot Camp

Term: - CRN: - Course Number:

Location: Online Date: Days: Time: Instructor:

Certify your skills and knowledge in data management, analysis, and technologies! This boot camp provides the most comprehensive approach to earning CompTIA's Data+ certification.

This is a self-paced 5-day online course. Lessons are available to view at your convenience. Click the “Register” button below for additional course details.

CPWE

Learn More

CompTIA Network+ Training Boot Camp

Term: - CRN: - Course Number:

Location: Online Date: Days: Time: Instructor:

Certify your skills and knowledge in data management, analysis, and technologies! This boot camp provides the most comprehensive approach to earning CompTIA's Data+ certification.

This is an instructor-led 5-day online course. Lessons are available to view at your convenience. Click the “Register” button below for additional course details.

CPWE

Learn More

CompTIA Security+ Training Boot Camp

Term: - CRN: - Course Number:

Location: Online Date: Days: Time: Instructor:

The CompTIA Security+ Training Boot Camp teaches you information security theory and reinforces that theory with hands-on exercises to help you learn by doing. You will learn how to configure and operate many different technical security controls — and leave prepared to pass your Security+ exam.

This is an instructor-led 5-day online course. Lessons are available to view at your convenience. Click the “Register” button below for additional course details.

CPWE

Learn More

Cybersecurity Boot Camp

Term: - CRN: - Course Number:

Location: Online Date: Days: Time: Instructor:

The Cybersecurity Master Boot Camp is an immersive and accelerated training course with a focus on creating the next generation of cybersecurity professionals.

This is a self-paced 595-hour online course. Lessons are available to view at your convenience. Access is granted for 6 months to complete. Click the “Register” button below for additional course details.

CPWE

Become a Cybersecurity Professional

Across nearly every industry, cybersecurity skills are in demand to ensure the secure handling of data online and protect it from attacks, amongst other essential duties.

This online Cybersecurity Boot Camp is designed to empower the next generation of cybersecurity professionals to tackle advanced and critical threats. No previous experience is needed—just your dedication and eagerness to learn. By the end of your boot camp, you will gain the fundamental skills and knowledge needed to succeed in IT security and earn today’s most sought-after certifications.

“This boot camp removed any doubts I had about my career choice as I was able to solidify that cybersecurity is what I wanted to do for a living. I am grateful to my teachers and the experience the course gave me.” – Samuel Webb.

Enroll Now

Job Outlook for Cybersecurity Professionals

The global market for cybersecurity professionals is expected to grow from $217 million in 2021 to $345 million in 2026, according to market research firm MarketsandMarkets, which means job opportunities are on the rise. The Cybersecurity Boot Camp will prepare you for in-demand job roles like cybersecurity analyst, cybersecurity engineer, penetration tester, vulnerability analyst, digital forensics analyst, and cybercrime investigator.

According to the U.S. Bureau of Labor Statistics (BLS), the median yearly salary for information security analysts was $103,590 in 2020—with this profession expected to grow 33% from 2020 to 2030, which is much faster than the average for all occupations.

What You Will Learn

In our Cybersecurity Boot Camp, you will explore:

• Key concepts of popular communication protocols, the configuration of routers/switches, and TCP/IP implementation
• Fundamentals of data security and auditing
• How to identify, evaluate, and mitigate security risk
• How malicious hackers attack systems and tactics to thwart online attacks
• How disparate components connect to form complex networks
• The role played by cybersecurity analysts and the skills required

Enroll Now

How Boot Camps Work

• Six months of interactive, self-paced training that requires 15 to 25 hours a week to complete the curriculum
• Prepare to pass one of the following certifications: CompTIA A+, Network+, Security+, CySa+, Pentest+, or EC-Council CEH
• Get ten 30-minute online coaching sessions with your instructor
• Complete multiple course projects and a final capstone to help you prepare a professional level portfolio to show prospective employers

Enroll Now

Instructor

 FAQs About Cybersecurity Boot Camp

How will the training sessions be conducted?

Learning is entirely online and self-paced to suit your schedule. You’ll have access to interactive video lessons, labs for real-world practice, discussion boards to engage with peers, and live one-on-one coaching sessions with an industry expert instructor.

How many coaching sessions will there be?

You will have about five coaching sessions that the instructor might schedule for you. In these sessions, you can seek help from your coach for a topic you want assistance in.

Will there by any hands-on loabs during the course?

The Cybersecurity Boot Camp is not just about learning theory. We have designed practical exercises to teach students the concepts of different fundamentals. You will be required to perform those exercises in the class, and the results will be shared with you right away. This course will enable you to learn via exposure to a virtual lab environment, which will help you gain hands-on skills and a deeper understanding of the practical aspects of the course.

Does this course prepare for a certification?

Yes, this boot camp will prepare you to take the following exams:

• CompTIA A+
• CompTIA Network+
• CompTIA Security+
• CompTIA CySA+
• Certified Ethical Hacking
• CompTIA Pentest+

Will there be any projects in the course?

The students will be required to complete multiple projects based on topics they have been studying. Each project will be discussed during the mentoring sessions.

What if I don't have enough time to complete the course within the time frame provided?

If you are unable to complete the course, contact your student advisor to help you work out a suitable completion date. Please note that an extension fee will be charged. If you are funded through a third-party organization, approval may also be required.

What kind of support will I receive?

The course instructor will be available by email to answer any questions you may have and provide feedback on your performance. Occasionally, a team of industry experts may support your course. You will also be assigned a student advisor for academic support.

Registration and Enrollment

This course is a self-paced course that can be completed 100% online. Open enrollment means that you can register and start the course whenever you are ready. Access to your course can take 24-48 business hours.

Enroll Now

Learn More

Microsoft Excel Certification Training (Voucher Included)

Term: - CRN: - Course Number:

Location: Online Date: Days: Time: Instructor: T Berry

Microsoft Excel Certification Training

Become a Microsoft Office Specialist with Excel

Microsoft Excel sets the standard for spreadsheet and data use, respectively. Developing skills and experience with Excel allows you to work independently and solve problems. This 100% online course will teach you the skills you need to work with Excel. Upon successful completion, you will be prepared to take and pass the Microsoft Office Specialist (MOS) Expert certification exam for Microsoft Excel. Enrollment includes optional voucher to cover exam fee.

Enroll Now

Job Outlook for Microsoft Office Specialist with Excel

• Business operations and office support positions are among the fastest-growing career areas in the current economy. From administrative assistants to specialists in business presentations and data analysis, many of today's most promising career areas involve expertise in Microsoft Excel.
• Among the Office and Administrative Support Occupations listed by the US Bureau of Labor Statistics (BLS), those that require MOS skills offer the highest levels of pay and future opportunities. For example, Payroll and Time Keeping Clerks earn an average of $46,180 per year.
• According to PayScale.com, holders of the MOS certification earn an average of $54,000 per year. With skills in a specific domain such as legal or financial, the pay can increase to $67,000 or higher.

Microsoft Office Specialist with Excel FAQs

What differntiates a Microsoft Office Specialist (MOS) from other Office users?

The process and knowledge involved with any MOS certification provides advanced knowledge in the operations and functions of the specific Office Suite product. MOS certificate holders are expected to understand and operate Microsoft Office products at a level of detail that exceeds that of an uncertified peer.

Is certification valuable for Microsoft Excel?

Microsoft reports that 86% of hiring managers prefer candidates with a relevant certification. Earning certification sets you apart as a serious professional who is committed to their work and personal development. It also indicates that you can undertake and complete a challenging course of study.

Do any jobs require MOS Certification?

Many jobs require certification in one or all of the Microsoft Office products. MOS certification may lead directly to job opportunities in training or computer support, for example. Administrative or data-related positions may require certification in Excel.

Is Microsoft Excel Certification good for remote career opportunities?

Because Excel involves data and spreadsheets, it is considered an excellent option for work from home or remote careers. According to ZipRecruiter.com, remote Excel jobs focus on using Microsoft Excel to enter and organize information and create visual representations of data.

Course Objectives

• To create, modify, and manage Excel workbooks
• To use formulas, functions and work with tables
• To use conditional formatting and styles
• To create pivot tables and charts
• To import and export data
• Become a certified Microsoft Office Specialist (MOS) Expert in Excel

Enroll Now

Prerequisites and Requirements

There are no prerequisites to take this course. However, you should be comfortable using a personal computer and be familiar with operating Windows Office software.  

Curriculum

1. Introduction to Microsoft Excel
2. Intermediate Microsoft Excel
3. Advanced Microsoft Excel
4. Microsoft Excel Final Exam

Instructors

Tracy Berry

Tracy Berry has been a senior graphic designer/programmer, instructor, and consultant since 1993 and has developed hundreds of logos, marketing materials, websites, and multimedia solutions for customers worldwide. She was also involved in several large corporate software rollouts. She has helped many organizations optimize and streamline data solutions. She teaches both onsite and online courses and has her CTT (Certified Technical Trainer) certification. Tracy specializes in teaching graphics, desktop publishing, web design, and reporting/productivity applications.

Registration and Enrollment

This course is open enrollment. You can enroll and begin any time.

Enroll Now

CPWE

Learn More