Skip to main content
Wake Tech Community College
  • Menu
    • Admissions
      • Visit
      • Take Virtual Tour
      • Apply
      • CustomViewbook
      • Financial Aid
      • Registration
      • College Catalog
    • Academics
      • Career Fields
      • Transferring Credits
      • Online Learning
      • HS Dual Enrollment
      • Workforce Training
      • Personal Enrichment
      • GED®/ESL
    • Student Support
      • Advising
      • Career Services
      • Care Center
      • Tutoring
      • Libraries
      • Disability Support
      • Military & Veterans
    • Student Life
      • College Calendar
      • Student Activities
      • Student Government
      • Clubs/Organizations
      • Athletics
      • Food and Vending
      • Bookstore
    • About
      • Locations
      • Administration
      • Academic Divisions
      • News
      • Employment
      • Foundation
      • Contact Us
    • More Info
      • Students
      • Parents
      • Businesses
      • Community
      • Alumni
      • Employees
      • En Español
    • Give
  • Login
  • Search

    Floating-Search

    Search WakeTech:

    Popular Searches

    • Apply to Wake Tech
    • Academic Advising
    • Career Fields
    • Ordering Transcripts
    • Orientation Sessions
    • Workforce Training

Workforce Training

Computer Skills

  • Apply
  • Financial Aid
  • Request Info
  • Search
Links in this section
  • Advanced Manufacturing
  • Biotechnology
  • Business
    • Accounting
    • Animal Care
    • Certified Administrative Professional
    • Certified Administrative Professional with Microsoft Office
    • Certified Bookkeeper
    • Certified Pool Operator
    • Computer Skills
    • Human Resources Certifications
    • Lean Six Sigma
    • Long-Term Care Activity Coordinator
    • Marketing & Social Media
    • Notary Public Certification
    • Paralegal
    • Project Management (PMP)
    • Real Estate
  • Communication, Social Sciences, Art & Humanities
  • Construction & Maintenance
  • Education
  • Engineering
  • Health Care & Wellness
  • Hospitality & Personal Services
  • Information & Digital Technology
  • Public Safety
  • Science & Math
  • Transportation
  • Propel
  • Apprenticeships
  • Non-degree Online Learning
  • Adult Learners
  • Entrepreneurship & Small Business Center
  • En Español
    • Contactos y Preguntas Frecuentes

Wake Tech offers non-degree training to help you quickly learn computer programs used in today's workplaces. The condensed training is taught in one- and two-day classes.

While classes are taught at Wake Tech campuses and centers, we also can develop a course for a specific group and deliver that training at your office or facility.

Financial assistance available

Workforce Development offers financial assistance for many workforce training programs through the Propel program and other resources. Email [email protected] for more information.

Financial Resources and Student Support

Computer Skills Courses

Introduction to QuickBooks Online

  • Course ID: ACC-3150BE
  • Overview
  • Course Outline
  • Requirements
  • Intended Audience
  • More Details
This QuickBooks course will teach you how to manage your business finances with QuickBooks Online. This powerful accounting software has helped millions of small business owners oversee their finances. Now that the cloud-based version is outpacing the desktop version, there's no better time to refresh your QuickBooks knowledge. You will learn to use key features of QuickBooks Online and gain hands-on experience creating invoices, receipts, and statements; track payables, inventory, and receivables; generating reports; and more. Whether you're new to QuickBooks or need a quick refresher, this course will empower you to take control of your business's financial accounting, all with the ease and convenience of an online platform.

Course Objectives

Gain hands-on experience as you learn all the ways this well-designed accounting program makes it a snap to manage your business' finances-from recording income and expenses, to entering checks and bank transfer entries, to setting up a chart of accounts.

Learn how to reconcile your checking account and manage credit card and loan payments; create and print invoices, receipts, and statements; track your payables, inventory, and receivables; create estimates; generate reports.

Learn to manage the financial aspects of your small business quickly and efficiently using QuickBooks Online.


Outline of instruction

Lesson 1 - Getting Started

Lesson 2 - Accounting Basics

Lesson 3 - The Chart of Accounts

Lesson 4 - Centers and Lists

Lesson 5 - Bank Accounts

Lesson 6 - Recording Expenses

Lesson 7 - Paying Bills

Lesson 8 - Credit Cards and Loans

Lesson 9 - Recording Income

Lesson 10 - Invoices and Estimates

Lesson 11 - Billable Expenses and Customer Credits

Lesson 12 - Sales Taxes and Reports


Contact Hours

24

CEUs

1

Industry Standard, State or National Certification

None

CE or CU Articulation

No

Prerequisites

There are no prerequisites to take this course.

Text and Supplies Needed

Hardware Requirements:
This course can be taken on either a PC or Mac.

Software Requirements:
PC: Windows 10 or later.
Mac: macOS 10.11 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
When your course starts, you will be directed to access and utilize the free QuickBooks Online practice site to complete the lesson and assignment steps. You do not need to purchase a subscription or additional software to complete this course. However, please note that this course is suitable only for the QuickBooks Online version. The desktop versions of QuickBooks are not compatible with this course and should not be used. If you have the desktop version, you should consider registering for the course specifically designed for your version.
Adobe Acrobat Reader.
Software must be installed and fully operational before the course begins.

Other:
Email capabilities and access to a personal email account.

Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.

Clinical Site/Special Facilities

None

Requirements for Successful Completion

90% attendance"• Students must successfully pass 10 quizzes with a minimum grade of 70% by the second quiz attempt.
• If all quizzes are not passed with 70 or better by the second attempt, the final exam score must be 70% or higher on the first attempt for successful completion.
• The Final Exam must be taken by the Wake Tech course end date
"

Accreditation/Special Approval Requirements

N/A

Intended Audience

This course is for anyone interested in learning more about Quickbooks Online.

Specific Industry or Business Support Needs

N/A

Wake County Need for Industry Positions

N/A

Industry or Job Titles Related to training Outcomes for Employment

Related Courses

Course Contact Information

Non-Credit Online Learning http://ceonline.waketech.edu
919-532-5847
[email protected]

Current Opportunities
Details Section Date(s) Location Price Seats  
312862 06/11/25 - 08/01/25 Online 77.00 20 Register
312502 08/13/25 - 10/03/25 Online 77.00 19 Register

If you would like to be notified when additional sections become available, please use Wake Tech's Notify Me service.

Introduction to Networking

  • Course ID: NET-3100AE
  • Overview
  • Course Outline
  • Requirements
  • Intended Audience
  • More Details
Businesses, schools, and other organizations rely on computer networks, which explains why employees and contributors with networking skills are in high demand. Are you ready to learn the fundamentals of computer networking in terms you can easily understand? If so, the online Introduction to Networking course will help you understand why networks have become so important, how software and hardware make networking possible, and how networks function. This course will also give you the foundation to understand and get ahead in any career involving the world of computers, networks, the Internet, and the cloud.

Course Objectives

Become capable of performing basic computer networking tasks.

Understand DSL connectivity or configuring connections to an Internet Service Provider.

Gain the foundation you need to begin training for CCNA Certification or employment in a computer networking career.


Outline of instruction

Lesson 1 - History of Networking

Lesson 2 - How Networks Operate

Lesson 3 - Peer-To-Peer Versus Client/Server

Lesson 4 - Network Types and Topologies

Lesson 5 - Segmentation and Routing

Lesson 6 - Protocols

Lesson 7 - TCP/IP

Lesson 8 - Name Resolution and Services

Lesson 9 - Wide Area Networks (WANs)

Lesson 10 - Remote Access

Lesson 11 - Making Internet Connections

Lesson 12 - Review and Conclusion


Contact Hours

24

CEUs

1

Industry Standard, State or National Certification

None

CE or CU Articulation

No

Prerequisites

There are no prerequisites to take this course.

Text and Supplies Needed

Hardware Requirements:
This course can be taken on either a PC or Mac.

Software Requirements:
PC: Windows 10 or later.
Mac: macOS 10.6 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
Adobe Acrobat Reader.
Software must be installed and fully operational before the course begins.

Other:
Email capabilities and access to a personal email account.

Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.

Clinical Site/Special Facilities

None

Requirements for Successful Completion

90% attendance"• Students must successfully pass 10 quizzes with a minimum grade of 70% by the second quiz attempt.
• If all quizzes are not passed with 70 or better by the second attempt, the final exam score must be 70% or higher on the first attempt for successful completion.
• The Final Exam must be taken by the Wake Tech course end date
"

Accreditation/Special Approval Requirements

N/A

Intended Audience

This course is for anyone interested in learning about networking.

Specific Industry or Business Support Needs

N/A

Wake County Need for Industry Positions

N/A

Industry or Job Titles Related to training Outcomes for Employment

Related Courses

Course Contact Information

Non-Credit Online Learning http://ceonline.waketech.edu
919-532-5847
[email protected]

No active courses available at this time.

To be notified when this course becomes available, please use Wake Tech's Notify Me service.

Introduction to Computer (PC) Security

  • Course ID: NET-3100EE
  • Overview
  • Course Outline
  • Requirements
  • Intended Audience
  • More Details
Learn why you're at risk and what you can do to protect your precious personal and business data from the outside world. This course will quickly bring you up to speed on the fundamentals of PC and network security. You will understand and explore the vulnerability of operating systems, software, and networks. Then, you will get into the minds of hackers and crackers, developing an understanding of the exploits they use to access your computer without your knowledge. You will find out why, where and how viruses, worms, and blended threats are created. You will learn a safe way to handle files and data across the Internet through a virtual private network. By the end of this course you will be able to install and configure a firewall to build an impenetrable moat around your computer or network.

Course Objectives

Understand and explore the many vulnerabilities of operating systems, software, and networks.

Learn how to get into the minds of hackers and crackers, developing an understanding of the exploits they use to access your computer without your knowledge.

Learn a safe way to share files and data across the Internet through a virtual private network.


Outline of instruction

Lesson 1 - Introduction to PC Security

Lesson 2 - Your PC and Network

Lesson 3 - PCs, Networks, and Software Demystified

Lesson 4 - Viruses, Worms, Blended Threats, and More

Lesson 5 - The Family of Malware

Lesson 6 - Exploits and Vulnerabilities

Lesson 7 - Network Attacks

Lesson 8 - Everything You Wanted to Know About Firewalls (Part One)

Lesson 9 - Everything You Wanted to Know About Firewalls (Part Two)

Lesson 10 - Laptops, Notebooks, Netbooks, and Wireless Networking

Lesson 11 - Virtual Private Networking (VPN)

Lesson 12 - Changing Face of Security


Contact Hours

24

CEUs

1

Industry Standard, State or National Certification

None

CE or CU Articulation

No

Prerequisites

A familiarity with general computing terminology, an understanding of any operating system you are using (Mac, Windows, or Linux) and an ability to locate programs and change settings.

Text and Supplies Needed

Hardware Requirements:
This course can be taken on either a PC or Mac.

Software Requirements:
PC: Windows 8 or later.
Mac: macOS 10.6 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
Adobe Acrobat Reader.
Software must be installed and fully operational before the course begins.

Other:
Email capabilities and access to a personal email account.

Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.

Clinical Site/Special Facilities

None

Requirements for Successful Completion

90% attendance"• Students must successfully pass 10 quizzes with a minimum grade of 70% by the second quiz attempt.
• If all quizzes are not passed with 70 or better by the second attempt, the final exam score must be 70% or higher on the first attempt for successful completion.
• The Final Exam must be taken by the Wake Tech course end date
"

Accreditation/Special Approval Requirements

N/A

Intended Audience

This course is intended for anyone interested in learning about Computer Security.

Specific Industry or Business Support Needs

N/A

Wake County Need for Industry Positions

N/A

Industry or Job Titles Related to training Outcomes for Employment

Related Courses

Course Contact Information

Non-Credit Online Learning http://ceonline.waketech.edu
919-532-5847
[email protected]

No active courses available at this time.

To be notified when this course becomes available, please use Wake Tech's Notify Me service.

Introduction to InDesign CC

  • Course ID: SGR-3100FE
  • Overview
  • Course Outline
  • Requirements
  • Intended Audience
  • More Details
Have you ever seen a terrific-looking brochure or newsletter and wondered how it was made? Chances are the designer used Adobe InDesign CC, the industry-standard desktop publishing software now available through the Creative Cloud. In each lesson, you will learn an important aspect of InDesign CC and prepare a range of print and online products for a fictional company. You will get dozens of files to work with, including a partially completed InDesign document used to start each lesson. Then you will use the downloaded graphics, images, fonts, and other content to complete the project. To check your work or troubleshoot any problems you encounter, you will always get a copy of the finished InDesign project file.
Lesson by lesson, you will discover how the program features relate to producing actual usable documents. You will explore the best ways to create different types of material, how to reuse items such as colors and artwork, and how to produce publications for different page sizes and devices. You will come away knowing how to use this popular page layout software to design and create professional-quality letterhead, business cards, brochures, forms, interactive PDF files, an eBook, and more.

Course Objectives

Discover how the program features relate to producing actual usable documents as we explore the best ways to create different types of material, how to reuse items such as colors and artwork.

Learn how to use this popular page layout software to design and create professional-quality letterhead, business cards, brochures, forms, interactive PDF files, an eBook, and more.

Learn how to produce publications for different page sizes and devices.


Outline of instruction

Lesson 1 - Introduction to InDesign CC
Wouldn't it be terrific if you could use one program to create all the different types of print materials you need for your small business, organization, or family-such as letterhead, forms, and even brochures and business cards? Well, you can! We'll spend this first lesson going over all the different types of content you can produce with InDesign. We'll explore the InDesign workspace and tools, and then we'll get right to work on our first project-a logo for the fictional business we'll create materials for throughout this course!

Lesson 2 - Setting Up a New Document
Today, you'll learn all about starting and saving a new document. What's one of the most common types of print documents? If you said, "letterhead," you'd be right and well on your way into this lesson's project. By the end of the session, you'll know how to choose settings for a new file, add background images, and organize your content to create a custom letterhead. You'll also add a second page to create a matching envelope, and you'll learn how to add a custom Master page for the envelope. And as in all of our lessons, we'll go over how to use the specific colors, styles, and logo for our fictional business, but you'll be able to use the same techniques for your personal business or projects.

Lesson 3 - Organizing Objects on a Layout
Organization is a key ingredient in successful work of any kind, and it's critical to successfully using InDesign. In this lesson, you'll learn about organizing in two ways. First, you'll see how to use a workflow, or an order of operations for creating an InDesign publication. Then we'll go over how to organize materials on a page and how to use many of InDesign's tools for aligning, organizing, and laying out your content. In the process, we'll complete three projects: a sheet of address stickers, a sheet of business cards, and a reusable business card template.

Lesson 4 - Setting Up a Multipage Document
Many of your projects will use multiple pages with different layouts. Designing a catalog layout is the perfect way to learn these skills, and that's what we'll focus on today. We'll work with two different column layouts while exploring other InDesign features (like grids and document coordinates) that can help you lay out a page evenly. We'll also go over using graphic and text frame placeholders so you don't have to add content to the page to see its layout. For a final touch of realism, we'll use placeholder text during the design process to give you a good idea of how a page will look when you're finished. You'll see how to add a graphic into an existing frame and make it fit, as well as how to add content instantly using a file called a snippet.

Lesson 5 - Creating a Tri-Fold Brochure
Managing text in precise and interesting ways is one of the big advantages of working with InDesign rather than a word-processing program. In this lesson, we'll begin a two-page brochure project that will take us two lessons to complete. In this first part, you'll learn different methods for adding text to your publication. Once the text is in place, you'll see how to check your text for typos and errors. We'll go over how to work with text in simple text frames and how to design threaded text (where the text slides through linked text frames on the page yet stays within the defined structure). We'll also use the Story Editor as an alternative to adding content in a layout view. You'll finish the lesson working with two columns in a single frame, and you'll see how to balance the content and auto-size the frame.

Lesson 6 - Creating a Book
The two key elements in any print project are, of course, text and images. We went over text in our last lesson, so today, we'll finish up our two-page brochure project by going over just about everything you need to know about working with images-adding them to the page in different ways, adjusting their positions, and using various commands for coordinating their sizes, proportions, and frames. We'll begin by adding images to the brochure project pages we worked on in Lesson 5, and then we'll check out some special ways to add batches of images at once to make an image collage and to place images in interesting frames. Speaking of interesting-you'll also see how you can use InDesign transparency effects to add pizzazz to any project. You'll wind up the lesson making a printable photo cube from a template.

Lesson 7 - Managing and Applying Color
You might be surprised to learn that InDesign provides you with some of the same sophisticated drawing tools that you'll find in Adobe Illustrator. For example, InDesign offers the Pathfinder tool, which is the perfect tool to use if you need to combine simply drawn shapes and convert them into more complex and interesting objects. In this lesson, you'll learn how to work with some of the drawing tools to design a poster for a fashion show. You'll see how to draw several simple shapes and stack them using blend modes for interesting effects. One of the topics we'll go over is a text wrap, which is a special way to work with a drawing to tell InDesign where you want your text to display on your page. If you've ever wondered how to make text follow the shape of an object, curving around it on the page, our practice today will solve the mystery!

Lesson 8 - Designing Tables and Creating Forms
Did you know that your eyes can see over 16 million different colors? It's true! Fortunately, you don't have to work with that many colors in InDesign. But if you ever find yourself trying to choose between thousands and thousands of color possibilities, you'll understand why InDesign offers you so many different ways to work with your choices. In this lesson, you'll learn the best methods for choosing, naming, and organizing colors. You'll practice working with solid colors as well as gradients (which let you display a range of color within an object), and we'll round out the lesson by using some more special effects in today's fun project-a greeting card.

Lesson 9 - Creating an Interactive Document
When you need to display bits of information in your publication and want to ensure it's easy to read, it's time to use a table. InDesign offers you lots of tools for designing and formatting tables while helping you make sure your content will coordinate with other documents. You'll see how this works today as we practice building tables for an invoice. You'll also find out how to use color tints in your table, as well as how to use styles to quickly and consistently reuse any of your layout features. Finally, we'll experiment with an interactive PDF form. You'll add some fields to a blank form, see how to configure a text field or button, and produce the PDF form.

Lesson 10 - Storing Text and Color Information
Recycling doesn't just apply to items in your home or business. In this lesson, you'll see how to use the 3R's of recycling in InDesign to complete a newsletter project. As you recycle and modify colors and styles from previous lessons to create new styles in your newsletter, you'll also reuse a lot of the tools and skills you've used in previous lessons. Learning to effectively use all of InDesign's tools and features in a variety of different ways on many different projects is what it's all about!

Lesson 11 - Creating EPUB documents and eBooks
In this lesson, you'll work with text and images from Alice in Wonderland to build an EPUB. You'll learn a lot about what does and doesn't work in an EPUB document, and work with best practices for producing different types of EPUB documents. You'll learn how to create two types of eBooks, a book that will reflow to the size of the device it is viewed on, and a book with a fixed layout, that is sized for a specific device such as an iPad, or other tablet. You'll learn how to place images so they stay put when viewed on a device.

Lesson 12 - Creating and Distributing a Complex Document
Whether you're designing publications for business, hobbies, or social or community activities, odds are you'll need to share them at some point. InDesign provides many options for exporting and reusing a document, as well as printing. We'll review a few of them in this lesson as we design a postcard using special fonts, colors, and image layout features. Have you ever seen text that shows an image of some sort through the letters and wondered how it's done? You'll know after completing the project in this lesson! By the time you finish this lesson, you'll know how to export a publication as an image, print directly from your desktop, or create a compact PDF version of your finished publication ready to email.


Contact Hours

24

CEUs

1

Industry Standard, State or National Certification

None

CE or CU Articulation

No

Prerequisites

There are no prerequisites to take this course.

Text and Supplies Needed

Hardware Requirements:
This course can be taken on either a PC or Mac.

Software Requirements:
PC: Windows 8 or later.
Mac: macOS 10.7 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
Adobe InDesign CS6 (Windows), Adobe CS6 Design and Web Premium (Windows), Adobe CS6 Master Collection (Windows), InDesign CS6 (Mac), Adobe CS6 Design and Web Premium (Mac), Adobe CS6 Master Collection (Mac), or Adobe InDesign CC Student or Retail versions (Mac or Windows). Older versions of Adobe InDesign are also applicable, including all versions of Adobe InDesign CS5 and CS4 (not included in enrollment).
Adobe Acrobat Reader.
Software must be installed and fully operational before the course begins.

Other:
Email capabilities and access to a personal email account.

Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online.

Clinical Site/Special Facilities

None

Requirements for Successful Completion

90% attendance"• Students must successfully pass 10 quizzes with a minimum grade of 70% by the second quiz attempt.
• If all quizzes are not passed with 70 or better by the second attempt, the final exam score must be 70% or higher on the first attempt for successful completion.
• The Final Exam must be taken by the Wake Tech course end date
"

Accreditation/Special Approval Requirements

N/A

Intended Audience

Learn how to use Adobe InDesign CC software to create professional-quality letterhead, brochures, forms, eBooks, business materials and more. This course uses hands-on exercises and expert instruction to help you discover how the program features relate to producing actual usable documents.

Specific Industry or Business Support Needs

N/A

Wake County Need for Industry Positions

N/A

Industry or Job Titles Related to training Outcomes for Employment

Related Courses

Course Contact Information

Non-Credit Online Learning http://ceonline.waketech.edu
919-532-5847
[email protected]

Current Opportunities
Details Section Date(s) Location Price Seats  
312731 06/11/25 - 08/01/25 Online 77.00 20 Register

If you would like to be notified when additional sections become available, please use Wake Tech's Notify Me service.

Intermediate Microsoft Excel 2019

  • Course ID: OST-3100ADE
  • Overview
  • Course Outline
  • Requirements
  • Intended Audience
  • More Details
Many businesses rely on spreadsheets to manage budgets, schedules, and tracking. Microsoft Excel is considered the industry standard for spreadsheets. If you use Excel regularly and want to learn more advanced functions in this powerful software, this course is for you. You will learn how to harness the power of Excel's data analysis tools and AutoFilter commands and how to create macros that eliminate repetitive tasks. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and other intermediate functions to your professional skill set. In addition, you will learn to create macros that let you manipulate data with the push of a button. You'll also discover how to use Goal Seek and Solver and apply them to real-world problems.

Course Objectives

Become a more productive member of your organization.


Build an indispensable skill set.


Learn to fully harness the power of Microsoft Excel 2019.


Outline of instruction

Lesson 01 - Excel Charts and Graphs

In this first lesson, you'll discover why Excel is such a powerful and user-friendly charting tool. To you, a workbook's numbers might tell an interesting story. But to others, that story might not be quite so obvious-they might just see plain old numbers. So, in this lesson, you'll find out how to choose the right chart for telling your story and then how to create, format, and edit your chart to help others clearly visualize that story.

Lesson 02 - More Excel Charts

With so many great charting features and enhancements in Excel 2019, there's no way you could study them all in a single lesson. So, in this lesson, you'll continue exploring Excel's charting options-this time looking at the lesser-known options that are available to you. Even though they aren't well-known, these options can add tremendous value to your worksheets in the right situations. The lesson will walk you through a few of them step-by-step so that you can see the value for yourself.

Lesson 03 - AutoFilter and Sorting

Working with data in Excel can be quite easy-and sometimes even fun-when you know about the extra tools that are available once you have your data arranged in a table format. One of these great tools is the Auto Filter command. In this lesson, you'll learn how to use Auto Filter to limit your table information to just the records you want. Not only does Auto Filter allow for finding exact matches, but it can also filter and sort based on cell shading or font color. How great is that?

Lesson 04 - Goal Seeking

Normally, you'll use your Excel workbooks as a place to enter formulas and get answers. But what if the formula isn't returning the answer you want? If you know what you want, but you just don't know what formula will get you there, then Excel's Goal Seek is exactly what you need. This tool will help you avoid the trial-and-error approach that most Excel users go through to get to the right answer. You'll go through multiple examples, exploring several ways to apply this great feature.

Lesson 05 - Pivot Tables

You'll learn how to use one of the best features of Excel: the PivotTable. If you've heard about PivotTables before, then you'll know what to expect. There's no greater what-if analysis tool to summarize, reorganize, and report data. When you practice creating a PivotTable, you'll discover how "pivoting" your data helps you gain valuable insights by seeing the same information from a different perspective. This is a lesson you won't want to miss!

Lesson 06 - Advanced PivotTables

Just like charting, Excel's PivotTables are too big a topic to fit into one lesson. So, in this lesson, you'll take PivotTables to the next level by taking a tour through some of Excel's more advanced techniques. You'll learn how quick and easy it is to group your data to give your PivotTable even more power. Then, you'll find out how a PivotTable can serve as your source and inspiration for some really nice charts, specifically, the PivotChart. Last, you'll become an expert in using the Excel PivotTable filtering tool called Slicer.

Lesson 07 - Solver

Have you ever worked with a financial model in Excel and wondered how you could speculate different outcomes by changing different input amounts? The Excel Solver can do just that. In this lesson, you'll learn how to use Solver to solve a complex problem based on the criteria and constraints you provide it. If you liked the Goal Seek lesson, then this Solver lesson is going to knock your socks off.

Lesson 08 - Sparklines

There's nothing more exciting than learning how to master a useful and eye-catching feature in Excel. In this lesson, you'll explore in detail how to create all three types of Sparklines, as well as formatting options for each. By the end of the lesson, you'll have the skills to create dashboard-like mini charts sure to make you the envy of your office. If you enjoy creating charts, you'll really enjoy this lesson.

Lesson 09 - Macros

This topic is a student favorite. In this lesson, you'll find out how to use macros to turn boring, repetitive, time-consuming tasks into automated Excel functions. Tired of doing the same formatting on the same report month after month? Here's your chance to see how to record a macro that performs that time-consuming task in seconds with just one swift click of a button! How will you spend all the extra time that this lesson will save you?

Lesson 10 - Introduction to Functions

If you've used Excel for a while, you know there are hundreds of functions at your disposal. You'll spend the last three lessons of this course going over exactly how and why you'd use them. The lesson will begin by going through a quick overview of all the categories of functions and the different methods you can use to create them. Then, later in the lesson, you'll ease into creating various functions using some from the Text category.

Lesson 11 - Math/Trig Functions

In addition to learning how to create macros, most students want to learn as much as they can about Excel functions. In this lesson, you'll dig a little deeper into using some of the slightly more complex functions in the Math & Trig category. Specifically, you'll look at two popular choices, the SUMIF and COUNTIF functions, and discuss how to use one of the more complex functions, SUMIFS. If one of your objectives in taking this course is to learn more about functions, you're in for a treat!

Lesson 12 - VLOOKUP, INDEX, and MATCH Functions

Since functions are such an important and integral part of using Excel, you'll spend the final lesson going over a few more of them. You'll learn how to use the extremely popular VLOOKUP function. If you're already accustomed to using VLOOKUP, don't feel short-changed, because this lesson will add to the complexity. You'll also use the INDEX and MATCH functions to do something just short of amazing. This is another lesson you won't want to miss!


Contact Hours

24

CEUs

No

Industry Standard, State or National Certification

None

CE or CU Articulation

No

Prerequisites

Introduction to Microsoft Excel 2019/365 if needed.

Text and Supplies Needed

Hardware Requirements:
This course must be taken on a PC. It is not suitable for Macs or Chromebooks.

Software Requirements:
PC: Windows 10 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
Microsoft Excel 2019 (desktop version), available with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment).
Adobe Acrobat Reader.
Software must be installed and fully operational before the course begins.

Other:
Email capabilities and access to a personal email account.

Instructional Material Requirements:
The instructional materials required for this course are included in enrollment and will be available online

Clinical Site/Special Facilities

None

Requirements for Successful Completion

90% attendance"• Students must successfully pass 10 quizzes with a minimum grade of 70% by the second quiz attempt.
• If all quizzes are not passed with 70 or better by the second attempt, the final exam score must be 70% or higher on the first attempt for successful completion.
• The Final Exam must be taken by the Wake Tech course end date."

Accreditation/Special Approval Requirements

N/A

Intended Audience

If you want to learn the 2019 version of Microsoft Excel, this course is for you!

Specific Industry or Business Support Needs

N/A

Wake County Need for Industry Positions

N/A

Industry or Job Titles Related to training Outcomes for Employment

Related Courses

Course Contact Information

Courtney Boney
919-532-5581
[email protected]

Current Opportunities
Details Section Date(s) Location Price Seats  
312711 06/11/25 - 08/01/25 Online 77.00 16 Register

If you would like to be notified when additional sections become available, please use Wake Tech's Notify Me service.

Professional Bookkeeping with QuickBooks Online (Voucher Included)

  • Course ID: SEF-3001CHG
  • Overview
  • Course Outline
  • Requirements
  • Intended Audience
  • More Details
Master QuickBooks Online to prepare for a rewarding career in the booking field. You will learn basic bookkeeping and accounting principles, including the types of accounting information you, the business owner, manager, bookkeeper, or accountant, need to monitor. You'll then put all those principles into practice using QuickBooks Online to enter and track your finances with ease. With this online version, you get all the advantages of computing in the cloud so that your files will be available to you virtually anytime, anywhere. This course will give you hands-on experience using QuickBooks Online to manage your business' finances-from recording income and expenses to entering checks and bank transfers to setting up a chart of accounts. You'll see how to reconcile your checking account and manage credit card and loan payments; create and print invoices, receipts, and statements; track your payables, inventory, and receivables; create estimates; generate reports; and much more. Once you complete this course, you will understand how to get your finances in order and be prepared for the QuickBooks Certified User Exam. This course offers enrollment with or without a voucher. The voucher is prepaid access to sit for the QuickBooks Certified User Exam upon eligibility. Proctor fees may apply, which are not included. Disclaimer: To qualify for the externship applications process, students must successfully complete the online course content and have account balances up to date (at a minimum). Going through the externship application process does not guarantee an externship. COVID may be affecting the externship process or site availability in your area. Students can begin researching the steps of the application process 2 weeks prior to completing courses.

Course Objectives

Gain confidence in your ability to use QuickBooks to perform bookkeeping tasks for any company.


Use basic, intermediate, and advanced features of QuickBooks Online proficiently.


Prepare for the QBCU Exam.


Outline of instruction

Introduction to Bookkeeping

Accounting Basics

Getting Started With QuickBooks Online

The Chart of Accounts

Centers and Lists

Bank Accounts

Recording Expenses and Paying Bills

Credit Cards and Loans

Sales Receipts

Invoices, Estimates, and Customizing Sales Forms

Billable Expenses and Customer Credits

Sales Taxes and Reports

Midterm Exam

Product and Service Items

Managing Inventory

Managing Projects and Sales

Progress Invoicing, Late Fees, and Bad Debts

Payroll

Fixed Assets and Loans

Business Entities and Owner Transactions

Banking Rules, Receipts, and Budgets

Adjusting and Reviewing the Books

Starting a Bookkeeping Business

Your Career Roadmap: The Job Search and Future Opportunities (Optional Lesson)

Communication and Organization (Optional Lesson)

Final Exam


Contact Hours

100

CEUs

No

Industry Standard, State or National Certification

None

CE or CU Articulation

No

Prerequisites

This program is designed to prepare you for an entry-level position as a full-charge bookkeeper. You do not need any prior experience or training in this field.

Text and Supplies Needed

Hardware Requirements:
This course can be taken on either a PC or Mac.

Software Requirements:
PC: Windows 10 or later.
Mac: macOS 10.6 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge and Safari are also compatible.
QuickBooks Online (Free 1-year subscription and practice site included in enrollment.) An additional subscription or software purchase for QuickBooks Online is not required to complete this course. However, please note that this course is only suitable for the QuickBooks Online version.
Adobe Acrobat Reader.
Microsoft Word or equivalent.
Software must be installed and fully operational before the course begins.

Other:
Email capabilities and access to a personal email account.

Instructional Material Requirements:
The instructional materials required for this course are included in enrollment. The following textbooks will be shipped to you approximately 7-10 business days after enrollment:
Bookkeeping for Dummies, 2nd Edition
QuickBooks Online software
Your enrollment in this course includes a free 1-year full subscription to QuickBooks Online. You will learn how to access and activate this subscription in one of your assignments.
Please Note: You will receive a digital book if the physical book is on backorder.

Clinical Site/Special Facilities

None

Requirements for Successful Completion

90% attendance

Accreditation/Special Approval Requirements

N/A

Intended Audience

This course is intended for anyone interested in Professional Bookkeeping with Quickbooks Online.

Specific Industry or Business Support Needs

N/A

Wake County Need for Industry Positions

N/A

Industry or Job Titles Related to training Outcomes for Employment

Related Courses

Course Contact Information

Courtney Boney
919-532-5581
[email protected]

Current Opportunities
Details Section Date(s) Location Price Seats  
310954 04/15/25 - 10/15/25 Online 2393.00 19 Register

If you would like to be notified when additional sections become available, please use Wake Tech's Notify Me service.

Less More
Wake Tech Community College

2023 Footer Column 1

  • Campus Links
    • Answer Center
    • College Calendar
    • Get Emergency Alerts
    • Jobs
    • Maps / Directions
    • Accessibility

2023 Footer Column 2

  • Wake Tech Mobile App
    • Android
    • Apple
  • Help & Support
    • College Police
    • Services Directory
    • Student Support

2023 Footer Column 3

  • Connect
    • Wake Tech Enews
    • Wake Tech Podcast
Facebook Instagram X Social media account YouTube LinkedIn Threads TikTok
9101 Fayetteville Road, Raleigh, NC 27603
919-866-5000
Translation
Wake Tech Community College | ©2025 All Rights Reserved.
Contact Us | Terms of Use | Privacy Policy | Campus Policies | Site Map