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.
Students will be able to understand and use the features built into the modern digital camera. Students will be able to analyze their photos and improve them by use of fundamental professional techniques.
1) The Camera Settings
a) aperture
b)shutter and speed
c)ISO settings
d) relationships between settings
2) Basic Exposure and Camera Light Meter
a) shutter vs aperture priority
b) freezing action
c) controlling depth
3) Quality of Light
a) side and back lighting
b) white balance
c) outdoor conditions
d) affect of background
4) Bracketing exposures
a) metering techniques
b) student questions
5) Composition
a) framing the image
b) selecting your lens
c) flashes
d) soft lighting
6) Outdoor techniques
a) nighttime, sunrise and sunsets
b) timed exposures
c) wildlife and scenic techniques
d) use of multiple flashes
7) Field Trip
8) Student Presentations
24
1
None
None
No
None
Digital SLR Camera
Off site classes will be held for field experience
90% attendance
N/A
Anyone interested in improving their basic photography skills and how to take advantage of the features built into their digital camera.
N/A
N/A
CSP-4000FH3
PHO-3001C2
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.
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.
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.
24
1
None
None
No
There are no prerequisites to take this course.
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.
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, taught by an experience Microsoft Excel instructor, provides in-depth knowledge for beginners that will have you using Excel like a pro.
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.
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.
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
24
1
None
None
No
There are no prerequisites to take this course.
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.
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 hands-on course will provide skills using charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Microsoft Excel 2016 functions.
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.
Students will be able to introduce themselves and others using common greetings and expressions.
Students will be able to hear, understand, and respond to expressions used to talk about schedules and days of the week.
Students will be able to demonstrate an understanding to the fundamentals of Spanish pronunciation including vowel sounds and sounds that are unique to Spanish.
Chapter 1: fotonovela, cultura, estructura, adelante
i. Greetings
ii. Identifying
iii. Expressions
Chapter 2: fotonovela, cultura, estructura, adelante
i. Academic Life
ii. Fields of Study
iii. Days of the week
iv. Class schedules
24
1
None
None
No
None.
Please click on the Details button to see the most up-to-date information regarding textbook and technology requirements.
None.
90% attendance
N/A
Adults ready to learn Spanish through grammar, vocabulary, culture, and communicative exercises.
N/A
N/A
FLI-3717AT2
FLI-3717AX2
FLI-3717AW2
FLI-3717AV2
FLI-3701D2
Community & Career Education Staff
919-532-5700
[email protected]
| Details | Section | Date(s) | Location | Price | Seats | 312783 | 07/07/25 - 08/25/25 | MS Teams Virtual Learning Platform | 77.00 | 12 | Register |
|---|
If you would like to be notified when additional sections become available, please use Wake Tech's Notify Me service.
continue to learn the language and gain exposure to the culture
be able to identify and apply basic grammar concepts, display cultural awareness, and communicate simple Spanish phrases.
Chapter 3: fotonovela, cultura, estructura, adelante
i. family
ii. Identifying people
iii. Professions
Chapter 4 - fotonovela, cultura, estructura, adelante
i. Past-times
ii. Sports
iii. Places in the city
Chapter 5 - fotonovela, cultura, estructura, adelante
i. Travel and Vacation
ii. Months
iii. Seasons and Weather
iv. Ordinal Numbers
Chapter 6- fotonovela, cultura, estructura, adelante
i. Clothing and Shopping
ii. Negotiating price and buying
iii. Colors
iv. More adjectives
45
1
None
None
No
Essential Spanish 1 or equivalent experience (semester of beginner level Spanish)
Please click on the Details button to see the most up-to-date information about textbook and technology requirements.
None
90% attendance
Completion of Homework
N/A
This course is intended for anyone who would like to achieve a functional fluency in the Spanish language.
N/A
N/A
FLI-3717AU2
FLI-3717AX2
FLI-3717AW2
FLI-3717Q2
FLI-3701D2
Community & Career Education Staff
919-532-5700
[email protected]
If you would like to be notified when additional sections become available, please use Wake Tech's Notify Me service.
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.
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
30
1
None
None
No
None
None
Online access to Blackboard
attendance85% Content assessment score
N/A
Online Education and Training
Instructor, Teacher, Educator, Trainer
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.
increase their vocabulary through thematic lists.
improve listening comprehension skills so that they can understand information conveyed in simple, sentence-length speech on familiar or everyday topics.
generally be able to comprehend one utterance at a time while engaged in face-to-face conversations or in routine listening tasks such as understanding highly contextualized messages, straightforward announcements, or simple instructions and directions.
improve their oral communication skills so that they gain the ability to create with the language when talking about familiar topics related to their daily life.
be able to recombine learned material in order to express personal meaning and can handle a straightforward survival situation for travel or work.
be able to produce sentence-level language, ranging from discrete sentences to strings of sentences, in the present, past and future tenses.
Chapter 1A (2 classes): La Moda - Fashion and its influence on society, past tense narration.
Chapter 1B (2 classes): Los Autos - Automobiles, driving, and getting around, narrating using both past tenses together, understanding preterite and imperfect.
Chapter 2A (3 classes): El Medio Ambiente - The environment, conversation, and the natural world, using ser, estar, and haber correctly.
Chapter 2B (2 classes): El Futuro del Planeta - The future of our planet and our way of life, using the future tense to express what will happen and to discuss conjecture.
Chapter 3A (2 classes): Los Derechos Humanos - Human rights in the first world and in the Spanish-speaking world, foreign policy, using the subjunctive to will others to action, indirect commands.
Review (1 class): Students review topics covered previously and wrap up the semester.
35
1
None
None
No
Students should have a solid understanding and working knowledge of basic grammar and vocabulary. This course is designed for students who have already participated successfully in Spanish conversation either in a classroom environment or in social/daily-life settings.
Please click on the Details button to see the most up-to-date textbook and technology requirements for this course.
None.
90% attendance
N/A
This course is designed for students whose level of Spanish speaking and listening is clearly beyond the basic level. Students enrolling in this course should already have a solid foundation of basic grammar and vocabulary as well as experience with conversation Spanish either in a classroom or social/daily-life settings.
N/A
N/A
FLI-3717AU2
FLI-3717AT2
FLI-3717AX2
FLI-3717AW2
FLI-3717AV2
FLI-3717Q2
FLI-3717P2
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.
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.
Introduction, pronunciation, alphabet
General greetings and introductions, present tense
Gender and naming things, travel
Prepositions, numbers, language and culture
Calendar, time, food, and culture
15
No
None
None
No
None
None
None
90% attendance
N/A
General adult.
N/A
N/A
FLI-3701A3
CSP-4000CS3
CSP-4000BE2
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.
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
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
90
1
North Carolina Real Estate Commission
Students who successfully complete this course will qualify to apply to the NCREC to take the state exam for official licensure.
No
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.
For the most up-to-date textbook and technology requirements, please click on the Details button.
None
80% attendance
Note especially the requirements for a 75% minimum passing score on the end-of-course examination
N/A
Individuals seeking Real Estate license.
N/A
N/A
Community & Career Education Staff
919-532-5700
[email protected]
| Details | Section | Date(s) | Location | Price | Seats | 312181 | 07/14/25 - 09/11/25 | MS Teams Virtual Learning Platform | 198.00 | 1 | Register |
|---|---|---|---|---|---|---|
| 312973 | 08/04/25 - 09/29/25 | MS Teams Virtual Learning Platform | 198.00 | 20 | Register | |
| 312969 | 08/04/25 - 09/29/25 | MS Teams Virtual Learning Platform | 198.00 | 17 | Register | |
| 316685 | 08/20/25 - 10/27/25 | MS Teams Virtual Learning Platform | 198.00 | 25 | Register | |
| 316695 | 08/20/25 - 10/27/25 | MS Teams Virtual Learning Platform | 198.00 | 24 | Register | |
| 313175 | 09/15/25 - 11/24/25 | Northern Wake Campus | 198.00 | 25 | Register | |
| 316459 | 09/15/25 - 11/12/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.
make use of advanced grammar and vocabulary to communicate both orally and in writing about a wide variety of topics such as business, travel, daily life, health, etc.
demonstrate a fundamental understanding of the culture of Latinx people and the places where Spanish is spoken.
Nouns and articles
Numbers 0-30
Present tense of ser
Telling time
Greetings and leave-takings
Identifying yourself and others
Expressions of courtesy
Greetings and Kissing in Hispanic countries
Present tense of -ar verbs
Forming questions in Spanish
Present tense of estar
Numbers 31 and higher
Fields of study and academic Life
Days of the Week
Class Schedules
Choosing a career
Descriptive adjectives
Possessive adjectives
Present tense of -er and -ir verbs
Present tense of tener and venir
The family
Identifying people
Professions and Occupations
What's your name?
Present tense of ir
Stem-changing verbs: e >ie, o>ue
Stem-changing verbs: e > i
Verbs with irregular yo forms
Pastimes
Sports
Places in the city
Real Madrid and Barca, the rivalry.
Estar with conditions and emotions
The present progressive
Ser and estar
Direct object nouns and pronouns
Travel and vacation
Months of the year
Seasons and weather
Ordinal numbers
Iguazu Falls
Saber and conocer
Indirect object pronouns
Preterite tense of regular verbs
Demonstrative adjectives and pronouns
Clothing and shopping
Negotiating a price and buying
Colors
More adjectives
Outdoor Markets
Reflexive verbs
Indefinite and negative words
Preterite of ser and ir
Verbs like gustar
Daily routine
Personal hygiene
Time expressions
La siesta
Preterite of stem-changing verbs
Double object pronouns
Comparisons
Superlatives
Food
Food descriptions
Meals
Fruits and Vegatables
Irregular preterites
Verbs that change meaning in the preterite
¿Qué? and ¿Cuál? (What and Which)
Pronouns after prepositions
Parties and celebrations
Personal relationships
Stages of life
Semana Santa (Easter)-holiday and tradition
The imperfect tense
The preterite and the imperfect
Constructions with se
Adverbs
Health and medical terms
Parts of the body
Symptoms and medical conditions
Health professions
Health Services
Familiar commands
Por and para
Reciprocal reflexives
Stressed possessive adjectives and pronouns
Home electronics
Computers and the Internet
The car and its accessories
Social Networks, Texting
Relative pronouns
Formal (usted/ustedes) commands
The present subjunctive
Subjunctive with verbs of will and influence
Household chores
Table settings
Central patio
The subjunctive with verbs of emotion
The subjunctive with doubt, disbelief, and denial
The subjunctive with conjunctions
The environment
Recycling and conservation
The Andes Move!
The subjunctive in adjective clauses
Nosotros/as commands
Past participles used as adjectives
City life
Daily chores
Money and banking
At a post office
Traveling by metro
Present Perfect
Past Perfect
Present Perfect Subjunctive
Health and well-being
Exercise and physical activity
Nutrition
Natural Spas
Future
Future Perfect
Past Subjunctive
Professions and occupations
The workplace
Job interviews
Employment benefits
Conditional
Conditional Perfect
Past Perfect Subjunctive
The arts
Movies
Television
Caracas Contemporary Museum of Art
Si clauses
Summary of the uses of the subjunctive
Current events and politics
The media
Natural disasters
Social protests
198
1
None
None
No
None
Please click on the Details button to see the most up-to-date information about textbook and technology requirements.
None.
90% attendance
N/A
This course is designed for students who are able to dedicate the time and effort to a year-long, twice-weekly class schedule for the purpose of gaining a foundation in Spanish grammar and vocabulary.
N/A
N/A
FLI-3717N3
FLI-3717AU2
FLI-3717AT2
FLI-3717AX2
FLI-3717AW2
FLI-3717AV2
FLI-3717B1
FLI-3717AS2
FLI-3717AY2
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.
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.
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.
20
1
None
None
No
None
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.
None
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.
N/A
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.
ESL Instructor
ESL Instructor
ESL Instructor
EDU-3002C2
EDU-3002F3
EDU-3002F2
EDU-3005C2
EDU-3002Z3
Susan Shostak
919-334-1536
[email protected]
To be notified when this course becomes available, please use
Wake Tech's Notify Me service.
learn basic drawing skills using pencil and technical drawing pens and apply many techniques from a professional line illustrator.
create their own art.
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.
16
No
None
None
No
None
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
None
attendance
N/A
Students that would like to learn and practice art and drawing through the use of black ink and white space.
N/A
N/A
CSP-4000AE3
CSP-4000BT3
CSP-74243
CSP-4000LQ2
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.
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
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
120
1
Microsoft
https://docs.microsoft.com/en-us/learn/certifications/exams/mo-200
Exam MO-200 Microsoft Excel:
• Manage worksheets and workbooks
• Manage data cells and ranges
• Manage tables and table data
• Perform operations by using formulas and functions
• Manage charts
No
Prior to registering for this course, students should have digital literacy, including basic computer skills.
N/A
None
80% attendance
Actively participate in class, including discussions and independent and group activities. ,Complete assigned labs and projects.
N/A
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).
Data Analyst, Business Analyst, Business Intelligence Analyst, Management Analyst, Systems Analyst
According to Burning Glass Technologies, Wake County has a high demand for data analysis skills.
Data Analyst
Business Analyst
Business Intelligence Analyst
Management Analyst
Systems Analyst
To be notified when this course becomes available, please use
Wake Tech's Notify Me service.