Courses / Excel - Advanced
Excel - Advanced
- Provider
- Desktop Training & Development Ltd
- Summary
- 1 day advanced course on MS Excel spreadsheets, held in Ipswich
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
- To demonstrate Excel's more powerful functions including data analysis, scenario manager and macros
- Content
- Databases
- database terms
- advanced filter
- unique records
- calculated fields in lists
- database functions.
Pivot Tables- creating a pivot table
- modifying a pivot table
- formatting data
- refreshing data
- using the drill down facility
- sorting & filtering data
- adding calculated fields
- grouping data.
Conditional Statements- Excel’s logical functions
- creating conditional tests
- using formulae within conditional tests
- nesting conditional statements.
Multiple Files- working with multiple files
- displaying multiple files
- moving & copying worksheets
- creating formulas between multiple files
- editing linked formulae
- consolidating data
- setting up a consolidation
- consolidation by position
- consolidation by category.
Scenario Manager- creating a scenario
- displaying scenarios
- editing scenarios
- creating scenario reports.
Macros- recording simple macros
- macro storage
- running macros
- absolute & relative references
- assigning shortcuts to macros
- creating a macro button
- viewing VBA code.
A comprehensive course manual provides support throughout the course and upon your return to the office. - Cost
- Contact Desktop Training for details
- Enrolment
- Telephone, fax or write to Desktop.
- Website
- www.desktoptraining.co.uk
Availability
- Starts
- 21st Sept, 20th Oct, 06th Dec 2011. 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
Courses
Syndicate
