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

Self-Paced Online Course Module - e-learning


Summary

 

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”.

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!

Content

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

 

 

Certificate

  • A certificate of completion is sent by email immediately upon completion of the module

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.

 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

 Frequently Asked Questions (FAQ)

  • Read the FAQ here

Other Modules

Excel for Document Controllers - Intermediate - Module 1A

Course Code: EXL1A

Level: Beginner

Available!   Read the brochure

 

Excel for Document Controllers - Intermediate - Module 2A

Course Code: EXL 2A

Level: Intermediate

Availability: to be released soon - Subscribe to know when it's out

This Module can be taken before or after the other Level 2 Modules. 

 

Excel for Document Controllers - Intermediate - Module 2C

Course Code: EXL 2C

Level: Intermediate

Availability: to be released soon - Subscribe to know when it's out

 

Excel for Document Controllers - Advanced - Module 3A

Course Code: EXL 3A

Level: Advanced

Availability: to be released soon - Subscribe to know when it's out

 

How long?

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

How much?

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

Queries?

Registration & Enrolment: it's here

 

Other queries:

customersupport@consepsys.com