ADVANCED: Create and edit macros; conditional formatting; apply data validation criteria; able to protect, share and merge files; trace cells and troubleshoot formula errors; uses data lists outline; consolidate date and link workbooks; export and import text files and XML data; import data from the Web and create queries; analyze data using trend line, spark lines and scenarios. Additional duties including, but not limited to: answering the telephone, sending and receiving e-mail, processing mail, faxing documents, preparing documents, reports, and time sheets, performing data entry, preparing and monitoring bills, and ordering of department's office supplies.