Course Registration Form

COURSE DESCRIPTION

Welcome to Microsoft Excel 2016. This course covers the fundamental concepts of spreadsheet skills necessary to be successful within an organization. The emphasis is on technical knowledge and reinforcement of problem-solving abilities through project-based learning. This course prepares students for the Microsoft Office Specialist Excel certification.

GET STARTED

  1. Plan, design, and create spreadsheets using complex formulas and functions.
  2. Prepare and manage multiple-sheet workbooks.
  3. Create macros, macro buttons, and set security for macros.
  4. Summarize and analyze data.
  5. Demonstrate critical thinking and problem-solving skills.

Upon completion of this course, the student will:

  1. Plan, design, and create spreadsheets using complex formulas and functions.
    1. Identify, describe, and use logical, lookup, and financial functions.
    2. Select functions and formulas to calculate values.
    3. Create and maintain range names.
    4. Use range names in formulas.
    5. Choose correct cell address reference to enter formulas and functions.
    6. Develop a spreadsheet using templates.
  2. Prepare and manage multiple-sheet workbooks.
    1. Import and export data to and from an external source such as an Access database or a text file.
    2. Export and publish spreadsheets to external applications such as portable document format (PDF) or webpage.
    3. Use the password protection feature to ensure the confidentiality of a workbook.
    4. Group and ungroup worksheets.
    5. Use the consolidate data function.
  3. Create macros, macro buttons, and set security for macros.
    1. Create and demonstrate proper use of macros.
    2. Use macros to automate a spreadsheet.
    3. Evaluate, assess, and edit macros.
    4. Develop worksheet templates using macros.
    5. Use the macro recorder feature.
    6. Use relative reference in macro.
  4. Summarize and analyze data.
    1. Manage large workbooks using advanced sorting and filtering.
    2. Create, modify, and format a pivot table.
    3. Filter and slice a pivot table.
    4. Use PowerPivot functionality to import data from multiple data sources.
    5. Create and customize a pivot chart.
  5. Demonstrate critical thinking and problem-solving skills.
    1. Collaborate with peers to identify worksheet errors and circular references.
    2. Modify formulas to eliminate circular references.
    3. Create and edit professional-looking charts to present data.
    4. Create one and two-variable data tables.
    5. Set up substitution values, and add formulas to data tables.

MEET YOUR INSTRUCTOR

Larry Kennedy, MBA, PMP

(Adjunct Professor – Delaware Technical Community College | Adjunct Professor Community College of Philadelphia)

Professor Kennedy’s diverse career includes over 25 years as a Vice President for the fixed income and equities (domestic & international) desk at JP Morgan Chase Bank.

Professor Kennedy is a PMI certified project management professional (PMP) with expertise in managing technology, process improvement, infrastructure, and international development projects.

Professor Kennedy holds an Associate Degree in Finance, a Bachelor of Science Degree in Finance, a Masters of Business Administration in Finance where he graduated cum laude, and a Masters of Business Administration in Management Information Systems.

COURSE SCHEDULE

Course Policies/Testing CenterOverview

Excel 2016
Ribbon and Quick Access Toolbar
Status Bar Overview
Backstage View and Customizing Tool Bar (Developer Tab)
Print Preview and Page Setup

Creating and Editing Workbooks

Creating and Editing Charts

Formatting, Organizing, and Getting Data

Please fill out the form below to register for the Excel 2016 Course. 

2 + 1 =

Jun
1
Sat
FREE Homebuyer Education Seminar @ Neighborhood House, Inc.
Jun 1 @ 8:00 am – 1:00 pm

Gain the necessary tools you need to begin your journey to home ownership! Let our counselors assist you! Don’t let the fear of not having enough money for down payment hinder you from purchasing your home! You may be more ready than you think! Don’t put it off for another year!

Please arrive on time. Refreshments will be served for those in attendance.

Jun
4
Tue
Food Skills & Nutrition Education Program @ Bethesda United Methodist Church
Jun 4 @ 10:00 am – 11:30 am

University of DE Cooperative Extension
In Conjunction with Neighborhood House
Presents:

Food Skills and Nutrition Education Program

Healthy Refreshments Every Class

How to stretch your food dollars

Nutrition information

Try New Recipes

Free gifts and Food & Gift Card Giveaways

 

RSVP to Marilyn at Neighborhood House, 302-378-7217
Or, just show up!

Jun
8
Sat
Highmark Walk for a Healthy Community @ Frawley Stadium at the Riverfront
Jun 8 @ 7:00 am – 1:00 pm

 

 

 

 

 

Join us on June 8th at Frawley Stadium for the Highmark Walk!
(Bring the kids! There will be activities for the entire family.)
Funds raised support the youth of Neighborhood House.
Visit our Highmark page to donate, sponsor a walker, start a team, or join a team!

Thank you in advance for your support!

Jun
18
Tue
Southbridge Civic Association Meeting @ Neighborhood House, Inc.
Jun 18 @ 6:00 pm – 8:00 pm
Jun
20
Thu
Housing Department – Financial Workshop @ Bethesda United Methodist Church
Jun 20 @ 10:00 am – 12:00 pm

Tell Your Money What To Do!

  • Are you worried about your future?
  • Received a disconnect notice?
  • Had an emergency and no funds?
  • Money seems to disappear?
  • Panic attacks when opening mail?

Come to this workshop and learn some tips that will help you change some behaviors and be able to enjoy living.
Learn how to reduce debt and increase income!

We will be raffling gift cards but you MUST be present to WIN!

Lunch will be provided for the participants attending this workshop!

Play Streets! @ Neighborhood House, Inc.
Jun 20 @ 6:00 pm – 8:30 pm

Gather your family and friends for an evening of fun and play! This kid-friendly event is free to the public!

Jun
24
Mon
Delmarva Power – Assistance Programs @ Neighborhood House, Inc.
Jun 24 @ 10:00 am – 12:00 pm

A representative from Delmarva Power will be visiting our Wilmington office to discuss the different programs available to those who carry past due balances on their energy bills and answer any other questions attendees may have.

**This is a free information session. The representative will not be able to answer individual billing concerns.**

Jul
6
Sat
FREE Homebuyer Education Seminar @ Neighborhood House, Inc.
Jul 6 @ 8:00 am – 1:00 pm

Gain the necessary tools you need to begin your journey to home ownership! Let our counselors assist you! Don’t let the fear of not having enough money for down payment hinder you from purchasing your home! You may be more ready than you think! Don’t put it off for another year!

Please arrive on time. Refreshments will be served for those in attendance.

Jul
16
Tue
Southbridge Civic Association Meeting @ Neighborhood House, Inc.
Jul 16 @ 6:00 pm – 8:00 pm
Aug
3
Sat
FREE Homebuyer Education Seminar @ Neighborhood House, Inc.
Aug 3 @ 8:00 am – 1:00 pm

Gain the necessary tools you need to begin your journey to home ownership! Let our counselors assist you! Don’t let the fear of not having enough money for down payment hinder you from purchasing your home! You may be more ready than you think! Don’t put it off for another year!

Please arrive on time. Refreshments will be served for those in attendance.