Excel for Document Controllers - Intermediate - Level 2B (EXL 2B)

Self-Paced Online Course



In this course module, we cover intermediate Excel skills for Document Control professionals. We use a case study: how to improve the operability, the ergonomics and the exploitability of a Document Register.


This course targets an audience of Document Controllers who consider themselves as intermediate in the use of Microsoft Excel.

It also is a natural progression for users who consider themselves as beginners and who have already completed course EXL-1A - “Excel for Document Controllers - Level 1A”.


Important: This self-paced webinar is not part of the curriculum to achieve certification


  • 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


  • Wherever you are! The course is online!


The course guides the learner in reducing manual operations and manual data entry in Excel-based Document Registers to a minimum. This is done through automation and streamlining of a number of operations, in order to maximise efficiency. This, in turn, allows Document Controllers to spend more time on value-adding activities.

At the end of the course, the learner will know how to:

01)    Automatically display today’s date on an Excel sheet
02)    Find and remove duplicates in a register
03)    Identify late deliveries by automatically highlighting late documents or late reviews
04)    Filter a register by cell colours, cell patterns and by dates
05)    Protect cells against accidental deletion
06)    Protect and unprotect Excel sheets
07)    Remove conditional formatting
08)    Fix the reference of a cell in a formula
09)    Ask Excel to leave a cell blank if a certain condition is met
10)    Automatically highlight actions a few days before their due date
11)    Use formulas to automatically number documents
12)    Apply a solution when cell formats refuse to change from text to number
13)    Automatically identifying the highest numerical value in a group of cells
14)    Automatically impose capitals letters at the start of each word
15)    Automatically impose capitals letters to an entire piece of text
16)    Automatically impose capitals letters to only a few letters in a piece of text
17)    Automatically impose lower case letters to only a few letters in a text
18)    Combine formulas to ensure the case formatting of a document number



Evidence of completion

 An attestation of completion is provided after completion of the webinar.


What is the target audience of this module?

  • The EXL-2B module (Intermediate level) is targeted at:
    • 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.


  • 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

 Frequently Asked Questions (FAQ)

  • Read the FAQ here

Other available Excel modules

Excel for Document Controllers - Intermediate - Module 1A

Course Code: EXL1A

Level: Beginner

Read the brochure



Excel for Document Controllers - Intermediate - Module 2C

Course Code: EXL 2C

Level: Intermediate

Read the brochure


How long?

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

How much?





£ 105

€ 125


Other currencies:

All Currencies


Singapore Dollars

SGD  195

Australian Dollars

AUD  195


EUR  125

US Dollars

USD  150

Canadian Dollars

CAD  180

Any other currency

Convert to other currencies


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


  • 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


Registration & Enrolment: it's here


Other queries: