Computer Tutoring Logo
Est. 2002
Menu Button

Number Students?
Laptop hire?
Offsite training?

Per Person £ *
Total Price:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

If you are interested in this course fill out the following form for further details:

First Name:

Last Name:

Email:

Tel:

Location:

Num Students:
First NumberPlusSecond Number  = 
Please enter the answer to prove that you are human and not a machine.

Testimonials

Keronite PLC

"Great!!! Learned lots."

DHL Exel Supply Chain

"Training was delivered well and all my questions were answered very well."

Norfolk County Council

"Excellent."

Viridor Waste Ltd

"It was very good, I felt relaxed and was able to proceed at my own pace."

Microsoft Excel 2010 Training Course Advanced

This training 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 the training you will have learned how to enhance productivity and efficiency by streamlining the workflow, collaborate with other workbook users, audit worksheets, analyse data, work with multiple workbooks, import and export data, integrate Excel data with the web and structure workbooks with XML.

Other Excel training courses

Course Duration: 1 Day

Course Outline

Streamlining Workflow using Microsoft Excel 2010

  • Update Workbook Properties
  • Create a Macro
  • Edit a Macro
  • Apply Conditional Formatting
  • Add Data Validation Criteria

Collaborating with Other Users in Excel 2010

  • Protect Files
  • Share a Workbook
  • Set Review Tracking
  • Review Tracked Changes
  • Merge Workbooks
  • Administer Digital Signatures
  • Restrict Document Access

Auditing Worksheets using Excel 2010

  • Trace Cells
  • Troubleshoot Invalid Data and Formula Errors
  • Watch and Evaluate Formulas
  • Create a Data List Outline

Analyzing Data in Excel 2010

  • Create a Trendline
  • Create Sparklines
  • Create Scenarios
  • Perform a What-If Analysis
  • Perform a Statistical Analysis with the Analysis ToolPak

Working with Multiple Workbooks in Excel 2010

  • Create a Workspace
  • Consolidate Data
  • Link Cells in Different Workbooks
  • Edit Links

Importing and Exporting Data using Excel 2010

  • 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 using Excel 2010

  • Develop XML Maps
  • Import and Export XML Data

Advanced Excel Prices from:

If you are interested in this course but want to know the price beforehand then use the the following form to calculate how much.

Number Students?
Laptop hire?
Offsite training?

Per Person £ *
Total Price:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

If you are interested in this course fill out the following form for further details:

First Name:

Last Name:

Email:

Tel:

Location:

No. Students:

First NumberPlusSecond Number  = 
Please enter the answer to prove that you are human and not a machine.



Microsoft Excel 2010 Training Course Advanced