Gate Pass Register Data Entry System in Excel
The gate register is the oldest document in most businesses and usually the worst kept. A hardbound book sits on the guard's desk, three shifts write in it in three
VBA
Learn how to automate tasks and create custom functions using VBA (Visual Basic for Applications) in this category. Our tutorials cover basic to advanced VBA programming concepts, including creating user-defined functions and interacting with other Office applications. Each tutorial includes a free practice file and tutorial videos to help you learn easily. Increase your productivity in Excel by automating repetitive tasks with VBA macros and functions. Start exploring this category now and take your Excel skills to the next level.
Medical Equipment Calibration Calendar in Excel
Every hospital biomedical department runs on the same quiet arithmetic. A defibrillator wants its output energy verified each quarter. Ventilator flow sensors want recalibrating. Anaesthesia workstations want a half-yearly leak
Teacher Substitution Data Entry System in Excel
The cover book is where a school's admin day quietly leaks. A teacher phones in at 7:40, someone scribbles a name on a printed timetable, a supply teacher is rung,
Uniform Sales Data Entry System in Excel
The Uniform Sales Data Entry System in Excel runs an entire uniform order book from a 7-field VBA form with 4 action buttons, feeding a 10-column register and 4 live
Dialysis Session Calendar in Excel
A dialysis unit runs on a timetable that never stops. Four shift blocks a day, isolation slots that cannot move, an RO plant that has to be sanitised on schedule,
Blood Donation Camp Calendar in Excel
The Blood Donation Camp Calendar in Excel is a macro-enabled workbook of 7 worksheets that turns a single camp table into 5 linked scheduling views. It arrives with 100 sample
Sports Event Data Entry System in Excel
Every club secretary and PE teacher knows the shoebox. Paper entry slips, a WhatsApp thread, three text messages and a note on the back of an envelope - and somewhere
Influencer Outreach Data Entry System in Excel
Influencer outreach falls apart in the same place every time: not in the pitch, but in the record of it. A DM here, a spreadsheet column there, an e-mail thread
Pharmacy Stock Expiry Calendar in Excel
The Pharmacy Stock Expiry Calendar in Excel is a macro-enabled workbook of 7 worksheets that turns a single list of expiry-control activities into 5 linked calendar views. It arrives with
Doctor On-Call Calendar in Excel
Most hospital on-call rotas are published as a Word table, emailed on the 25th of the month, printed once, and then argued about for four weeks. The information is fine.