Quick Links
Prospective Student
Accepted Student
Current Student
Contact Us
Visit Gwinnett Tech
Dashboard
Banner Login
Blackboard
My Textbook List
Excel 2013 Advanced
Dates: March 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.
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).
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 Campus5150 Sugarloaf Pkwy
Lawrenceville, Georgia 30043