With the skills of Excel I as the foundation, you can now work with some more advanced features of Excel and learn how to:

• Use function and auditing features to create advanced formulas and audit worksheets
• Use PivotTables and other analysis tools to analyze data
• Use comments to collaborate with others
• Customize your workbook by applying conditional formatting, adding data validation criteria, customizing menus and toolbars, creating and editing macros; and grouping and outlining structured data
• Work with multiple workbooks to create a workspace, consolidate data, link cells, edit links, export Excel data into XML, import XML data into Excel, and create a Web query
• Use multiple graphic objects to enhance your worksheet

Prerequisite: Microsoft Excel I.