Book your Excel 2007 Level 3 Training Course

This one day course is being run 30 times between Wednesday 15th February 2012 and Monday 10th September 2012 in Leeds, London, Reading, Glasgow, Bristol, Manchester, Milton Keynes, Birmingham, Edinburgh,

Book this course with us today from as little as £220.50 + VAT and with our price guarantee you can be confident of getting great value. Our team of experienced independent booking administrators will make the joining process painless and by providing feedback on your experiences you’ll also influence the Coursebookers independent course ratings.

See all courses provided by QA

Expert Help

If you would like
advice, or to book, call
one of our experts on
01920 460232

Open: 9am - 5:30pm
Monday- Friday

Locations/dates for this course
DateLocationRatingPrice
Wednesday 15 February 2012LeedsSave £24.50£220.50+VAT
Monday 20 February 2012LondonSave £24.50£220.50+VAT
Monday 20 February 2012ReadingSave £24.50£220.50+VAT
Wednesday 22 February 2012GlasgowSave £24.50£220.50+VAT
Wednesday 22 February 2012LondonSave £24.50£220.50+VAT
Monday 27 February 2012BristolSave £24.50£220.50+VAT
Monday 27 February 2012ManchesterSave £24.50£220.50+VAT
Tuesday 13 March 2012LondonSave £24.50£220.50+VAT
Monday 19 March 2012Milton KeynesSave £24.50£220.50+VAT
Friday 23 March 2012LondonSave £24.50£220.50+VAT
Wednesday 28 March 2012BirminghamSave £24.50£220.50+VAT
Friday 30 March 2012LeedsSave £24.50£220.50+VAT
Thursday 19 April 2012ManchesterSave £24.50£220.50+VAT
Wednesday 25 April 2012BirminghamSave £24.50£220.50+VAT
Monday 30 April 2012LondonSave £24.50£220.50+VAT
Tuesday 08 May 2012EdinburghSave £24.50£220.50+VAT
Friday 18 May 2012LondonSave £24.50£220.50+VAT
Friday 18 May 2012ReadingSave £24.50£220.50+VAT
Thursday 31 May 2012LondonSave £24.50£220.50+VAT
Thursday 07 June 2012LeedsSave £24.50£220.50+VAT
Monday 18 June 2012LondonSave £24.50£220.50+VAT
Monday 25 June 2012ManchesterSave £24.50£220.50+VAT
Wednesday 27 June 2012BirminghamSave £24.50£220.50+VAT
Tuesday 03 July 2012GlasgowSave £24.50£220.50+VAT
Wednesday 25 July 2012LondonSave £24.50£220.50+VAT
Thursday 02 August 2012LeedsSave £24.50£220.50+VAT
Wednesday 22 August 2012LondonSave £24.50£220.50+VAT
Wednesday 29 August 2012BirminghamSave £24.50£220.50+VAT
Wednesday 05 September 2012EdinburghSave £24.50£220.50+VAT
Monday 10 September 2012ManchesterSave £24.50£220.50+VAT
 

Book your course now with Coursebookers!

Making an enquiry to Coursebookers couldn't be easier, just fill out the form to the left or call 01920 460232 and our team will be in touch within 48 hours.

Remember:

  • Not only are we great value, we can also boast no booking fees
  • Human administrators make booking & coordination simple and painless
  • Coursebookers is vendor neutral we can offer unbiased and independent advice
  • If you have complex booking requirements we're happy to help! Call our team on 01920 460232 to discuss your needs
  • We ensure all our courses meet our high standards, meaning you'll only ever see "the best of the best" on Coursebookers!
Download Course Outline

Summary: 

In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.

Objectives: 

You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Lesson 1: Streamlining Workflow

  • Topic 1A: Create a Macro
  • Topic 1B: Edit a Macro
  • Topic 1C: Apply Conditional Formatting
  • Topic 1D: Add Data Validation Criteria
  • Topic 1E: Update a Workbook's Properties
  • Topic 1F: Modify Excel's Default Settings

Lesson 2: Collaborating with Others

  • Topic 2A: Protect Files
  • Topic 2B: Share a Workbook
  • Topic 2C: Set Revision Tracking
  • Topic 2D: Review Tracked Revisions
  • Topic 2E: Merge Workbooks
  • Topic 2F: Administer Digital Signatures
  • Topic 2G: Restrict Document Access

Lesson 3: Auditing Worksheets

  • Topic 3A: Trace Cells
  • Topic 3B: Troubleshoot Errors in Formulas
  • Topic 3C: Troubleshoot Invalid Data and Formulas
  • Topic 3D: Watch and Evaluate Formulas
  • Topic 3E: Create a Data List Outline

Lesson 4: Analyzing Data

  • Topic 4A: Create a Trendline
  • Topic 4B: Create Scenarios
  • Topic 4C: Perform What-If Analysis
  • Topic 4D: Perform Statistical Analysis with the Analysis ToolPak

Lesson 5: Working with Multiple Workbooks

  • Topic 5A: Create a Workspace
  • Topic 5B: Consolidate
  • Data Topic 5C: Link Cells in Different Workbooks
  • Topic 5D: Edit Links

Lesson 6: Importing and Exporting Data

  • Topic 6A: Export Excel Data
  • Topic 6B: Import a Delimited Text File

Lesson 7: Using Excel with the Web

  • Topic 7A: Publish a Worksheet to the Web
  • Topic 7B: Import Data from the Web
  • Topic 7C: Create a Web Query

Lesson 8: Structuring Workbooks with XML

  • Topic 8A: Develop XML Maps
  • Topic 8B: Import and Export XML Data

Description: 

In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.

QA

QA training has over 25 years of experience of supplying high standard training courses in many Business, Management and IT Technical areas. Since 1983 the company has grown to have 25 training centres across the UK offering businesses routes to advance on a local and national level.
QA have a dedicated team of permanent instructors and teaching consultants who constantly improve the courses to ensure the highest possible standard of training is available.

Want to leave your own testimonial? click Here
No Testimonials have been left for this course.

Software Vendor

IT Technical

Business Skills