Microsoft Excel

Program Type:

Economic/Workforce Development, Featured, Technology

Age Group:

Adult
Please note you are looking at an event that has already happened.

Event Details

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.