Excel VBA Programming for Clinicians

Learn Excel VBA programming from complete bner to advance levels to help you automate your clinical processes

Learn how to set up your Excel environment for programming

Learn how to record and edit macros using a clinic schedule creator as a working example

Master all Excel objects, including the Cells, Range, Selection, Rows, Columns, ActiveWorkbook, ActiveSheet, Sheets, ActiveCell and Application objects

Develop a full understanding of Variables, including how to name them, how to use them and how to exploit their scope

Become an expert at applying your Boolean Logic skill to Excel programming using Organ Transplant Rejection as an example

Master the Comparison Operators (Equal to, Not Equal To, Greater Than, Less Than etc.) by applying them to the management of patients on the kidney transplant waiting list

Learn the basics of Mathematics in Excel VBA programming by calculating Mean Arterial Pressure, Pulse Pressure, BMI and Medication Prescription doses

Master Conditional 'If Then Else' Statements and 'Select Case' Statements by using a falling patient platelet count (thrombocytopaenia) to trigger clinical actions

Develop a detailed understanding of the 'For Next' and 'For Each' loops by using patient white blood cell count (WBC) to trigger clinical actions

Develop an appreciation of the similarities and differences between the 'Do Until' and the 'Do While' loops using patient white blood cell count (WBC) as a setting

Take your Excel VBA Programming to the next level by exploiting Sub Routine and User Defined Functions

Learn how to display helpful messages to users using the 'Message Box' and learn how to take input from users using the 'Input Box'

Master the art of untangling unstructured clinical text with advanced text (string) manipulation techniques

Master the art of trigger clinical actions by manipulating Dates

Learn how to open, manipulate and close Excel Files through Excel VBA programming

Use a list of Diagnoses to learn how to open, read from and write to text files using nothing but Excel VBA programming

Take your Excel Variables knowledge to the next level by learning all about Arrays, including Static, Dynamic and Two Dimensional Arrays

Master the art of writing Excel VBA programmes that are robust and that handle errors and unexpected inputs gracefully

Consolidate your knowledge with multiple worked examples all from a clinical setting

No previous programming experience required

Some clinical background (doctor, nurse, scientist, physiotherapist, pharmacist etc.) will help you with the exercises but is not strictly necessary

Any relatively modern version of Excel

This course is aimed at clinical colleagues with little or no experience of programming. You might be a doctor or a nurse, a pharmacist, therapist or healthcare scientist and if you are anything like me, you are probably using Excel to manage your patients and your services. There is no getting away from just how useful and powerful it is.

During this course, I assume no programming knowledge. We start together from the absolute fundamentals, with each lesson building on the key concepts learnt in the lesson before until by the end of the course, you can confidently program Excel at an advanced enough level to automate many of your key clinical processes, reduce the risk of manual transcription errors and standardize key tasks. You will:

Learn Excel VBA programming from complete bner to advance levels to help you automate your clinical processes

Learn how to set up your Excel environment for programming

Learn how to record and edit macros using a clinic schedule creator as a working example

Master all Excel objects, including the Cells, Range, Selection, Rows, Columns, ActiveWorkbook, ActiveSheet, Sheets, ActiveCell and Application objects

Develop a full understanding of Variables, including how to name them, how to use them and how to exploit their scope

Become an expert at applying your Boolean Logic skill to Excel programming using Organ Transplant Rejection as an example

Master the Comparison Operators (Equal to, Not Equal To, Greater Than, Less Than etc.) by applying them to the management of patients on the kidney transplant waiting list

Learn the basics of Mathematics in Excel VBA programming by calculating Mean Arterial Pressure, Pulse Pressure, BMI and Medication Prescription doses

Master Conditional 'If Then Else' Statements and 'Select Case' Statements by using a falling patient platelet count (thrombocytopaenia) to trigger clinical actions

Develop a detailed understanding of the 'For Next' and 'For Each' loops by using patient white blood cell count (WBC) to trigger clinical actions

Develop an appreciation of the similarities and differences between the 'Do Until' and the 'Do While' loops using patient white blood cell count (WBC) as a setting

Take your Excel VBA Programming to the next level by exploiting Sub Routine and User Defined Functions

Learn how to display helpful messages to users using the 'Message Box' and learn how to take input from users using the 'Input Box'

Master the art of untangling unstructured clinical text with advanced text (string) manipulation techniques

Master the art of triggering clinical actions by manipulating Dates

Learn how to open, manipulate and close Excel Files through Excel VBA programming

Use a list of Diagnoses to learn how to open, read from and write to text files using nothing but Excel VBA programming

Take your Excel Variables knowledge to the next level by learning all about Arrays, including Static, Dynamic and Two Dimensional Arrays

Master the art of writing Excel VBA programmes that are robust and that handle errors and unexpected inputs gracefully

Consolidate your knowledge with multiple worked examples all from a clinical setting!

Doctors

Nurses

Scientists

Physiotherapists

Pharmacists

Healthcare Professionals

Clinicians

Allied Health Professionals

Healthcare Scientists

Clinical Scientists

Biomedical Scientists

Medical Consultants

Registrars

Medical Practitioners

Midwifes

Dentists

Medical Residents

Anyone keen to learn Excel VBA even if not a clinician




DOWNLOAD
uploadgig


rapidgator


nitro