Excel for Document Controllers - Fundamentals - Level 1A (EXL 1A)

Self-Paced Online Course Module - e-learning


Summary

 

In this course module, we cover fundamental Excel skills for Document Control professionals. We use a case study: How to build a Document Register from scratch

 

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

 

Excel is an important tool of Document Controllers. It is important for Document Controllers to develop competencies in Excel that can boost their performance and raise their profile.

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 the building of a Excel-based Document Register from the ground up.

 

As the register is developed, the course introduces features of Excel, the knowledge of which is an essential competency for Document Controllers.

 

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

 

01) Format text, numbers and dates

02) Rename sheets

03) Build table borders

04) Select multiple, non adjacent cells

05) Create new sheets

06) Change and specify the width of columns and change the height of rows

07) Freeze panes to keep certain rows and columns visible at all times

08) Show only the latest revision of documents in a register

09) Implement dropdown lists to populate cells

10) Operate various options for selecting and copying in Excel

11) Install data filters in a table

12) Use data filters to perform document searches

13) Create a register from scratch

 

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-1A module (Fundamental level) is targeted to:
    • 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.

 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

More modules will be released soon

 

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 2B

Course Code: EXL 2B

Level: Intermediate

AVAILABLE! Read the course brochure

 

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