Registration for (37043)
Excel 2010 - Advanced on 09/24/19
Prerequisite: Knowledge of the Microsoft Windows operating system, minimizing and maximizing windows, opening, saving and closing files, and creating folders. Completion of the courses Excel Introduction and Intermediate or equivalent knowledge.
Course Description: Students will learn Insert Function, logical statements (IF function), functions for computing loan payments (PMT, IPMT, PPMT), and functions for looking up information in a table (VLOOKUP, HLOOKUP). They will create and edit pivot tables, use Goal Seek, Scenario Manager, and the Auditing toolbar, and consolidate data. They will create macros and learn to protect worksheets and workbooks. They will customize toolbars and buttons.
Number of Days: 1
Time: 9:00 AM - 4:00 PM
Please complete the form below to pre-register for this class. After registration, you will receive an email notification. Our training department will contact you shortly with final confirmation.