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
Getting Started
Accounting Basics
The Chart of Accounts
Centers and Lists
Bank Accounts
Recording Expenses
Paying Bills
Credit Cards and Loans
Recording Income
Invoices and Estimates
Billable Expenses and Customer Credits
Sales Taxes and Reports
24
1
None
None
No
N/A
Hardware requirements:
This course can be taken on either a PC or a Mac.
Software requirements:
PC: Windows 10 or later
Mac: macOS 10.11 or later
Browser: The latest version of Google Chrome or Mozilla Firefox is 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, note that this course is suitable only for the QuickBooks Online version. The desktop versions of QuickBooks are not compatible with the 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 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 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]
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
Excel Charts and Graphs
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, 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.
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. Continue exploring Excel's charting options, looking at the lesser-known options available to you. Even though they aren't well known, these options can add tremendous value to your worksheets in the right situations.
Auto Filter 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. Learn how to use Auto Filter to limit your table information to just the records you want. Not only does it allow for finding exact matches, but it can also filter and sort based on cell shading or font color.
Goal Seeking
Normally, you 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 helps you avoid the trial-and-error approach that most Excel users go through to get to the right answer. Try multiple examples, exploring several ways to apply this great feature.
Pivot Tables
Learn how to use one of the best features of Excel: the PivotTable. There's no greater what-if analysis tool to summarize, reorganize and report data. When you practice creating a PivotTable, you discover how "pivoting" your data helps you gain valuable insights by seeing the same information from a different perspective.
Advanced PivotTables
Just like charting, Excel's PivotTables are too big a topic to fit into one lesson. Take PivotTables to the next level by taking a tour through some of Excel's more advanced techniques. Learn how quick and easy it is to group your data to give your PivotTable even more power. Then, find out how a PivotTable can serve as your source and inspiration for some really nice charts, specifically, the PivotChart. Finally, become an expert in using the Excel PivotTable filtering tool called Slicer.
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. Learn how to use Solver to solve a complex problem based on the criteria and constraints you provide.
Sparklines
There's nothing more exciting than learning how to master a useful and eye-catching feature in Excel. 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 will have the skills to create dashboard-like mini-charts sure to make you the envy of your office.
Macros
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 click of a button.
Introduction to Functions
If you've used Excel for a while, you know there are hundreds of functions at your disposal. Get a quick overview of all the categories of functions and the different methods you can use to create them. Then, ease into creating various functions using some from the Text category.
Math/Trig Functions
Dig a little deeper into using some of the slightly more complex functions in the Math & Trig category. Specifically, look at two popular choices, the SUMIF and COUNTIF functions, and discuss how to use SUMIFs.
VLOOKUP, INDEX and MATCH Functions
Learn how to use the extremely popular VLOOKUP function. Also, use the INDEX and MATCH functions to do something just short of amazing.
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 is 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.
N/A
90% attendance
Students must pass 10 quizzes with a minimum grade of 70% by the second 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 Excel, this course is for you!
N/A
N/A
| Details | Section | Date(s) | Location | Price | Seats | |
|---|---|---|---|---|---|---|
| 328694 | 04/15/26 - 06/05/26 | 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.
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: Microsoft Word Ribbon, Commands and Shortcuts, Creating High-Quality Documents
Day 2: Applying and Saving Templates, Bullet and Numbered Lists, Building Tables
Day 3: Introduction to Worksheets, Create Documents Using Templates
Day 4: 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 calculating and displaying numbers, both personally and professionally
Excel Basics
Develop a solid understanding of the Excel interface. Become fluent in the secret language spoken only by Excel users and discover the best way to correct just about any mistake you might make in Excel. You will find yourself gliding effortlessly from cell to cell, leaving behind expertly written labels, numbers and formulas.
Creating a Worksheet
Learn five simple steps you should always follow to ensure that your worksheets are always well-planned, well-constructed and beautifully formatted.
Time-Savers
Learn the tricks of the Excel masters: a variety of useful shortcuts guaranteed to save you time, energy and frustration. Spend some time working with the Quick Analysis and Flash Fill tools.
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? Learn to write sophisticated formulas that can help ease you through some rather sticky scenarios.
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 learn how to take their worksheets into the third dimension. Prepare to have your socks knocked off as you gain hands-on experience in the construction of three-dimensional workbooks.
Sorting, Subtotaling and Filtering
No Excel course would be complete without a discussion of Excel's amazing data-crunching capabilities. Learn how to build a table in Excel, as well as how to subtotal, sort and filter.
Charting Basics
Explore the exciting world of charts. Build your first graph and learn how easy it is to adjust the chart type, labels, titles, colors and other aspects of your chart.
Advanced Charting Techniques
Dig deep into Excel's charting capabilities. Explore everything from bar charts and line charts to more prosaic graphs like the pie chart and 3D charts. Find out how to personalize your charts with photographs, text labels and drawings. Discover the best ways to format your chart for print or otherwise display them.
Intro to Excel's Statistical Functions
Excel includes many powerful functions that can automatically perform some very complicated tasks for you. Learn some very interesting ways to put these functions to work for you. 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.
Financial Functions
Continue your exploration of Excel functions with an in-depth look at Excel's handy financial functions. Figure out how much money you will have when you retire, when your kids reach college or just before your next vacation. Calculate the monthly payment on just about any type of loan, and figure out how long it will take to pay off your credit cards. You can even create an amortization table of your very own, just like the one lenders use to track a loan's payoff amount over time.
Worksheet Automation
Find out how to automate just about any task you find tedious or time-consuming. Discover how to move your most frequently used commands from their present, obscure locations to a more convenient place: the toolbar that's always perched at the very top of your screen. Learn how you can use macros to reduce just about any complex task to a single keystroke.
Mastering Excel's IF Function
Learn how to use Excel to aid you in making decisions. You can 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
N/A
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 is 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.
N/A
90% attendance
Students must pass 10 quizzes with a minimum grade of 70% by the second 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 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 are 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 calculating and displaying numbers, both personally and professionally
Customizing Excel
Explore different ways you can modify Excel to streamline processes and make your work easier. Use the Excel Options dialog box to customize some of Excel's behind-the-scenes behavior and set up your Quick Access Toolbar.
Table Management
Explores Excel's table management features, using data forms with Excel databases and alternative database techniques. Formatting and working with tables has become much easier in this latest version of Excel.
Data Validation
Tackle data validation techniques, your first line of defense against incorrect or missing data and the logical next step after data forms. Practice using whole number, decimal, date, time, list and other forms of validation.
Custom Controls
Learn custom controls, graphical objects that help facilitate data input and are sure to impress users. Learn how to create standard and drop-down list boxes, check boxes, option buttons and group boxes.
Conditional Formatting
Learn how to use conditional formatting to hide errors, highlight records based on multiple criteria, track and alert you about due dates, find the differences between two lists, shade every other row and more.
Consolidating and Outlining
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 no longer need to develop a web of formula links to multiple sources.
Excel Functions and Nesting
Excel's functions are too numerous to cover in just one lesson, so focus on a few important ones spanning four categories: Logical, Database, Math & Trig and Lookup & Reference.
Import External Data
Learn how to use the built-in Query Editor using Excel's powerful Power Query tool and an import external database that combines two database tables into a single import.
Data Tables
Data tables are very powerful what-if analysis tools that are great for analyzing potential outcomes of personal or business financial decisions. Learn how to use two different types of data tables.
What-If Analysis Tools
Explore three more of Excel's what-if analysis tools: Goal Seek, Scenario Manager and Solver.
Advanced PivotTables
Discover how to use PivotTables, which are excellent for summarizing massive amounts of data and viewing different cuts of the information quickly. Practice using the two methods for creating PivotTables.
Analysis ToolPak, Advanced Filter, Array Formulas and More
Explore the functions available in the Analysis ToolPak, including Moving Average and Sampling tools. 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 is 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.
N/A
90% attendance
Students must pass 10 quizzes with a minimum grade of 70% by the second 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 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.