Microsoft Office Certification
Go from knowing nothing about working with computers to becoming prepared for Microsoft certification exams with a series of courses from Wake Tech.
Courses cover the following:
- Navigating computers and the internet
- Essentials for word processing and spreadsheets
- Data analysis and visualization tools, including SQL, Tableau and Power BI
- Methods and technology skills for office administrative work
Each course prepares students for a different Microsoft certification exam.
Industry-recognized credential(s): Microsoft Office Specialist
Complete course(s) in: Three to nine months
Financial assistance available
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.
Microsoft Office Specialist Certification Courses
Computer Technology Basics for Digital Literacy
Course Objectives
Keyboarding:
• Identify keyboarding platforms
• Assess typing speed
• Discuss techniques to improve typing speed
• Practice typing and using appropriate finger placement
Computing Fundamentals:
• Define basic concepts
• Identify various device types
• Manage desktop and cloud computing files, folders, and settings
• Navigate operating systems
• Review troubleshooting methods for basic computer problems
• Recognize basic security threats
Online Essentials:
• Define commonly used Internet concepts
• Navigate the web
• Create, format, and manage email
• Create, manage, and share calendars
• Define, identify, and recall social media concepts and usages for business purposes
• Identify appropriate communication methods in given situations,
• Examine online collaboration tools
• Define streaming concepts and recognize online conference technologies
• Describe digital citizenship
• Identify best practices for professional online identity management
Application Essentials:
• Define usages for word processing, spreadsheets, presentations, and database concepts
• Recognize common application elements
• Identify various device types
• Create, format, and manage files
Exam MO-100 Microsoft Word (Word and Word 2019):
• Manage documents
• Insert and format text, paragraphs, and sections
• Manage tables and lists
• Create and manage references
• Insert and format graphic elements
• Manage document collaboration
Outline of Instruction
Keyboarding:
1. Introduction
2. Typing Assessment
3. Getting Started
4. Reaching Out
5. The Home Stretch
6. Wrapping Up
Computing Fundamentals:
1. Mobile Devices
2. Hardware Devices
3. Computer Software Architecture
4. Backup and Restore
5. File Sharing
6. Cloud Computing
7. Security
Online Essentials:
1. Internet Concepts
2. Common Functionality
3. Email Clients
4. Calendering
5. Social Media
6. Communications
7. Online Conferencing
8. Streaming
9. Digital Citizenship
Application Essentials:
1. Common Features
2. Work in Documents
3. Work in Spreadsheets
4. Recognize Basic Database Concepts
5. Work in Presentations
6. Apply Application Uses and Platforms
7. Graphic Modification
Exam MO-100 Microsoft Word (Word and Word 2019)
1. Manage documents
2. Insert and format text, paragraphs, and sections
3. Manage tables and lists
4. Create and manage references
5. Insert and format graphic elements
6. Manage document collaboration
Contact Hours
72
CEUs
1
Industry Standard, State or National Certification
Certification
Microsoft
Website
https://docs.microsoft.com/en-us/learn/certifications/exams/mo-100
Certification Learning Outcomes/Requirements
Exam MO-100 Microsoft Word (Word and Word 2019):
• Manage documents
• Insert and format text, paragraphs, and sections
• Manage tables and lists
• Create and manage references
• Insert and format graphic elements
• Manage document collaboration
CE or CU Articulation
No
Prerequisites
None
Learning Supplies Needed
None
Clinical Site/Special Facilities
None
Requirements for Successful Completion
90% attendance
Demonstrate an understanding of at least 80% of course material taught.
Accreditation/Special Approval Requirements
N/A
Intended Audience
Individuals who want digital literacy, employment-readiness, or want to successfully prepare for the relevant industry certification exam.
Specific Industry or Business Support Needs
Office Clerk, Office Assistant, Administrative Assistant
Wake County Need for Industry Positions
ONET reports that Office Clerk occupations are projected to have large numbers of job openings. Likewise, Burning Glass Technologies shows that Wake County has a very high demand for the Office Assistant and Administrative Assistant occupations.
Industry or Job Titles Related to Training Outcomes for Employment
Office Clerk
Office Assistant
Administrative Assistant
Related Courses
HRD-3005BH2
HRD-3005BG2
HRD-3004AZ2
CTS-3255A2
CSC-3110EH2
CSC-3110EJ2
CSC-3110EI2
OST-3100R2
BAS-3120B2
Course Contact Information
Andrea Dethmers
9195325736
[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
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
Certification
Microsoft
Website
https://docs.microsoft.com/en-us/learn/certifications/exams/mo-200
Certification Learning Outcomes/Requirements
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
CE or CU Articulation
No
Prerequisites
Prior to registering for this course, students should have digital literacy, including basic computer skills.
Learning 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
No active courses available at this time.
To be notified when this course becomes available, please use
Wake Tech's Notify Me service.
Microsoft Azure Fundamentals AZ-900
Course Objectives
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.
Outline of Instruction
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
Contact Hours
24
CEUs
No
Industry Standard, State or National Certification
Certification
Microsoft
Website
https://learn.microsoft.com/en-us/credentials/certifications/resources/…
Certification Learning Outcomes/Requirements
Describe cloud concepts
Describe Azure architecture and services
Describe Azure management and governance
CE or CU Articulation
No
Prerequisites
Prior to registering for this course, students should have basic IT knowledge, such as an understanding of computer systems and networking
Learning Supplies Needed
None
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 to evidence relevant competencies or those who want to successfully prepare for the relevant industry certification exam(s).
Specific Industry or Business Support Needs
Azure Cloud Engineers, .NET Developers, Lead Cloud Architects, Software Engineers
Wake County Need for Industry Positions
According to Lightcast, there is a significant demand for professionals with cloud computing skills, particularly Microsoft Azure, across various industries in Wake County, NC.
Industry or Job Titles Related to Training Outcomes for Employment
No active courses available at this time.
To be notified when this course becomes available, please use
Wake Tech's Notify Me service.
Microsoft Azure AI Fundamentals AI-900
Course Objectives
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
Outline of Instruction
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
Contact Hours
36
CEUs
1
Industry Standard, State or National Certification
Certification
Microsoft Certified / Azure AI Fundamentals
Website
https://learn.microsoft.com/en-us/credentials/certifications/resources/…
Certification Learning Outcomes/Requirements
Describe Artificial Intelligence workloads and considerations
Describe fundamental principles of machine learning on Azure
Describe features of computer vision workloads on Azure
Describe features of Natural Language Processing (NLP) workloads on Azure
Describe features of generative AI workloads on Azure
CE or CU Articulation
No
Prerequisites
Prior to registering for this course, students should have cloud computing literacy, including the ability to navigate the internet.
Learning Supplies Needed
None
Clinical Site/Special Facilities
Access to a computing technology with reliable internet.
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
Adults seeking to enhance their technical knowledge to improve employability, and/or those interested in obtaining the exam credential.
Specific Industry or Business Support Needs
Software Developers, Data Scientists
Wake County Need for Industry Positions
Wake County has a growing need for artificial intelligence in the workforce, ensuring students are equipped with the skills necessary for AI roles.
Industry or Job Titles Related to Training Outcomes for Employment
Software Developers
Data Scientists
No active courses available at this time.
To be notified when this course becomes available, please use
Wake Tech's Notify Me service.
IT Essentials: Computer Basics to Emerging Technologies
Additionally, the course covers emerging technologies such as Artificial Intelligence (AI), Blockchain, Machine Learning (ML), and Data Analytics, which are reshaping industries and providing new career opportunities. Through hands-on, practical learning experiences, students will build the skills needed to confidently operate in a modern IT environment. Successful completion of the course can lead to industry-recognized credentials and further career development opportunities in IT-related fields.
Course Objectives
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.
Outline of Instruction
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
Contact Hours
39
CEUs
1
Industry Standard, State or National Certification
Certification
None
Website
None
Certification Learning Outcomes/Requirements
CE or CU Articulation
No
Prerequisites
None
Learning Supplies Needed
None
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 seeking to gain foundational information technology skills and familiarity with emerging technologies.
Specific Industry or Business Support Needs
Office Assistant, Administrative Support
Wake County Need for Industry Positions
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.
Industry or Job Titles Related to Training Outcomes for Employment
Administrative Support
Office Assistant
No active courses available at this time.
To be notified when this course becomes available, please use
Wake Tech's Notify Me service.
Data Analysis and Visualization with Microsoft Excel
Through hands-on learning, you'll gain proficiency in organizing, cleaning, and manipulating data, as well as creating insightful reports and visualizations. By the end of the course, you'll be ready to manage real-world data challenges and drive informed decision-making.
Course Objectives
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
Outline of Instruction
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
Contact Hours
39
CEUs
1
Industry Standard, State or National Certification
Certification
None
Website
None
Certification Learning Outcomes/Requirements
CE or CU Articulation
No
Prerequisites
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.
Learning Supplies Needed
None
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 seeking to obtain entry-level data roles or those who want to enhance skills to improve employability.
Specific Industry or Business Support Needs
Data Analysts, Business Analysts, Financial Analysts, Accountants, Project Managers, General Managers, Operations Managers
Wake County Need for Industry Positions
Data analysis and business analysis skills are highly sought after in Wake County, with a high demand reflected in job postings.
Industry or Job Titles Related to Training Outcomes for Employment
Data Analysts
Business Analysts
Financial Analysts
Accountants
Project Managers
General Managers
Operations Managers
No active courses available at this time.
To be notified when this course becomes available, please use
Wake Tech's Notify Me service.
Microsoft Power BI for Data Analysis
Course Objectives
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.
Outline of Instruction
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
Contact Hours
39
CEUs
1
Industry Standard, State or National Certification
Certification
None
Website
None
Certification Learning Outcomes/Requirements
CE or CU Articulation
No
Prerequisites
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.
Learning Supplies Needed
None
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 seeking to obtain entry-level roles or those who want to enhance skills to improve employability.
Specific Industry or Business Support Needs
Data Engineers, Data Analysts, Business Intelligence Analysts, Power BI Developers, Enterprise Data Analysts, Data Coordinators, Data Managers, Reporting Analysts
Wake County Need for Industry Positions
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.
Industry or Job Titles Related to Training Outcomes for Employment
Data Engineers
Data Analysts
Business Intelligence Analysts
Power BI Developers
Enterprise Data Analysts
Data Coordinators
Data Managers
Reporting Analysts
No active courses available at this time.
To be notified when this course becomes available, please use
Wake Tech's Notify Me service.
Microsoft Teams Essentials
Course Objectives
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.
Outline of Instruction
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
Contact Hours
45
CEUs
1
Industry Standard, State or National Certification
Certification
None
Website
None
Certification Learning Outcomes/Requirements
CE or CU Articulation
No
Prerequisites
Prior to course enrollment, students should have basic computer skills.
Learning Supplies Needed
None
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 enhance their collaboration and communication skills using Microsoft Teams
Specific Industry or Business Support Needs
Project Management Specialists, Computer User Support Specialists, Software Developers, Administrative Assistants, and Network Administrators
Wake County Need for Industry Positions
According to Lightcast, Wake County shows strong demand for roles requiring Microsoft Teams proficiency, reflecting the increasing need for digital collaboration across industries.
Industry or Job Titles Related to Training Outcomes for Employment
Project Management Specialists
Computer User Support Specialists
Software Developers
Administrative Assistants
and Network Administrators
No active courses available at this time.
To be notified when this course becomes available, please use
Wake Tech's Notify Me service.
