Streamlining Workflow: Create & edit macros, Visual Basic for Applications, Visual Basic Editor Window, customising Access to Excel commands, applying conditional formatting, adding data validation criteria, update workbook’s properties, modifying excel’s default settings
Collaborating with Others: Protecting files, sharing workbooks, setting revision tracking, review tracked revisions, merge workbooks, adjust macro settings, digital signatures, digital certificates
Auditing Worksheets: Trace cell Precedents, trace cell dependants, locate errors in formulas, invalid data, error checking, watch and evaluate formulas, group and outline data
Analysing Data: Trend lines, scenarios, goal seek, solver, PivotTable reports, PivotChart reports, Analysis ToolPak
Working with Multiple Workbooks: Workspaces, data consolidation, link cells in different workbook, edit links
Importing and Exporting Data: Export to Microsoft Word, import Word table, import text files
Structuring XML Workbooks: Develop XML maps, import/add/export XML data, manage XML workbooks, apply XML view options