0085 - Advanced Microsoft Excel

Carl Vinson Institute of Government - Financial Programs

This advanced course will focus on creating charts, pivot tables, slicers, sparklines and using the vlookup function.

Course Outline

Please note there are two methods to register for this course. Click the Single Registration button to register and pay online. To request an invoice, click the Single Registration button, and then select Checkout. Log in with your account information. Under payment method, select "Request for Invoice." Once you click this option, you must then select "Company Invoice" under Choose Payment Method. You will receive an email with the invoice attached.

Learner Outcomes

Upon successful completion of this course, the participant should be able to create and format a chart, pivot table, and sparkline, as well as use vlookup functionality.

Notes

Credits: Participants will earn .3 CEU, 3 Contact Hours

Attendance Policy: Our classroom training requires attendance during all parts of the instructional program. Instructors are required to take attendance and cannot approve student absences during class time. Please carefully consider your schedule when selecting class dates.

Effective January 1, 2024, the National Association of the State Boards of Accountancy updated their Statement on Standards for Continuing Professional Education. As part of this update, new attendance monitoring requirements for virtual, live classes were established. For students attending a class virtually, a web camera must be turned on for the duration of the session. If you are unable to meet this requirement, we will gladly transfer you to an in-person classroom session. We appreciate your participation in our program and are looking forward to seeing you in class soon.

Field of Study: Computer Software & Applications - Non-Technical

Who Should Attend? This course is for local government accounting and financial reporting professionals and others responsible for oversight and administration of a local government’s finances.

Advance Preparation: None

Program Level: Advanced

Delivery Method: Group Live

University of Georgia, Carl Vinson Institute of Government, is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: https://www.nasbaregistry.org

Contact: For more information regarding refunds, concerns, and program cancellation policies, please contact Sherri Phillips at sherri.phillips@uga.edu.

Prerequisites

None

Applies Towards the Following Certificates

Budget and Financial Management Continuing Education Hours Certificate : Continuing Education (CE)
Finance Officer Level I & II Continuing Education Hours Certificate : Continuing Education (CE)
Level II Finance Officer Certification : Elective Courses