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.

Microsoft Excel

Registration Required - Please visit https://www.route360inc.org/events/microsoft-excel to register.

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

Prerequisites

· Excel 2016 or Newer

· PC or MAC Laptop

· Be comfortable managing information on your computer and perform tasks such as opening and closing applications, navigating basic file structures, and managing files and folders.

Please visit https://www.route360inc.org/events/microsoft-excel to register.