Chris Chan?
I’m a pharmacist who utilizes Excel VBA to develop pharmacy projects. Since 2018, I had developed over 15 excel VBA projects . I streamlined operations and developed user-oriented applications tailored to my department’s need. My skill in Excel VBA is well-recognized among supervisors and colleagues. My work in excel VBA is appreciated since it brings value to patients, supervisors, colleagues and my department.
What We Do.
If you love to work efficiently with Excel, interested to learn Excel VBA or design applications to tailor users’ need, you’ll find my content useful. Instead of illustrating theories and concepts, I will walk you through my exact process in developing excel VBA projects and explain relevant concepts and techniques. I believe this project-based approach is the best and practical way to learn excel VBA.
My journey as an Excel VBA developer
Back in 2018, I was responsible for gathering patient information for pharmacists to make renal dosage recommendations to physicians. It involved time-consuming steps, such as copying and pasting data into an Excel worksheet manually, formatting and rearranging the data, and manually documenting the recommendation outcomes. Instead of doing all those labour-intensive work by myself, I utilized Excel VBA to streamline the process and reduce these tedious steps. My supervisor was astounded to learn that my Excel VBA skill can be an efficient and powerful tool in streamlining projects. My effort was recognized, and this further granted me countless opportunities in the future.
In 2019, as the main author, I submitted and presented my research findings in a local conference about how my excel application can efficiently and effectively facilitate appropriate renal dosage prescribing. This was how I started my first excel VBA project and it truly changed my life.
