header separator

Computer Education & Training Courses


ADVANCED MICROSOFT EXCEL 2016

Wouldn't it be great to learn how to effectively use all the advanced Excel features? In this practical and information-packed course, you'll see how to maximize this program's functions and capabilities.

Most organizations rely heavily on Excel to consolidate, analyze, and report financial information. Your company is probably no exception. By learning these advanced techniques, you can become more valuable to your organization.

You'll see how to work with the additional analysis tools provided by Excel add-ins and become skilled in using validation to protect the integrity of your worksheets from less experienced users. Impress your coworkers by learning how to add functional and eye-catching custom controls to any worksheet and how to use scenarios and data tables to quickly perform what-if data analysis. You'll discover ways to work with databases and advanced techniques for PivotTables, like creating Timelines, calculated fields, and calculated items. You'll learn how to use Excel's consolidation function to efficiently summarize data from multiple sources, become adept at importing external data using Excel's built-in Power Query tool, and master the art of conditional formatting to highlight duplicate entries and other common worksheet problems.

Learn how Excel 2016 table tools take the complexity out of table creation and management. As you become proficient at nesting functions within other functions, you'll be able to accomplish just about anything Microsoft Excel has to offer!

REQUIREMENTS:

Fayetteville Technical Community College (FTCC) offers eight-week online courses that provide education and training in a variety of occupational areas! The courses are designed by a team of professionals from each respective field who work to provide you with an effective web-based learning experience. Prior to your course start date, you will receive a reminder e-mail that includes instructions on how to access the classroom website. Courses are hosted on ed2go's learning management system (LMS). Each program includes a set of lessons/modules and evaluations.

PRE-REQUISITES:

INSTRUCTOR: Ed2go

Start Date
Day(s)
Time(s)
Location(s)
Price
Select Class
April 17, 2024 $70.00
May 15, 2024 $70.00
June 12, 2024 $70.00
July 10, 2024 $70.00
August 7, 2024 $70.00


Refund & Enrollment Policy

 

Refund Policy

The refund policy for Fayetteville Technical Community College's Continuing Education Division was established by the North Carolina Department of Community Colleges, Raleigh on October 15, 1993. The full refund policy is listed in the NC Administrative Code 23NCAC.2D.0203 (d) Brief Statement of Policy:

  1. A pre-registered extension student who officially withdraws from an extension class(es) prior to the first meeting of the class (should be 24 hours prior) will be eligible for a 100-percent refund by completing an official request form.
  2. The refund will be 75 percent if requested prior to the 10-percent date of the class(es) meeting.
  3. No refunds will be given after 10-percent of class meetings.

Enrollment Policy

Registration can be achieved through the Learn FTCC website. When you submit your completed registration, you will receive an e-mailed receipt.


Deadline for registration is 5:00 P.M. (EST) Wednesday, a week before the course begins.

*Please Note*

  1. To be officially enrolled in a course, students MUST log on and complete Quiz 1 by the first Friday of a course.
  2. To receive a passing grade for the course, students MUST complete 9 out of 12 quizzes and pass the final exam with a grade of a 70 or better. Failure to meet both requirements will result in a grade of "U" or unsatisfactory.

Accessing your course classroom:

  1. Please visit www.ed2go.com/ftcc.
  2. Double-check your receipt to make sure that you choose the correct course title and date!
  3. Once the home page pulls up, please type the course name into the “Search Catalog” bar at the top of the screen and press enter.
  4. When the course description pulls up, please click the red “Add to Cart” button.
  5. Choose your course date from the listing of dates in the "Session Date" drop down menu, and select the “Continue to Checkout” button.
  6. On the next page, if you are a returning student, please enter your e-mail address and password in the appropriate fields. At that point, continue through the steps until you reach the "Checkout" page.
  7. If you have never taken an Ed2Go course before, please create a username and password by clicking the link for new students. After creating your username and password, continue through the steps until you reach the "Checkout" page.
  8. Please click the "Checkout" button.
  9. After clicking the "Checkout" button, you will be taken to a page where you will read through the registration and payment information.
  10. If you have already registered and paid your registration fee on the Learn FTCC website, you will not need to make a payment for your course. At that time, please click on the "Enter My Classroom" button.
  11. If you have not registered and paid your registration fee on the Learn FTCC website, you will be directed to the Learn FTCC website to register and pay your registration fee. Afterwards, please click on the "Enter My Classroom" button.
  12. On the next page, please click the "Orientation" button on the next page and complete it.
  13. Write down your username and password in a safe location!
  14. On the start date of your course, you will return to the www.ed2go.com/ftcc home page, and click on the “Classroom” link to access your course or courses.

 

Computer Requirements

Internet access
Email
One of the following browsers: 

Mozilla Firefox

Microsoft Internet Explorer (9.0 or above) 

Google Chrome

Safari
Adobe PDF  plug-in (a free download obtained at Adobe.com .)


Microsoft Windows 7, Microsoft Windows 8, or Microsoft Windows 10; Microsoft Office Home and Student 2016 or Microsoft Office 365 are acceptable. A free 30-day trial of Office 365 Home Premium may be available at (https://office.microsoft.com/en-us/try/).

This course is not suitable for Macintosh users, users of older versions of Microsoft Excel, or users of OpenOffice.

Note:  "Starter Version" and "Web App" versions of Microsoft Excel will not work with the full version of Excel taught in this course.