The Microsoft Office Specialist Associate designation is earned through performance-based examination. By acquiring this credential, you may set yourself apart from other candidates. Demonstrate to potential employers your level of expertise and show that you have the skills necessary to use Microsoft products to increase business efficiency in a range of scenarios.
According to ONET, office and administrative support workers earn, on average, $38,060 in North Carolina. Top office and administrative support professional earnings can exceed $58,640 a year. According to Burning Glass Technologies, the job postings requesting these skills the most were for administrative, executive and paralegal assistants.
Don't have enough money to pay for a course? Right now, Wake Tech's Propel program offers scholarships that cover the cost of registration and fees.
NOTE: The Propel Scholarship Application is currently closed and will reopen July 1.
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
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
| 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.
Recognize core cloud computing models and Azure services.
Configure an Azure account and navigate the Azure portal.
Describe Azure security, compliance, and privacy features.
Utilize Azure pricing models and cost management tools.
Execute basic tasks to manage resources using Azure CLI and PowerShell.
Introduction to Azure Fundamentals
Cloud Concepts
Azure Core Services
Azure Core Networking Services
Security, Compliance, Privacy, and Trust
Azure Solutions
Azure Pricing, Service Levels, and Lifecycle
Creating and Managing Azure Resources
Certification Exam Review and Preparation
24
No
Microsoft
No
Prior to registering for this course, students should have basic IT knowledge, such as an understanding of computer systems and networking
None
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 to evidence relevant competencies or those who want to successfully prepare for the relevant industry certification exam(s).
Azure Cloud Engineers, .NET Developers, Lead Cloud Architects, Software Engineers
According to Lightcast, there is a significant demand for professionals with cloud computing skills, particularly Microsoft Azure, across various industries in Wake County, NC.
| Details | Section | Date(s) | Location | Price | Seats | 311610 | 07/08/25 - 07/31/25 | BEC | 82.00 | 23 | Register |
|---|
If you would like to be notified when additional sections become available, please use Wake Tech's Notify Me service.
Know the fundamentals of AI and its applications in various industries
Identify the principles of machine learning and how to apply them using Azure
Describe features of computer vision workloads on Azure
Describe features of Natural Language Processing (NLP) workloads on Azure
Prepare for the Microsoft AI-900 certification exam
Introduction to the AI-900 Exam
Azure AI Services
Overview of AI Workloads and Key Use Cases
Fundamental Principles of Machine Learning
Azure Machine Learning
Features of Computer Vision Workloads on Azure
Certification Exam Preparation
36
1
Microsoft Certified / Azure AI Fundamentals
No
Prior to registering for this course, students should have cloud computing literacy, including the ability to navigate the internet.
None
Access to a computing technology with reliable internet.
80% attendance"Actively participate in class, including discussions and independent and group activities.
","Complete assigned labs and projects."
N/A
Adults seeking to enhance their technical knowledge to improve employability, and/or those interested in obtaining the exam credential.
Software Developers, Data Scientists
Wake County has a growing need for artificial intelligence in the workforce, ensuring students are equipped with the skills necessary for AI roles.
Software Developers
Data Scientists
To be notified when this course becomes available, please use
Wake Tech's Notify Me service.
Navigate and use essential hardware and software in a computer system.
Manage files effectively using operating systems and cloud storage platforms.
Use the internet for professional purposes, including safe browsing practices.
Communicate professionally through email, including email etiquette and managing inboxes.
Apply basic cybersecurity principles to protect personal data and systems.
Collaborate effectively using cloud-based tools such as Google Docs and Microsoft Teams.
Recognize the basics of emerging technologies such as AI, Machine Learning, Blockchain, and Data Analytics, and their real-world applications.
Computers and Digital Literacy
Navigating and Customizing Windows 1
File Management and Cloud Storage
Internet Navigation and Online Communication
Social Media
Cybersecurity and Online Privacy
Cloud-Based Collaboration and Communication Tools (word processing, spreadsheets, presentations)
Data Analytics and Visualization
Blockchain and Distributed Ledger Technology
Artificial Intelligence (AI) and Machine Learning
LinkedIn, IT Career Pathways, and Next Steps
39
1
None
No
None
None
None
80% attendance"Actively participate in class, including discussions and independent and group activities.
","Complete assigned labs and projects."
N/A
Individuals seeking to gain foundational information technology skills and familiarity with emerging technologies.
Office Assistant, Administrative Support
Wake County has a growing need for computing and emerging technology skills, reflective of the expanding job market in various job roles, which is essential for job performance.
Administrative Support
Office Assistant
To be notified when this course becomes available, please use
Wake Tech's Notify Me service.
Identify key Excel tools for data analysis, including Pivot Tables and charts.
.
Apply advanced Excel tools to organize and analyze large sets of data.
Analyze data trends and patterns by creating reports and visualizations that help with decision-making.
Check the accuracy of data by using data cleaning techniques to ensure reliable results.
Create clear and professional dashboards to present data in an easy-to-understand way.
Combine data from different sources to create reports that provide useful insights for business strategies
Preparing the Data for an Excel Pivot Table
Summarizing and Presenting Data with a Pivot Table
Using Calculations in Pivot Tables
Sorting and Filtering the Pivot Table
Making the Pivot Table More Visual with Charts
Summarizing Data by Date and Time
Creating a Pivot Table from Multiple Spreadsheets
Improving a Pivot Table with Power Pivot
Pulling It All Together: Creating a Dashboard from Pivot Tables
39
1
None
No
Prior to enrolling in this course, students should have basic proficiency in Microsoft Excel, including knowledge of creating and formatting spreadsheets, using basic functions such as SUM and AVERAGE, and organizing data. Familiarity with data management concepts and general computer skills is also required.
None
None
80% attendance"Actively participate in class, including discussions and independent and group activities.","Complete assigned labs and projects."
N/A
Individuals seeking to obtain entry-level data roles or those who want to enhance skills to improve employability.
Data Analysts, Business Analysts, Financial Analysts, Accountants, Project Managers, General Managers, Operations Managers
Data analysis and business analysis skills are highly sought after in Wake County, with a high demand reflected in job postings.
Data Analysts
Business Analysts
Financial Analysts
Accountants
Project Managers
General Managers
Operations Managers
| Details | Section | Date(s) | Location | Price | Seats | 311738 | 06/16/25 - 07/28/25 | MS Teams Virtual Learning Platform | 233.00 | 24 |
Course Cancelled
|
|---|
If you would like to be notified when additional sections become available, please use Wake Tech's Notify Me service.
Recall key Power BI concepts, tools, and features used in data analysis and visualization.
Explain the purpose and benefits of using Power BI for creating reports, dashboards, and analyzing data.
Use Power BI to import, transform, and visualize data, creating interactive reports and dashboards.
Assess data trends and patterns through Power BI's analytical tools to draw meaningful business insights.
Critique and improve Power BI reports and dashboards for clarity, functionality, and business value.
Design and develop Power BI reports and dashboards tailored to specific business needs and data analysis goals.
Introducing Power BI
From Data to Insight
Let's Take a Flyover!
Building Your First Report
Preparing Data
Modeling Data
Relationships and Filtering
Enhancing Your Report
Refreshing, Sharing, and Collaborating
Introducing DAX
39
1
None
No
Prior to course enrollment, students should have basic computer skills, familiarity with Excel or similar data analysis tools, and a foundational understanding of data concepts. No prior experience with Power BI is required.
None
None
80% attendance"Actively participate in class, including discussions and independent and group activities.","Complete assigned labs and projects."
N/A
Individuals seeking to obtain entry-level roles or those who want to enhance skills to improve employability.
Data Engineers, Data Analysts, Business Intelligence Analysts, Power BI Developers, Enterprise Data Analysts, Data Coordinators, Data Managers, Reporting Analysts
Wake County has a high demand for this skill, with numerous job postings seeking professionals in data analysis, business intelligence, and data visualization using Power BI.
Data Engineers
Data Analysts
Business Intelligence Analysts
Power BI Developers
Enterprise Data Analysts
Data Coordinators
Data Managers
Reporting Analysts
To be notified when this course becomes available, please use
Wake Tech's Notify Me service.
Describe the core functionalities and features of Microsoft Teams, including setting up teams, channels, and managing files.
Demonstrate how to use Microsoft Teams tools to organize and manage meetings, share content, and collaborate with team members effectively.
Examine how to integrate Microsoft Teams with other Microsoft 365 tools to streamline workflows and enhance team productivity.
Evaluate the effectiveness of Microsoft Teams in various communication scenarios and identify opportunities for improvement.
Introduction to Microsoft Teams
Getting Started with Teams
Setting Up a Team
Working with Channels
Converse in a Channel
Extending Teams with Apps and Services
Working with Files in Teams
Chat with Team Members
Organizing Meetings
Attending Meetings
Getting Things Done in Meetings
Making Calls
Customizing Teams
Administering Teams
45
1
None
No
Prior to course enrollment, students should have basic computer skills.
None
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 enhance their collaboration and communication skills using Microsoft Teams
Project Management Specialists, Computer User Support Specialists, Software Developers, Administrative Assistants, and Network Administrators
According to Lightcast, Wake County shows strong demand for roles requiring Microsoft Teams proficiency, reflecting the increasing need for digital collaboration across industries.
Project Management Specialists
Computer User Support Specialists
Software Developers
Administrative Assistants
and Network Administrators
To be notified when this course becomes available, please use
Wake Tech's Notify Me service.
According to Microsoft, you must successfully pass three of the following exams to receive the Microsoft Office Specialist Associate certification: