Microsoft Excel 2010 Training Course Advanced Norwich

This course teaches you how to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data. You will learn how to automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, troubleshoot errors, collaborate on worksheets, and share Excel data with other applications.

After completing this course you will have learnt how to enhance productivity and efficiency by streamlining the workflow, collaborate with other workbook users, audit worksheets, analyze data, work with multiple workbooks, import and export data, integrate Excel data with the web and structure workbooks with XML.

Microsoft Excel 2010 Training Course (Advanced) Outline - Norwich

Streamlining 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

Analyzing 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

Norwich Cavell House Stannard Place St. Crispins Rd Norwich NR3 1YE UNITED KINGDOM The centre is located beside the inner ring road, which links directly with all main arterial routes exiting Norfolk. Norwich has train networks nearby that have direct links to London Liverpool Street (2 Hours) and Cambridge (1 Hour). Ideally situated for your Advanced Microsoft Excel 2010 Training Course. Alternatively if you live in and around Norwich and wish to have your training on-site the we can provide all the equipment, included laptops & projector, required. All we ask is that you provide a little space for the trainer to set up.

To see more details as to our Training Venues click one of the links below: Cambridge | Birmingham | Milton Keynes | Norwich | Peterborough Luton | Ipswich | Brentwood | Northampton | Leicester