Call for Latest Dates
Call us on 0870 7777 388 for availability on this course.
Have questions or need a better city/date? Ask now.
|
Course Overview Utilise all aspects of the powerful features included in Microsoft Excel. This course is designed for all users who are required to produce and manipulate advanced analysis of business data. The course is intended for knowledgeable users of Excel and for those users who have been on the Intermediate course. Audience All users who are required to produce and manipulate advanced analysis of business data. The course is intended for knowledgeable users of Excel and for those users who have been on the Intermediate course. Skills Gained - Create advanced spreadsheets for use in the organisation
- Work with external data
- Understand when to use which functions
Course Outline - Advanced "If" statements
- How to use name ranges
- Working with multiple spreadsheets
- Using pivot tables and What if scenarios
- Creating macros
- Linking to external data sources
- Creating templates
- Advanced list management
How to make a booking for the EXELM course
|
