Upon successful completion of this course, students will be able to:  Create and edit a Macro, apply conditional formatting, add data validation criteria, update a workbook’s properties and modify Excel’s default settings.  Protect your worksheet and workbook and add and remove file passwords. Share workbooks, set and review tracked revisions, merge workbooks, and administer digital signatures.  Trace cells, locate errors in formulas, troubleshoot invalid data and Formulas, watch and evaluate formulas and create a data list outline.  Create a Trendline, Scenarios, perform What-If Analysis.  Create a workspace and consolidate data, link and edit cells in different workbooks.  Export Excel data and import a delimited text file. Develop XML maps and import and export XML data.