Excel for Document Controllers

Self-paced Learning


Summary

Self-paced learning modules on Excel, specifically designed for Document Control professionals

  • 3-hour web-based modules
  • Step-by-Step guided tutorials: Develop robust skills and build powerful, efficient and time-saving Document Control tools
  • Self-paced: study when you can and where you can
  • Fully flexible: each module can be booked individually

Modules

All modules are based on a case study: how to build powerful Document Control tools with Excel (Document register, reports & statistics, distribution matrix / RACI charts, transmittal sheets, registers of transmittals, etc)

 

The syllabus is designed so that you can learn step by step, starting with fundamentals and progressing to advanced and very advanced skills, module after module.

 

 Excel for Document Controllers - Fundamentals - Module 1A

  • Case study: Build a Document Register from scratch
  • The Document Register is a critical tool for all Document Controllers. It is used as an example to develop your Excel skills in this module
  • Read the learning objectives and list of functions covered in Module 1A here
  • Level of Excel skills taught in this module: Basic / Fundamental

Duration: 3 Hours 

Fee: £ 105| $ 150 | € 125Other

Level: Fundamentals

Course Code: EXL 1A

 

Availability: This module is available now!

 

 Excel for Document Controllers - Intermediate - Module 2B

  • Case study:  Improve the operability, the exploitability and the ergonomics of a Document Register
  • The Document Register is a critical tool for all Document Controllers. It is used as an example to develop your Excel skills in this module
  • Read the learning objectives and list of functions covered in Module 2B here
  • Level of Excel skills taught in this module: Intermediate

Duration: 3 Hours 

Fee: £ 105| $ 150 | € 125Other

Level: Fundamentals

Course Code: EXL 2B

 

Availability: This module is available now!

 

 Excel for Document Controllers - Intermediate - Module 2C

Duration: 3 Hours 

Fee: £ 105| $ 150 | € 125Other

Level: Fundamentals

Course Code: EXL 2C

 

Availability: This module is available now!


 

Pre-Requisites

  • No formal qualification or experience required
  • Courses are delivered in English: a functional level in English language is recommended
  • You will need access to a computer, with MS Excel (2007 and later versions) installed

What does Fundamental, Intermediate or Advanced mean?

  • There are 3 levels of courses:
  • Fundamental - Target audience is:
    • Beginners in Excel who wish to learn the basics.
    • Users who can use and populate Excel documents, but who have never had the opportunity to design, to modify, and to improve Excel Document Control tools.
    • Users who know no Excel formulas or just a few Excel formulas, and who wish to learn a few useful formulas for Document Controllers.
    • Beginners who wish to learn basic tricks for formatting cells, re-sizing cells.
    • Users who wish to learn to create dropdown lists, to filter data and to perform document searches.
  • Intermediate - Target audience is:
    • Excel users who have had some experience with:
      • Creating, using and modifying Excel files
      • Using formulas
      • Making Excel files user-friendly
    • and who wish to learn clever Excel tricks to improve their performance, their productivity and their efficiency.
    • Users who wish to reduce manual operations as much as possible.
    • Intermediate users who are not yet familiar with macros (customised code programming using Visual Basic for Applications).
  • Advanced Target audience is:
    • Experienced Excel users who wish to powerfully automate their Document Control tools and/or operations even further.
    • Experienced users who wish to learn clever formulas and tricks for their Document Control tools.
    • Experienced users who wish to link the operation of various sheets in Excel for maximum performance and to an almost “database-like” level.

 

Frequently Asked Questions

  • Read the FAQ here

When?

  • It's up to you!
  • Accessible 24/7
  • Start whenever you are ready
  • Self-paced: start, pause, skip back, skip ahead at your own pace
  • You have a lifetime access to your course

 Where?

  • Wherever you are! The course is online!

How long?

  • The course is designed so that it takes participants about 3 hours to complete both theory and practice.

Course Fee

Cost per module:

In USD

In GBP

In EUR

$150

£ 105

€ 125

 

Other currencies:

All Currencies

Price

Singapore Dollars

SGD  195

Australian Dollars

AUD  195

Euros

EUR  125

US Dollars

USD  150

Canadian Dollars

CAD  180

Any other currency

Convert to other currencies

 

 

How?

 

  1. Register here
  2. Upon payment receipt, we send your account details within 2 working days
  3. You access your course on our online e-learning platform

Note:

  • Course material is online only
  • You have a lifetime access to your course

How do I pay?

 

You have several options:

  • Debit or Credit Card
  • Bank Transfer
  • Paypal

Client References