Microsoft Excel Advanced - 2003 or 2007 Versions available.
This course aims to enhance your computer productivity by giving you advanced skills in the use of Microsoft Excel. It is designed to introduce you to the techniques associated with effective spreadsheet operation and to get you going in the advanced features of Microsoft Excel as quickly as possible. Course Outline Importing Data Importing Data from External Sources Importing Text Files Using Microsoft Query Querying Data from the Web Refreshing Data Templates and Styles Working with Templates Working with Styles Analysing Data What-if Analysis Goal Seek Data Tables Scenario Manager Solver Using Pivot Tables Macros and Custom Controls Working with Macros Running Macros Adding Custom Controls Security and Proofing Security Features Protecting Excel Files Worksheet Protection Working with Digital Signatures Checking Spelling Using Data Validation Using Text to Speech Documentation Customising Excel 2003 / 2007 Configuring Excel 2003 Options Customising the Excel Environment Working with Workspaces Collaboration and Consolidation Sharing Workbooks Sending Workbooks Consolidation» PrerequisitesAttendees should have already completed our Microsoft Excel Intermediate course or have skills to that level.» AssessmentOn completion of this course, attendees will be provided with a Certificate of Participation.» Duration1 Day - 9:00am to 4:00pm.» Cost$299.00 per person.» DatesPlease visit our timetable for current dates.» RegistrationTo register for this course please click here.» More InformationIf you require more information please don't hesitate to contact us.