The Microsoft Office Specialist Associate designation is earned through performance-based examination. Acquire this credential to set yourself apart from other job 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.
Office and administrative support workers earn, on average, $38,060 in North Carolina, according to ONET. Top office and administrative support professional earnings can exceed $58,640 a year. The job postings requesting these skills the most were for administrative, executive and paralegal assistants, according to Lightcast.
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 March 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
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.
Learn to create and edit Microsoft Word documents
Build impressive new documents using Word templates
Format text and other elements to keep your documents clear, organized and easy to read and automate repetitive tasks using macros
Create professional-looking documents with advanced editing tools
Introduction to Word
Intermediate Word
Advanced Word
Final Exam
70
No
None
None
No
There are no prerequisites to take this course. However, you should be comfortable using a personal computer and be familiar with operating Microsoft Office software.
Hardware requirements:
This course must be taken on a PC. Macs and Chromebooks are not compatible.
Software requirements:
PC: Windows 10 or later
Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge is also compatible.
Microsoft Office 365, 2021 or 2019 (not included in enrollment). While you can use an older version of Microsoft Office, there will be some differences between your version and what you see in the 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.
N/A
90% attendance
N/A
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.
According to Microsoft, you must successfully pass three of the following exams to receive the Microsoft Office Specialist Associate certification: