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? 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 Office Specialist Certification Courses
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 and 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; and analyze data using PivotTables and PivotCharts
SQL: Create normalized databases, explore how to insert data into tables efficiently and 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 and 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; and 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 and review why different stakeholders have divergent needs and views
Outline of Instruction
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 and prepare for the Excel Core Certification Exam
Excel Data Analysis: Learning basic data analysis techniques, working with data analysis tools, introducing Excel tables, data from external sources, cleaning data, analyzing table data with functions, creating and using PivotTables, performing PivotTable calculations, building PivotCharts and exam certification preparation
SQL: SQL basics; manipulating data; normalization; the SELECT statement; shaping data with the WHERE clause; JOINS; subqueries, cases and views; SQL programming; security and aggregate functions
Power BI: Introduction to business intelligence and Power BI; up and running with Power BI Desktop; connecting and shaping data; creating data models and calculations; unlocking insights; creating the final report; publishing and sharing; using reports in the service; understanding dashboards, apps and security; and data gateways and refreshing datasets
Tableau: Taking off with Tableau; connecting to data in Tableau; moving beyond basic visualizations; calculations and parameters; leveraging level-of-detail calculations; diving deep with table calculations; making visualizations that look great and work well; telling a data story with dashboards; and visual analytics, trends, clustering, distributions and forecasting
Communicating with Data: Communication, data, visualizing data, visualizing data differently, visual elements, methods of communicating with data, implementation strategies for your workplace and 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 and 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
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
| Details | Section | Date(s) | Location | Price | Seats | |
|---|---|---|---|---|---|---|
| 328707 | 06/09/26 - 10/27/26 | Microsoft Teams | 293.00 | 0 |
If you would like to be notified when additional sections become available, please use Wake Tech’s Notify Me service for BAS-3120B2-Data Analytics for Business Professionals .
