 |
|
|
LabLink User - 1 day
|
|
This course is for all users wanting to access laboratory data using Excel. No direct knowledge of LabPlus or programming skill is required.
|
|
Objectives
|
|
- This course is for all users wanting to access laboratory data using Excel. No direct knowledge of LabPlus or programming skill is required.
- Bring the participants to develop a good knowledge of LabLink capabilities and advanced Excel functions, making them able to configure static and dynamic reports.
|
|
Course Content
|
|
- Introduction to LabPlus
- Introduction to LabPlus data model
- Presentation of LabLink
- Query edition
- Static execution of queries
- Dynamic execution of queries
- Ad hoc report configuration
- Dynamic report configuration
- Excel advanced functions and tools
|
|
Prerequisites
|
|
Knowledge of Excel 2000 or 2003 and Windows environment. |
|
Exercises
|
|
- Select the required fields and choose the correct views
- Edit queries
- Execute a query in dynamic and static manner
- Design reports
- Use Excel's advanced functions in reports
|
|
|
