Excel 2003 Advanced
Categories: Microsoft Excel
At the end of the course the delegate will be able to:
- Import and export data using a variety of methods 
- Save a worksheet as a web page 
- Create and use hyperlinks within workbooks 
- Use auditing tools to validate data and to audit data dependency 
- Ac dependency 
- Achieve advanced data management using advanced filters, consolidation, outlines and queries 
- Create PivotTables and PivotChart reports 
- Analyse data using goal seek, solver and the scenario manager 
- Password protect and share files 
- Record and run a basic macro 
- Customise toolbars and menus
 
Course Dates
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
The course either has new dates in data loading, or is only run as a dedicated or In Company course.
Tools
 
Key Details
Provided by:
Premier IT


 
Duration1 day
 
£225
per delegate