Advanced Excel For Finance Personnel

Course duration

1 day

Course timings

9:30-16:30

Prerequisites

Delegates should have attended the Intermediate course or gained similar knowledge in the workplace

Training formats

Scheduled course · private course · tailored · 1 to 1 (all instructor led)

Manuals

A comprehensive course manual provides support throughout the course and upon your return to the office.

Calendar

Click here to see the Excel courses calendar

This course is for finance personnel who work with Excel on a regular basis and want insights into how to use the product faster and more effectively.

 

• Print
• Download pdf

Course Topics

• Use the Subtotal function to easily create totals.
• Manipulate information in PivotTables including advanced PivotTable features.
• Work with PivotCharts.
• Edit with cut, copy and paste special.
• Build database queries (SQL queries, the query wizard, and links to ODBC capable databases).
• Use VLOOKUP and HLOOKUP to deal with information in tables.
• Record simple Excel macros to speed up repetitive tasks.
• Validate data.
• Work with array formulas.
• Use string arithmetic.
• Format with zeros rather than dashes when using the accounting format and other options.
• Use custom number format to label your totals.
• Use advanced sum formulas - SUMPRODUCT, SUMIF, etc.
• Save time with Excel keystroke shortcuts (hot keys).