0   reviews on Udemy

Excel VBA Programming for Clinicians

From absolute beginner to mastery of Excel VBA programming in a single course with me Dr Delordson Kallon!
Course from Udemy
 2 students enrolled
 en
Learn Excel VBA programming from complete beginner 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

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 beginner 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!

Excel VBA Programming for Clinicians
$ 84.99
per course
Also check at

FAQs About "Excel VBA Programming for Clinicians"

About

Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers.

SOCIAL NETWORK