MOS: Microsoft Excel 2007

Organizing and Analyzing Data

à  Use subtotals

à  Define and apply advanced filters

à  Group and outline data

à  Use data validation

à  Create and modify list ranges

à  0%; font-family: ">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