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 | € 125| Other
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 | € 125| Other
Level: Fundamentals
Course Code: EXL 2B
Availability: This module is available now!
Excel for Document Controllers - Intermediate - Module 2C
-
Case study: Learn to create simple time-saving programming code (macros), create intelligent
dropdown lists that adpat to a pre-specified category, cleverly process dates to create automatic transmittal numbers, create automatic data look-up tools
- Typical Excel-based Document Control tools are used: Document Register, Transmittal Register, large tables/matrices of data
- Read the learning objectives and list of functions covered in Module 2C here
- Level of Excel skills taught in this module: Intermediate
Duration: 3 Hours
Fee: £ 105| $ 150 | € 125| Other
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.
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 |
How?
- Register here
- Upon payment receipt, we send your account details within 2 working days
- 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
