Microsoft Word

8-week hands-on and interactive instructor-led course as we utilize Microsoft Word to solve real-world business problems. We will explore Microsoft Word through a series of mini projects/assignments that covers the following functional areas and reflects the requirements for the Word 2016: Core Document Creation, Collaboration, and Communication exam of the Microsoft Office Specialist certification and Employment-based tests.

The expectation is that each participant is committed to starting and completing the course and spending time outside of the weekly 3hr in-person session to complete all assignments.

Sample Business Problems

• Create and design forms, letters, and mailings

• Produce Promotional Materials (Flyers, Posters, etc.), Report Covers, Calendars, Resumes, etc.

• Personalized sales and marketing collateral, including proposals and quotes

Functional Areas

• Create and manage documents

• Format text, paragraphs, and sections

• Create tables and lists

• Create and manage references

• Insert and format graphic elements

Microsoft Excel

Join this 8-week hands-on and interactive instructor-led course as we utilize Microsoft Excel to solve real-world business problems. We will explore Microsoft Excel through a series of mini projects/assignments that covers the following functional areas and reflects the requirements for the Excel 2016: Core Data Analysis, Manipulation, and Presentation exam of the Microsoft Office Specialist certification and Employment-based tests.

The expectation is that each participant is committed to starting and completing the course and spending time outside of the weekly 3hr in-person session to complete all assignments.

Sample Business Problems

Data cleansing and transformation

• Data cleansing and transformation with Concatenating, Text to Column, Remove Duplicate, Padding, Logic Statement, and Text to Number Conversion

• Productivity Boosts Tips and Tricks

Data reconciliation and analysis

• Data reconciliation and analysis with Vertical & Horizontal Lookup (VLookup, HLookup), Pivot Table, Match and Index

• Effectively tell a story about your data with graphs and charts

Functional Areas

• Create and manage worksheets and workbooks

• Manage data cells and ranges

• Create tables

• Perform operations with formulas and functions

• Create charts and objects

Grow with Google - Applied Digital Skills Training

Join this 8-week hands-on and interactive instructor-led course as we follow the Grow with Google Applied Digital Skills for Adult Learners course to learn practical digital skills using their free project-based video curriculum that includes an Introduction to Machine Learning.

The expectation is that each participant is committed to starting and completing the course and spending time outside of the weekly 3hr in-person session to complete all assignments.

The course uses G Suite tools to help sharpen your skills in these areas:

Research & Communication

• Evaluate bias

• Research a topic

• Create presentations 

Data Analysis

• Create spreadsheet formulas

• Identify patterns in data

• Visualize data using graphs

G Suite Tools

• Sheets, Slides, Docs, Gmail Calendar, Drive

Coding & Digital Literacy

• Use digital tools

• Implement algorithms

• Debug code