August 6 to September 24 - Microsoft Excel


August 6 to September 24 - 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.

Class Size:  Min - 5 Students ,  Max - 20 Students

Timeframe:  August 6 to September 24

Day & Time: Wednesday - 5:00 pm to 8:00 pm

Location: Government Information Division, Dallas Public Library | 1515 Young Street | Gates Training Room (L1) | Dallas, TX 75201


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


  • 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.