Courses / Advanced Excel for Finance Personnel
Advanced Excel for Finance Personnel
- Provider
- Desktop Training & Development Ltd
- Summary
- 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.
About the Course
- Target
- Delegates with a good working knowledge of Microsoft Excel who can produce multi-sheet workbooks and work with a range of Excel functions.
- Entry requirements
- Delegates should have attended the Intermediate course or gained similar knowledge in the workplace
- Outcome
- Content
- 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
- Use the Subtotal function to easily create totals.
- Cost
- Contact Desktop Training for details
- Enrolment
- Telephone, fax or write to Desktop.
- Website
- www.desktoptraining.co.uk
Availability
- Starts
- Please contact provider for further dates
- Duration
- 1 Day
- Timetable
- 9.30am - 4.30pm
- Provider
- Desktop Training & Development Ltd
Venues/Contact
Main (View map)
11 Beta Terrace
Masterlord Office Village
Ransomes Europark
Ipswich, Suffolk
IP3 9FE
UNITED KINGDOM
Telephone 0845 1188150
Email info@desktoptraining.co.uk
Website http://www.desktopcourses.co.uk
Venue Notes 0
Courses
Syndicate
