|What or Who:||Where:|
Event DetailsStreamlining Workflow.
-Update Workbook Properties -Create a Macro -Edit a Macro -Apply Conditional Formatting -Add Data Validation Criteria -Collaborating with Other Users
Protect Files - Share a Workbook - Set Revision Tracking - Review Tracked Revisions - Merge Workbooks - Administer Digital Signatures - Restrict Document Access - Auditing Worksheets Trace Cells - Troubleshoot Invalid Data and Formula Errors - Watch and Evaluate Formulas - Create a Data List Outline - Analysing Data - Create a Trendline - Create Sparklines - Create Scenarios - Perform a What-If Analysis - Perform a Statistical Analysis with the Analysis ToolPak - Working with Multiple Workbooks Create a Workspace - Consolidate Data - Link Cells in Different Workbooks - Edit Links Importing and Exporting Data
- Export Excel Data - Import a Delimited Text File - Integrating Excel Data with the Web Publish a Worksheet to the Web - Import Data from the Web - Create a Web Query - Structuring Workbooks with XML Develop XML Maps - Import and Export XML Data
Upon successful completion of this course students will be able to:
-Enhance productivity and efficiency by streamlining the workflow
-Collaborate with other workbook users
-Work with multiple workbooks
-Import and export data
-Integrate Excel data with the web
-Structure workbooks with XML
This course is designed for students wishing to gain the skills necessary to create macros, collaborate with others, audit and analyse worksheet data, incorporate multiple data sources and import and export data.
To ensure your success we recommend that you first take the following courses or have equivalent knowledge:
-Excel 2010 Level 1
-Excel 2010 Level 2.
Dates and Times