Excel 2013 Advanced

Dates: August 11, 2017

Meets: 9:00 AM to 4:00 PM

Location: Bldg 700 Rm 2.401

Registration Fee: $199.00

Sorry, we are no longer accepting registrations for this course. Please contact our office to find out if it will be rescheduled, or if alternative classes are available.

Sorry, we are no longer accepting registrations for this course. Please contact our office to find out if it will be rescheduled, or if alternative classes are available.

Registration is not allowed at this time.
Please contact our office for more information.

 Phone: 770-995-9697

Work with advanced functions and formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation, and will use advanced data filtering. They will apply advanced chart formatting options, and create more complex charts. They will work with PivotTables and PivotCharts, export and import data, and query external databases.
Students will learn about the analytical features of Excel, such as Goal Seek, and how to create scenarios. Finally, they will run and record macros, and explore VBA code. This course will help students prepare for the Microsoft Office Specialist core-level exam for Excel 2013 (exam 77-420) and the Microsoft Office Specialist Expert exam for Excel 2013 (exam 77-421).

All materials provided, no book/material purchase required. Prerequisite - Excel Intermediate

Fee: $199.00
Hours:6.00
CEUs:0.60

Bldg 700 Rm 2.401

Gwinnett Technical College - Lawrenceville Campus
5150 Sugarloaf Pkwy
Lawrenceville, Georgia 30043

Share

Email Information to Friend Print