Learn at your own pace and take classes when it's convenient for you! Wake Tech offers dozens of non-degree online courses, in addition to the nearly 100 Wake Tech degree, diploma and certificate programs offered online.

The college also has teamed up with online educational partners Ed2Go and CareerStep, which offer large catalogs of virtual training programs. The training can range from a quick class to learn a new skill to a longer, more in-depth program to earn an industry-recognized credential. Some of these programs are similar to, but unaffiliated with, the programs offered solely by Wake Tech.

Non-degree Online Courses

Introduction to Microsoft Excel 2016

If you work with numbers, you need to master Microsoft Excel 2016! This hands-on course will teach you dozens of shortcuts and tricks for setting up fully-formatted worksheets quickly and efficiently. You will also learn the secrets behind writing powerful mathematical formulas and discover how to use the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more. In addition, you will get tips on sorting and analyzing data, designing custom charts and graphs, creating three-dimensional workbooks, building links between files, endowing your worksheets with decision-making capabilities, and automating frequently-repeated tasks with macros and buttons. You will also learn Excel 2016 features, including Quick Analysis, Flash Fill, and new charting capabilities. This is not a tutorial, but an in-depth class. By the time you're done, you will be using this vital Office 2016 application like a pro.

Course Objectives

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.

Learn how 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.

Study 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.


Outline of instruction

Lesson 1 - Excel Basics
In our first 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 2 - 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 3 - Time-Savers
Our third lesson will teach you the tricks of the Excel masters: a wide variety of useful shortcuts guaranteed to save you time, energy, and frustration. We'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 4 - 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. Today, we focus on writing sophisticated formulas that can help ease us through some rather sticky scenarios.

Lesson 5 - 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. Today, 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 6 - Sorting, Subtotaling, and Filtering
No Excel course would be complete without a discussion of Excel's amazing data-crunching capabilities. Today, you'll not only learn how to build a table in Excel, you'll also learn how to subtotal, sort, and filter.

Lesson 7 - Charting Basics
In this lesson, we'll explore the exciting world of charts. You'll build your first graph today, and you'll learn how easy it is to adjust the chart type, labels, titles, colors, and many other aspects of your chart.

Lesson 8 - Advanced Charting Techniques
Today, 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 3-D 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 9 - Intro to Excel's Statistical Functions
Excel includes many powerful functions that can automatically perform some very complicated tasks for you. In today's 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
We'll continue our exploration of Excel functions with an in-depth look at Excel's handy financial functions today. 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
Students often rank this lesson as one of their favorites. Today, 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
I think you'll be intrigued by our final lesson, in which you'll learn how to use Excel to aid you in decision making. We'll use a special function in Excel that allows it to make comparisons and use those comparisons as the basis for important decisions.


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 must be taken on a PC. It is not suitable for Macs.

Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
Microsoft Office Home and Student 2016 (not included in enrollment).
Note that the "Starter Version" and "Web App" versions of Microsoft Excel will not work with the full version of Excel 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.

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, taught by an experience Microsoft Excel instructor, provides in-depth knowledge for beginners that will have you using Excel like a pro.

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.

PMP/CAPM Exam Preparation

Prepare for the Project Management Institute (PMI) exam for certification as a Project Management Professional, or PMP. Find out how to manage project quality, scope, cost, timeline, and risks and learn about human resources, procurement, integration, communication, professional responsibility, and ethics. Learn best practices for initiating, planning, executing, controlling, and closing a project. This course is applicable for both the Project Management Professional (PMP) and Certified Associate in Project Management (CAPM) certification. All participants must purchase the most current edition of the PMBOK® Guide.

Course Objectives

Upon successful completion, students will have learned an overview of how to manage a project and testing techniques for the PMP or CAPM exam.


Outline of instruction

Introduction to PMP® and CAPM® Certifications

Project Management Essentials

Project Management Knowledge Areas & Processes

Integration Management

Scope Management

Time Management

Cost Management

Quality Management

Human Resource Management

Communications Management

Risk Management

Project Procurement Management

Project Stakeholder Management

Professional and Social Responsibility

Conclusion


Contact Hours

35

CEUs

1

Industry Standard, State or National Certification

Project Management Institute (PMI)

CE or CU Articulation

No

Prerequisites

Experience in project management

Text and Supplies Needed

N/A

Clinical Site/Special Facilities

N/A

Requirements for Successful Completion

90% attendance"Demonstrate an understanding of at least 70% of the course material taught."

Accreditation/Special Approval Requirements

N/A

Intended Audience

Project managers or those aspiring to be project managers.

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

Project Manager

Related Courses

SEF-3001EG1

SEF-3001EZ1


Course Contact Information

Lonette Mims
919-335-1020
[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.

Intermediate Microsoft Excel 2016

Harness the power of Excel and become a master user of this powerful program. You will learn how to create informative, eye-catching charts and graphs, and AutoFilter commands. In addition, you will find out how easy it is to create macros that let you manipulate data with the push of a button. You will also discover how to use Goal Seek and Solver and apply them to real-world problems. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX

Course Objectives

Learn how to create informative, eye-catching charts and graphs, and harness the power of Excel's data analysis tools and AutoFilter commands.

Learn how easy it is to create macros that let you manipulate data with the push of a button.

Discover how to use Goal Seek and Solver and apply them to real-world problems. And you'll set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and Excel's other time-saving functions to your repertoire.


Outline of instruction

Lesson 1 - Excel Charts and Graphs

Lesson 2 - More Excel Charts

Lesson 3 - AutoFilter and Sorting

Lesson 4 - Goal Seeking

Lesson 5 - PivotTables

Lesson 6 - Advanced PivotTables

Lesson 7 - Solver

Lesson 8 - Sparklines

Lesson 9 - Macros

Lesson 10 - Introduction to Functions

Lesson 11 - Math/Trig Functions

Lesson 12 - VLOOKUP, INDEX, and MATCH Functions


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 must be taken on a PC. It is not suitable for Macs.

Software Requirements:
PC: Windows 8 or later.
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
Microsoft Office Home and Student 2016 (not included in enrollment).
Note that the "Starter Version" and "Web App" versions of Microsoft Excel will not work with the full version of Excel 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.

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 hands-on course will provide skills using charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Microsoft Excel 2016 functions.

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.

EPIC 30 Online Teaching Certificate

This 30-hour professional development training concentrates on online pedagogy and universal design for learning (UDL) principles. Courses cover best practices in course navigation and design, online communication and collaboration, online assessments, UDL, pedagogy, andragogy, accessibility, and LMS skills training. The certification culminates with a capstone course that requires mastery-level demonstration of design and delivery skills described in the EPIC Quality eLearning Standard.

Course Objectives

be able to identify, describe, and explain core accessibility concepts and create ,basic accessible documents, presentations, and multimedia, and identify resources to facilitate the creation of accessible course content.


be able explain the principles of Universal Design for Learning Theory (UDL).

be able to recognize the benefits of a standardized course menu and identify how to customize the course menu and course themes.

be able to add course content and manage and organize files in the LMS.

create and manage announcements, create forums and manage discussions, send emails and messages to students within a course, and create groups with collaboration tools.

be able to create, manage, and grade assignments and tests.

organize and manage the an LMS Grade Center at the introductory level, including, recording student grades, weighting grades, running grade reports, and using the various tools available.

identify and explain best practices and strategies in online communication and collaboration, and produce a communicative activity that fosters student engagement.

explain the principles of creating and administering effective assessments in online courses, creating measurable student learning outcomes, and aligning student learning outcomes with lesson objectives, and produce a sample assessment for an online course.

be able to demonstrate the ability to develop quality online courses that meet quality standards for online courses.


Outline of instruction

Introduction to Accessibility

Introduction to Universal Design for Learning

Learning Management System (LMS) Skills Training:
• Course Structure and Navigation
• Managing Instructional Content
• Communication Tools
• Managing Assignments and Tests
• Managing the Grade Center and Student Grading

Best Practices in Course Navigation and Design

Best Practices in Online Communication & Collaboration

Best Practices in Online Assessments

Capstone


Contact Hours

30

CEUs

1

Industry Standard, State or National Certification

None

CE or CU Articulation

No

Prerequisites

None

Text and Supplies Needed

None

Clinical Site/Special Facilities

Online access to Blackboard

Requirements for Successful Completion

attendance"85% Content assessment score"

Accreditation/Special Approval Requirements

N/A

Intended Audience

Online Education and Training

Specific Industry or Business Support Needs

Instructor, Teacher, Educator, Trainer

Wake County Need for Industry Positions

N/A

Industry or Job Titles Related to training Outcomes for Employment

Related Courses

Course Contact Information

Community & Career Education Staff
919-532-5700
[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.

Russian Fundamentals

Learn the Russian language in a fun and friendly course that focuses on practical use. Designed for beginning-level students, the course consists of conversational Russian in daily situations, from common workplace terminology to ordering at restaurants and conversing while shopping or vacationing. Lessons focus on vocabulary development, pronunciation, and Russian culture.

Course Objectives

become familiar with the basics of the Russian language and its syntax.


recognize basic vocabulary and use basic Russian language.

improve efficiency in Russian through Listening, Speaking, Reading, and Writing.

get a basic understanding of Russian culture.


Outline of instruction

Introduction, pronunciation, alphabet

General greetings and introductions, present tense

Gender and naming things, travel

Prepositions, numbers, language and culture

Calendar, time, food, and culture


Contact Hours

15

CEUs

No

Industry Standard, State or National Certification

None

CE or CU Articulation

No

Prerequisites

None

Text and Supplies Needed

None

Clinical Site/Special Facilities

None

Requirements for Successful Completion

90% attendance

Accreditation/Special Approval Requirements

N/A

Intended Audience

General adult.

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

FLI-3701A3

CSP-4000CS3

CSP-4000BE2


Course Contact Information

Community & Career Education Staff
919-532-5700
[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.

Real Estate Provisional Broker (Pre-Licensing)

If you'd like to work in real estate in North Carolina, this course is your first step toward licensure. This pre-licensing course meets NC Real Estate Commission requirements for submitting a provisional broker application to the state. The course introduces students to real estate principles, with a strong emphasis on real estate law and practice.

Course Objectives

Learn the basic knowledge and skills necessary to act as a licensed real estate broker in a manner that protects and serves the public interest and


Prepare for the real estate license examination


Outline of instruction

Course Orientation and Overview

Basic Real Estate Concepts

Property Ownership and Interests

Property Taxation and Assessment

Transfer of Title to Real Property

Land Use Controls

Environmental Issues in Real Estate

Brokerage Relationships: Laws and Practice

Agency Contracts (Sales) and Related Practices

Basic Contract Law

Sales Contracts and Related Procedures

Real Estate Financing

Closing a Sales Transaction

Real Property Valuation

Landlord and Tenant

Property Management

Fair Housing

Federal Income Taxation of Home Ownership/Sale

Basic House Construction

Basic Real Estate Investment

Real Estate License Law and Commission Rules

Agent Safety

Real Estate Mathematics

Review

Final Exam


Contact Hours

90

CEUs

1

Industry Standard, State or National Certification

North Carolina Real Estate Commission

CE or CU Articulation

No

Prerequisites

To help ensure student success, participants who do not have a college degree are encouraged to obtain a Silver Level Career Readiness Certificate before taking this course.

Text and Supplies Needed

For the most up-to-date textbook and technology requirements, please click on the Details button.

Clinical Site/Special Facilities

None

Requirements for Successful Completion

80% attendance"Note especially the requirements for a 75% minimum passing score on the end-of-course examination
"

Accreditation/Special Approval Requirements

N/A

Intended Audience

Individuals seeking Real Estate license.

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

Community & Career Education Staff
919-532-5700
[email protected]

Current Opportunities
Details Section Date(s) Location Price Seats  
312483 06/23/25 - 08/27/25 Northern Wake Campus 198.00 11 Register
312181 07/14/25 - 09/11/25 MS Teams Virtual Learning Platform 198.00 14 Register
312969 08/04/25 - 09/29/25 MS Teams Virtual Learning Platform 198.00 25 Register
312973 08/04/25 - 09/29/25 MS Teams Virtual Learning Platform 198.00 25 Register

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

The Role of Culture in Teaching ESL

Culture has been described by some as the "fifth skill" in language acquisition, equal in importance to reading, writing, speaking, and listening. Helping learners make sense of the culture that is intertwined with language is integral to the role of an ESL instructor. Learn practical techniques and strategies that will enable both you and your students to become effective cross-cultural communicators.

Course Objectives

demonstrate a basic understanding of intercultural communicative competence.

demonstrate a basic understanding of techniques, tools, and strategies for helping ESL students develop intercultural communicative competence.

demonstrate a basic understanding of various approaches to addressing cultural diversity in an ESL classroom.


Outline of instruction

The fundamentals of working with culturally and linguistically diverse student populations.

Understanding the meaning of culture and its impact on individuals and groups.

Techniques and strategies for building cultural awareness and communicative competence with ESL students.

Addressing bias and stereotyping in ourselves and our students.


Contact Hours

20

CEUs

1

Industry Standard, State or National Certification

None

CE or CU Articulation

No

Prerequisites

None

Text and Supplies Needed

Textbooks and supplies needed for this class are subject to change. Please click on the Details button above for the most up-to-date information about materials required for this course.

Clinical Site/Special Facilities

None

Requirements for Successful Completion

90% attendance"Students are expected to participate in all activities.","Course assignments must be turned in on time. No late homework will be accepted unless negotiated in advance with the instructor. ","The final computed score must be 85% or higher in order to pass this class. "

Accreditation/Special Approval Requirements

N/A

Intended Audience

This course is intended for those who would like to obtain the ESL Teaching Certificate at Wake Tech Community College. While this course is designed for educators, it may also be useful for anyone who is interested in learning more about cross-cultural communication.

Specific Industry or Business Support Needs

ESL Instructor

Wake County Need for Industry Positions

ESL Instructor

Industry or Job Titles Related to training Outcomes for Employment

ESL Instructor

Related Courses

EDU-3002C2

EDU-3002F3

EDU-3002F2

EDU-3005C2

EDU-3002Z3


Course Contact Information

Susan Shostak
919-334-1536
[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.

Pen and Ink Drawing Class

Have you ever wondered how to create black and white art? Here's your chance. Explore the timeless art of pen and ink drawing in this captivating class! Unleash your creativity as you delve into the intricate world of line art, shading, stipple, crosshatch, and many more techniques. Whether you're a beginner, or an experienced artist, our expert instructor will guide you through the nuances of this classic medium. Unlock the secrets of this expressive form and watch your artistic skills flourish!

Course Objectives

learn basic drawing skills using pencil and technical drawing pens and apply many techniques from a professional line illustrator.

create their own art.


Outline of instruction

Familiarize yourself with the tools we will need.

Learn basic drawing skills through exercises prepared by instructor.

Create your own masterpiece while being guided by the instructor during each class.


Contact Hours

16

CEUs

No

Industry Standard, State or National Certification

None

CE or CU Articulation

No

Prerequisites

None

Text and Supplies Needed

2 Sheets of Hot Press Illustration Board 15"x20"
1 set of 3 micron pens (1) 01 (2) 03 (3) 05
Pencil, soft lead either 2b or 3b
1 kneaded eraser
Clear plastic triangle (small to medium size) useful but not required
French curves assortment, circle or ellipse are useful but not required
Roll of regular or blue masking tape
A small desk lamp (battery or plug in) is ideal
Small 8"x10" pad of tracing paper

Clinical Site/Special Facilities

None

Requirements for Successful Completion

attendance

Accreditation/Special Approval Requirements

N/A

Intended Audience

Students that would like to learn and practice art and drawing through the use of black ink and white space.

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

CSP-4000AE3

CSP-4000BT3

CSP-74243

CSP-4000LQ2


Course Contact Information

Community & Career Education Staff
919-532-5700
[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.

Data Analytics for Business Professionals

Develop essential data analysis skills that are in high demand by local businesses! With this bundled course, participants will build data literacy and learn how to use business tools, including SQL, Microsoft Excel, Microsoft Power BI, and Tableau for data analysis and visualization. Students will learn how to read, write, and communicate data; understand data sources and constructs and use various analysis methods to inspect, cleanse, and transform data to discover insights, suggest conclusions, and support business decision-making. Upon completion, participants will be prepared to take the Microsoft Excel core certification exam.

Course Objectives

Microsoft Excel Fundamentals:
• Manage worksheets and workbooks
• Manage data cells and ranges
• Manage tables and table data
• Perform operations by using formulas and functions
• Manage charts
• Prepare for the certification exam

Excel Data Analysis:
• Demonstrate basic usage of Excel data analysis techniques
• Explore external databases, PivotTables, and Pivot Charts
• Import and export data using external sources
• Cleanse data
• Analyze data using PivotTables And PivotCharts

SQL:
• Create normalized databases
• Explore how to insert data into tables efficiently
• Use various techniques to retrieve data from multiple tables

Power BI:
• Create effective storytelling reports by implementing simple-to-intermediate Power BI features
• Develop powerful analytical models to extract key insights for changing business needs
• Build, publish, and share impressive dashboards for your organization

Tableau:
• Develop data visualizations to explain complex data with clarity
• Explore Data Model capabilities
• Connect to various data sources
• Leverage Tableau Prep Builder's capabilities for data cleaning and structuring
• Create and use calculations to solve problems and enrich the analytics
• Enable smart decisions with data clustering, distribution, and forecasting
• Share data stories to build a culture of trust and action

Communicating with Data:
• Know the fundamental data skills required to work with data
• Use data visualization to influence change in your organization
• Apply data techniques to effectively work with data end to end
• Communicate data points clearly and persuasively
• Review why different stakeholders have divergent needs and views


Outline of instruction

Microsoft Excel Fundamentals:
1. Manage Worksheets and Workbooks
2. Manage Data Cells and Ranges
3. Manage Tables and Table Data
4. Perform Operations by Using Formulas and Functions
5. Manage Charts
6. Prepare for The Excel Core Certification Exam

Excel Data Analysis:
1. Learning Basic Data-Analysis Techniques
2. Working with Data-Analysis Tools
3. Introducing Excel Tables
4. Data from External Sources
5. Cleaning Data
6. Analyzing Table Data with Functions
7. Creating and Using PivotTables
8. Performing PivotTable Calculations
9. Building PivotCharts
10. Exam Certification Preparation

SQL:
1. SQL Basics
2. Manipulating Data
3. Normalization
4. The SELECT Statement
5. Shaping Data with the WHERE Clause
6. JOINS
7. Subqueries, Cases, and Views
8. SQL Programming
9. Security
10. Aggregate Functions

Power BI:
1. Introduction to Business Intelligence and Power BI
2. Up and Running with Power BI Desktop
3. Connecting and Shaping Data
4. Creating Data Models and Calculations
5. Unlocking Insights
6. Creating the Final Report
7. Publishing and Sharing
8. Using Reports in the Service
9. Understanding Dashboards, Apps, and Security
10. Data Gateways and Refreshing Datasets

Tableau:
1. Taking Off with Tableau
2. Connecting to Data in Tableau
3. Moving Beyond Basic Visualizations
4. Calculations and Parameters
5. Leveraging Level of Detail Calculations
6. Diving Deep with Table Calculations
7. Making Visualizations That Look Great and Work Well
8. Telling a Data Story with Dashboards
9. Visual Analytics - Trends, Clustering, Distributions, and Forecasting

Communicating with Data:
1. Communication
2. Data
3. Visualizing Data
4. Visualizing Data Differently
5. Visual Elements
6. Methods of Communicating with Data
7. Implementation Strategies for Your Workplace
8. Tailoring Your Work to Specific Departments


Contact Hours

120

CEUs

1

Industry Standard, State or National Certification

Microsoft

CE or CU Articulation

No

Prerequisites

Prior to registering for this course, students should have digital literacy, including basic computer skills.

Text and Supplies Needed

N/A

Clinical Site/Special Facilities

None

Requirements for Successful Completion

80% attendance"Actively participate in class, including discussions and independent and group activities. ","Complete assigned labs and projects."

Accreditation/Special Approval Requirements

N/A

Intended Audience

Individuals who want to expand their knowledge and skills for employment-readiness or those who want to successfully prepare for the relevant industry certification exam(s).

Specific Industry or Business Support Needs

Data Analyst, Business Analyst, Business Intelligence Analyst, Management Analyst, Systems Analyst

Wake County Need for Industry Positions

According to Burning Glass Technologies, Wake County has a high demand for data analysis skills.

Industry or Job Titles Related to training Outcomes for Employment

Data Analyst

Business Analyst

Business Intelligence Analyst

Management Analyst

Systems Analyst

Related Courses

Course Contact Information

Andrea Dethmers
9195325736
[email protected]

Current Opportunities
Details Section Date(s) Location Price Seats  
312484 06/09/25 - 10/27/25 MS Teams Virtual Learning Platform 293.00 13 Register

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