Scheduled Date:
8/3/23
Email CLIPTraining.Support@csc.nj.gov or contact the Registration Team at 609-777-2225 to be added to the waitlist. Contract classes are also available.
|
Location:
Civil Service Commission 44 S. Clinton Ave. Trenton, NJ 08625
|
Cost per Person: $159
Pre- Requisite: Microsoft Excel Intermediate
Length: 6 hours
Time: 8:30am - 4:00pm
LMS users click here to register.
|
Course Description
This one-day course builds on the skills and concepts taught in Excel Intermediate. Participants will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, participants will learn about data validation and database functions such as DSUM. They will learn how to work with PivotTables and PivotCharts, how to import and export data, and how to query external databases. Finally, participants will learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, and sharing Excel data via the Web.
Course Topics
Unit 1: Advanced functions
Unit 2: Lookups and data tables
Unit 3: Advanced list management
Unit 4: PivotTables and PivotCharts
Unit 5: Exporting and importing
Unit 6: Analytical options
Unit 7: Macros and custom functions
Unit 8: Conditional formatting and SmartArt
Registration
Learning Management System Users: Please login into your Learning Management System account and navigate to “Now Enrolling” from the “Browse” drop-down menu. Select the training you wish to register for and click “Enroll.” This will initiate the required approval process.
External participants, can click here to complete the HR-1 Training Authorization Form. Your direct supervisor, departmental training coordinator, and fiscal officer must approve the form. HR-1's received without proper approval will be returned to the Department's Training Coordinator.
Please note: You are not scheduled for the requested classroom training until you receive an official email confirmation from CLIP.
If you have any questions about the program or the registration process, you can reach a customer success representative by calling (609) 777-2225 or emailing CLIPTraining.Support@csc.nj.gov.
A $20 administrative fee will apply to learners who do not have Learning Management System (LMS) platform accounts.
Training Authorization Form