Microsoft Excel Advanced
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 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 (Inc GST) per person.» DatesPlease visit our timetable for current dates.» RegistrationTo register for this course please click here.» More InfomationIf you require more infomation please don't hesitate to contact us.