Description
This course is aimed at healthcare 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 processesLearn how to set up your Excel environment for programmingLearn how to record and edit macros using a clinic schedule creator as a working exampleMaster all Excel objects, including the Cells, Range, Selection, Rows, Columns, ActiveWorkbook, ActiveSheet, Sheets, ActiveCell and Application objectsDevelop a full understanding of Variables, including how to name them, how to use them and how to exploit their scopeBecome an expert at applying your Boolean Logic skill to Excel programming using Organ Transplant Rejection as an exampleMaster 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 listLearn the basics of Mathematics in Excel VBA programming by calculating Mean Arterial Pressure, Pulse Pressure, BMI and Medication Prescription dosesMaster Conditional 'If Then Else' Statements and 'Select Case' Statements by using a falling patient platelet count (thrombocytopaenia) to trigger clinical actionsDevelop a detailed understanding of the 'For Next' and 'For Each' loops by using patient white blood cell count (WBC) to trigger clinical actionsDevelop 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 settingTake your Excel VBA Programming to the next level by exploiting Sub Routine and User Defined FunctionsLearn 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 techniquesMaster the art of triggering clinical actions by manipulating DatesLearn how to open, manipulate and close Excel Files through Excel VBA programmingUse a list of Diagnoses to learn how to open, read from and write to text files using nothing but Excel VBA programmingTake your Excel Variables knowledge to the next level by learning all about Arrays, including Static, Dynamic and Two Dimensional ArraysMaster the art of writing Excel VBA programmes that are robust and that handle errors and unexpected inputs gracefullyConsolidate your knowledge with multiple worked examples all from a clinical setting!
