MICROSOFT EXCEL 2003 EXPERT TRAINING COURSE Office Specialist exams provide a valid and reliable measure of technical proficiency and expertise by evaluating your overall comprehension of Office programs, your ability to use their advanced features, and your ability to integrate the Office programs with other software programs.

Objectives	Advanced	Super Advanced
Organizing and Analyzing Data Use subtotals Define and apply advanced filters Group and outline data Use data validation Create and modify list ranges Add, show, close, edit, merge and summarize scenarios Perform data analysis using automated tools Create PivotTable and PivotChart reports Use Lookup and Reference functions Use Database functions Trace formula precedents, dependents and errors Locate invalid data and formulas Watch and evaluate formulas Define, modify and use named ranges Structure workbooks using XML	√ √ √ √ √ √ √ √ √ √ √ √ √ √ √
Formatting Data and Content Create and modify custom data formats Use conditional formatting Format and resize graphics Format charts and diagrams	√ √ √ √
Collaborating Protect cells, worksheets, and workbooks Apply workbook security settings Share workbooks Merge workbooks Track, accept, and reject changes to workbooks		√ √ √ √ √
Managing Data and Workbooks Import data to Excel Export data from Excel Publish and edit Web worksheets and workbooks Create and edit templates Consolidate data Define and modify workbook properties		√ √ √ √ √ √
Customizing Excel Customize toolbars and menus Create, edit, and run macros Modify Excel default settings		√ √ √

Booking Information Courses are offered on the availability of students. If you are interested in one of these courses then please click on the e-mail link: (Please specify the course in your email enquiry) Back to Top