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.
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.
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
24
1
None
None
No
There are no prerequisites to take this course.
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.
None
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
N/A
This course is for anyone interested in learning more about Quickbooks Online.
N/A
N/A
Non-Credit Online Learning https://ceonline.waketech.edu
919-532-5847
[email protected]
| Details | Section | Date(s) | Location | Price | Seats | |
|---|---|---|---|---|---|---|
| 327379 | 03/18/26 - 05/08/26 | 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.
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.
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
24
1
None
None
No
There are no prerequisites to take this course.
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.
None
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
N/A
This course is for anyone interested in learning about networking.
N/A
N/A
Non-Credit Online Learning https://ceonline.waketech.edu
919-532-5847
[email protected]
To be notified when this course becomes available, please use
Wake Tech's Notify Me service.
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.
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
24
1
None
None
No
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.
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.
None
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
N/A
This course is intended for anyone interested in learning about Computer Security.
N/A
N/A
Non-Credit Online Learning https://ceonline.waketech.edu
919-532-5847
[email protected]
To be notified when this course becomes available, please use
Wake Tech's Notify Me service.
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.
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.
24
1
None
None
No
There are no prerequisites to take this course.
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.
None
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
N/A
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.
N/A
N/A
Non-Credit Online Learning https://ceonline.waketech.edu
919-532-5847
[email protected]
To be notified when this course becomes available, please use
Wake Tech's Notify Me service.
Gain in-demand Visual Basic skills
Explore enriched GUI and multiple form applications
Deepen knowledge of databases with data-bound controls, ADO.NET and SQL
OpenFileDialog and SaveFileDialog Classes
Most Visual Basic programs are all about data based on the things that people do. Whether it's the books they buy, the stores where they shop or the restaurants where they eat, data like that is stored in a file on the computer's hard drive, and these programs enable users to locate and save changes to that data. Learn how to use the OpenFileDialog and SaveFileDialog classes to give your programs this functionality.
Menus
Menus inform you of your choices, such as whether to open, print or save a document. Discover how to use menus in your programs.
Toolbars
Learn how to use toolbars in your applications and how to coordinate them with menus to enhance your application both visually and functionally
Dialog Forms
While the main form in your program may be the star, as your applications become more sophisticated, you will need other, helper forms. Discover an important type of helper form: the dialog form.
Owned Forms and Property Procedures
Learn about another important helper form and how to use it in your application: the modeless, or owned form
Multiple Document Interface (MDI) Applications
You probably take for granted that, while you're typing text in Microsoft Word, you can also have other documents open. This function, called Multiple Document Interface, allows you to go back and forth between documents without having to close any. Learn how to add MDI ability to your programs.
Introduction to Databases
Explore the world of databases, which help make sense of data and do useful things with it.
Introduction to Structured Query Language (SQL)
Databases use a language called Structured Query Language, better known by the abbreviation SQL. Learn how to use SQL in your Visual Basic applications to communicate with your database.
Introduction to ADO.NET
Programming is about writing code, so learn how to write code to access a database.
Database Schema
The structure of a database is called a schema. Learn how to access this structure by code.
Master-Detail Tables
Learn how to create master-detail tables that enable users to quickly drill down into databases to find the data they need.
Where Do I Go From Here?
24
1
None
None
No
Completion of Introduction to Visual Basic 2008 (or equivalent experience).
Hardware requirements:
This course must be taken on a PC. Macs are not compatible.
Software requirements:
Windows 8 or newer
Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge is also compatible.
Visual Basic 2008, free Express edition
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.
N/A
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. The final exam must be taken by the Wake Tech course end date.
N/A
This course is for Visual Basic Programmers with an interest of going beyond the introductory level to create sophisticated and powerful programs for business users.
N/A
N/A
Non-Credit Online Learning https://ceonline.waketech.edu
919-532-5847
[email protected]
To be notified when this course becomes available, please use
Wake Tech's Notify Me service.
Become a more productive member of your organization.
Build an indispensable skill set.
Learn to fully harness the power of Microsoft Excel 2019.
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!
24
No
None
None
No
Introduction to Microsoft Excel 2019/365 if 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
None
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.
N/A
If you want to learn the 2019 version of Microsoft Excel, this course is for you!
N/A
N/A
| Details | Section | Date(s) | Location | Price | Seats | |
|---|---|---|---|---|---|---|
| 327852 | 03/18/26 - 05/08/26 | 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.
Master PowerPoint skills that help you produce better presentations
Become an integral company team member with professional presentation design skills
Gain skills that transfer to any organization and look great on your resume
The PowerPoint 2019 Interface
Explores the basic features of Microsoft PowerPoint 2019, such as the Ribbon, and learn how to start the PowerPoint program and plan a presentation. Practice working with different views, task panes, tabs and templates.
Creating Presentations
Create a presentation from scratch by choosing a theme and creating slides with a variety of slide layouts. Explore the Live Preview feature and learn how to save a file for future use. Create and edit slides in Slide Pane and Outline view. Explore ways to play a slideshow.
Working With Files and Creating and Editing Tables
Including tables in your presentation lets you present a lot of information in a compact space. Learn to add, revise and format tables, as well as multiple ways to open a presentation. Find how to preserve different versions of your work by saving with new file names.
Creating Professional Presentations
Explore the Spelling, AutoCorrect, Thesaurus and Smart Lookup features. Learn to print your presentation as slides, an outline, handouts or notes pages.
Working With the Images Group
Learn how to embellish your slides with media images, including online pictures, icons, 3D models and photographs, as well as how to download an image from a website and insert the image on a slide.
WordArt and the Illustrations Group
Get instructions for using WordArt, Shapes, Icons, 3D Models and SmartArt Graphics. Learn how to transform text into colorful WordArt objects and add Icons and 3D Models. Practice drawing and filling shapes with color and special effects. Learn to group and edit the objects you create and add visual sophistication to your text with SmartArt Graphics.
All About Charts
Create a chart to illustrate statistical data. Explore chart components and learn how to add and edit specific chart elements. Discover how to change the look of your chart by using the options on the Chart Tools contextual tab and the chart-formatting buttons.
Making Global Changes to a Presentation
Learn how to make global changes to slides, handouts and notes and to modify your presentation's background or theme colors.
Creating Links
Enliven your presentation as you create links from text or objects to other slides, presentations, documents and webpages, and add sounds and 3D effects if desired. Learn a Zoom feature that sets up presenter-driven links between slides in a presentation.
Applying Animation to Slides, Text and Objects
Explores slide transitions and the Transition tab options. Apply animation to text and slide objects and use the Animations tab to add animation to slide or layout masters. Find out how to add sound effects, such as a chime or coin sound, to slide transitions.
Adding Advanced Animation Effects to Text and Objects
Using the Animation Pane, add and reorder animated text and objects on slides. Discover how to apply advanced animation effects to text and objects on slides and slide and layout masters, as well as adding an audio clip to your presentation.
Sharing and Saving Your Presentations
Learn different ways to save and share a presentation. Practice converting a presentation into a PDF file, so it's accessible on computers without PowerPoint 2019. Learn to open, edit and share your presentation online with PowerPoint Online and a Windows OneDrive account, as well as how to transform your presentation into a video.
24
No
None
None
No
N/A
Hardware requirements:
This course must be taken on a PC. Macs are not compatible.
Software requirements:
PC: Windows 10 or later
Browser: The latest version of Google Chrome or Mozilla Firefox is preferred. Microsoft Edge is also compatible.
Microsoft PowerPoint 2019 (desktop version) available to download 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.
N/A
90% attendance
Students must 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. The final exam must be taken by the Wake Tech course end date.
N/A
If you want to learn the 2019 version of Microsoft PowerPoint, this course is for you!
N/A
N/A
To be notified when this course becomes available, please use
Wake Tech's Notify Me service.
Introduction to Microsoft Word
Gain a working knowledge on using Microsoft Word
Perform basic functions while editing documents
Practice creating bullet or numbered lists
Gain an understanding of table building
Learn to import graphics and pictures
Design documents using templates
Create professional looking documents
Complete assigned lab exercises
Day 1 (two hours)
- Microsoft Word Ribbon
- Commands and Shortcuts
- Creating High-Quality Documents
Day 2 (two hours)
- Applying and Saving Templates
- Bullet and Numbered Lists
- Building Tables
Day 3 (two hours)
- Introduction to Worksheets
- Create Documents Using Templates
Day 4 (two hours)
- Inserting Clip Art and Pictures
- Changing Saved Documents
- Lab Exercises
8
No
None
None
No
Computer 101 class or have equivalent Microsoft Windows 7/10 hands-on and keyboard skills
Handouts
Computer lab or student access to the required Microsoft Office Suite
95% attendance
N/A
Students interested in learning the details about word processing and Microsoft Word.
N/A
N/A
Community & Career Education Staff
919-532-5700
[email protected]
To be notified when this course becomes available, please use
Wake Tech's Notify Me service.
Know how to use Excel 2019 to make you a more productive member of your organization.
Gain indispensable skills that will be useful for numbers-based reporting.
Develop skills that can be used to simplify your life of calculating and displaying numbers both personally and professionally.
Lesson 01 - Excel Basics
In this lesson, you'll develop a solid understanding of the Excel interface. You'll become fluent in the secret language spoken only by Excel users, you'll discover the best way to correct just about any mistake you might make in Excel, and you'll find yourself gliding effortlessly from cell to cell, leaving behind expertly written labels, numbers, and formulas.
Lesson 02 - Creating a Worksheet
In this lesson, you'll learn five simple steps you should always follow to ensure that your worksheets are always well-planned, well-constructed, and beautifully formatted.
Lesson 03 - Time-Savers
This lesson will teach you the tricks of the Excel masters: a wide variety of useful shortcuts guaranteed to save you time, energy, and frustration. You'll also spend some time working with the Quick Analysis and Flash Fill tools. By the time you finish this lesson, you'll really start to feel like an Excel pro.
Lesson 04 - Relative, Absolute, Mixed, and Circular References
Do you know the difference between a relative reference, an absolute reference, a mixed reference, and a circular reference? You will after this lesson. In this lesson, you'll learn to write sophisticated formulas that can help ease you through some rather sticky scenarios.
Lesson 05 - Three-Dimensional Workbooks
With enough practice, most Excel users quickly become adept at organizing their worksheets across two dimensions: rows and columns. But only a select few will learn how to take their worksheets into the third dimension. In this lesson, you'll join that exclusive group. Prepare to have your socks knocked off as you gain hands-on experience in the construction of three-dimensional workbooks.
Lesson 06 - Sorting, Subtotaling, and Filtering
No Excel course would be complete without a discussion of Excel's amazing data-crunching capabilities. In this lesson, you'll learn how to build a table in Excel as well as how to subtotal, sort, and filter.
Lesson 07 - Charting Basics
In this lesson, you'll explore the exciting world of charts. You'll build your first graph and learn how easy it is to adjust the chart type, labels, titles, colors, and other aspects of your chart.
Lesson 08 - Advanced Charting Techniques
In this lesson, you'll dig deep into Excel's charting capabilities. You'll explore everything from bar charts and line charts to more prosaic graphs like the pie chart and 3D charts. You'll find out how to personalize your charts with photographs, text labels, and drawings. You'll also discover the best ways to format your chart for print or otherwise display the truly impressive charts that you'll be creating.
Lesson 09 - Intro to Excel's Statistical Functions
Excel includes many powerful functions that can automatically perform some very complicated tasks for you. In this lesson, you'll learn some very interesting ways to put these functions to work for you. You'll find out how to ask Excel to magically derive averages, modes, maximums, minimums, and other useful statistics from nothing more than a column or two of numbers.
Lesson 10 - Financial Functions
You'll continue your exploration of Excel functions with an in-depth look at Excel's handy financial functions. By the time this lesson is over, you'll be able to figure out how much money you'll have when you retire, when your kids reach college, or just before your next vacation. You'll be able to calculate the monthly payment on just about any type of loan, and you'll know how to figure out how long it will take to pay off your credit cards. You'll even create an amortization table of your very own, just like the one lenders use to track a loan's payoff amount over time.
Lesson 11 - Worksheet Automation
In this lesson, you'll find out how to automate just about any task you find tedious or time-consuming. You'll discover how to move your most frequently used commands from their present, obscure locations to a much more convenient place: the toolbar that's always perched at the very top of your screen. You'll also learn how you can use macros to reduce just about any complex task to a single keystroke.
Lesson 12 - Mastering Excel's IF Function
You'll be intrigued by the final lesson, in which you'll learn how to use Excel to aid you in decision making. You'll use a special function in Excel that allows it to make comparisons and use those comparisons as the basis for important decisions.
24
No
None
None
No
None
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 to download with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment).
Note: The "Starter Version" and "Web App" versions of Microsoft will not work with the full version taught in this course.
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.
None
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
N/A
If you want to learn the 2019 version of Microsoft Excel, this course is for you!
N/A
N/A
To be notified when this course becomes available, please use
Wake Tech's Notify Me service.
Master Excel 2019 and become a more productive member of your organization.
Gain indispensable skills that will be useful in any organization that relies on numbers-based reporting.
Learn to use the power of Microsoft Excel 2019 to save time, money and frustration.
Develop skills that can be used to simplify your life of calculating and displaying numbers both personally and professionally.
Lesson 01 - Customizing Excel
To kick things off, your first lesson explores different ways you can modify Excel to streamline processes and make your work easier. You will use the Excel Options dialog box to customize some of Excel's behind-the-scenes behavior and set up your Quick Access Toolbar.
Lesson 02 - Table Management
This lesson explores Excel's table management features, using data forms with Excel databases, and alternative database techniques. You'll be glad to know that formatting and working with tables has become much easier in this latest version of Excel.
Lesson 03 - Data Validation
In this lesson, you will tackle data validation techniques-your first line of defense against incorrect or missing data and the logical next step after data forms. You will practice using whole number, decimal, date, time, list, and other forms of validation.
Lesson 04 - Custom Controls
This lesson will introduce you to custom controls-graphical objects that help facilitate data input and are sure to impress users. You will learn how to create standard and drop-down list boxes, check boxes, option buttons, and group boxes.
Lesson 05 - Conditional Formatting
This lesson will teach you how to use conditional formatting. You will learn how to use conditional formatting to hide errors, to highlight records based on multiple criteria, to track and alert you about due dates, to find the differences between two lists, to shade every other row, and more.
Lesson 06 - Consolidating and Outlining
In this lesson, you will learn how to use Excel's consolidation function to efficiently summarize data from multiple sources. Many Excel users do this the hard way, but with Excel's automatic consolidation feature, you will no longer need to develop a web of formula links to multiple sources.
Lesson 07 - Excel Functions and Nesting
Excel's functions are too numerous to cover in just one lesson, so this lesson focuses on a few important ones spanning four categories: Logical, Database, Math & Trig, and Lookup & Reference.
Lesson 08 - Import External Data
This lesson focuses on importing external data. You will learn how to use the built-in Query Editor using Excel's powerful Power Query tool and import external database that combines two database tables into a single import.
Lesson 09 - Data Tables
Data tables are very powerful what-if analysis tools that are great for analyzing potential outcomes of personal or business financial decisions. In this lesson, you will learn how to use two different types of data tables.
Lesson 10 - What-If Analysis Tools
This lesson explores three more of Excel's what-if analysis tools: Goal Seek, Scenario Manager, and Solver.
Lesson 11 - Advanced PivotTables
In this lesson, you will discover how to use PivotTables, which are excellent for summarizing massive amounts of data and viewing different cuts of the information quickly. There are two methods for creating PivotTables, and you will practice using both.
Lesson 12 - Analysis ToolPak, Advanced Filter, Array Formulas, and More!
Your final lesson with a look at the functions available in the Analysis ToolPak, including Moving Average and Sampling tools. You will learn how to use the View Side by Side tool and how to use the Watch Window to keep tabs on your data when you're updating a workbook.
24
No
None
None
No
Intermediate Microsoft Excel 2019/Office 365 if 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 to download with the desktop version of Microsoft 365, or Microsoft Office Home and Student 2019 (not included in enrollment)
Note: The "Starter Version" and "Web App" versions of Microsoft will not work with the full version taught in this course.
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.
None
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.
N/A
If you want to learn the 2019 version of Microsoft Excel, this course is for you!
N/A
N/A
To be notified when this course becomes available, please use
Wake Tech's Notify Me service.