Data Entry
I am utilizing MS Excel to input detailed information for products that have a six-month expiry date. This enables me to conveniently monitor and identify which items need to be removed from the shelves three months before their expiration.
To ensure that the sales figures are accurate, I am utilizing MS Excel to record the daily credit card sales of the pharmacy. This entails cross-referencing sales data from our system with a credit card machine.
Every day, I am using MS Excel to compile a list of items that are not available in our pharmacy, which helps me to track prescriptions lost due to unavailability.
I am inputting the details of both walk-in patients and patients under insurance into MS Excel to generate our daily sales report. This allows me to conveniently compare and check our daily sales figures.