This video shows how to enter values into cells using Excel macros and Visual Basic. This includes a sample Expense Report that is used in this demonstration. In this demonstration, we will create the macro that inputs a title as "Expense Report", Three columns i.e. "Date", "Item" & "Amount", and the summery field as "Total Expenses", as well as the formulas located at the respective cells. Now, we're going to use two keyboard shortcuts i.e. "Alt + F11" to open-up the VBA window and "Alt + F8...
As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 58th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate interest revenue and expense.
If you're driving a commercial vehicle or doing a lot of driving for a company, there are ways to claim deductions on your tax return for actual vehicle expenses. In this video you will learn how to calculate your standard mileage rates to determine how much you will be getting on your tax refund if your employer is not reimbursing you for gas or if you're running a small business.
Living within your means can be done. You don't want to be a slave to the credit card company, do you? Learn what to do to stay out of credit card debt. This how to video will give you the tips. Credit card debt is a slippery slope.
These days, everyone is trying to save money wherever possible. Health care is often one of our biggest expenses and in this tutorial, you will get some expert tips on how to lower your expenses and save money on health care.
This medical how to video demonstrates how to take an arterial blood gas sample. The purpose or arterial gas sampling is to assess the patient's respiratory status as well as the acid/base balance in their blood. To perform this medical procedure you will need the following instruments: protective eye wear, gloves, alcohol, iodine, arterial blood gas sampling kit, gauze and a bag of ice. Please not that this video is intended for medical professionals only.
Here are several bizarre occurrences that are believed to have happened all over the world. You gotta hear about these!
June is graduation month, and while for a lot of youngsters that means leaving one phase of their lives behind in order to pursue newer and greater things at college/the workplace, for their relatives and friends that means cards, presents, and money.
A calf strain is a tearing or stretching of the calf muscle. It is generally due to trauma or overuse. Symptoms are localized pain, decreased range of motion, and tightness in the area. Learn more about calf strains including treatments and symptoms in this medical video.
Studying to be a pediatric nurse? Then here is a nursing how-to video that teaches you how to assess a five year old's medical condition. Every nurse should know the basics of this technique, follow along and see how easy it is to read a five year old's vital signs. These medical tips are sure to help you pass your nursing exam with flying colors.
This medical how-to video demonstrates how to perform an examination of a traumatized hand. Doing such procedure can be a daunting task, as there may be several structures that may have been injured. Follow along as this resident surgeon shows you what guidelines to follow when examining a hand and wrist. Please note that this medical video is intended for medical professionals only.
This medical how-to video reviews the basics of casting and splinting procedures. Follow along and learn how to splint and cast the wrist and forearm in case of a broken or fractured bone. A splints and casts can be placed in many different positions and aid in stabilizing injuries. Note that this medical procedure is intended for medical professionals.
In this video tutorial, you'll learn the ancient art of clay tablet making. Back in the old, old, days, before paper and pencil, there were clay tablets. Sumerians used these clay tablets to communicate, record business expenses and more. In this video, you'll learn how to make your own cuneiform clay tablet magazine! Spread the word!
Building a swing arbor is a fun weekend project that can really spruce up the landscape without requiring a lot of out-of-pocket expense. Plus, the project is fairly easy to build, requiring only basic carpentry skills, and can provide years of outdoor enjoyment. The materials for the swing cost about $100, and you can complete the project over the course of two afternoons. For more information, or to get started building your own swing arbor, watch this DIY video tutorial.
Take a look at this instructional video and learn how to use simple formulas in Microsoft Office Excel 2007 to add, subtract, multiply, and divide. For example, you can use a prewritten formula called the SUM function to find totals, such as your total monthly expenses. Excel updates the results if the numbers change later.
Food poisoning, also referred to as food-borne illness, is a gastrointestinal disorder that results from eating contaminated food. . Who is at risk? Anyone can get food poisoning, especially travellers and those who live in tropical climates. Infants, elderly people, and those with serious medical conditions have the greatest risk if they get food poisoning. Pregnant and breastfeeding women also need to be especially careful. Learn about the different causes, symptoms, and treatments of food ...
Septic shock is a serious and often life threatening emergency medical condition in which the blood pressure is extremely low. Insufficient blood therefore reaches the body tissues and this means that not enough oxygen and nutrients are delivered to the body. Medical shock is a serious circulatory condition not to be confused with emotional shock or surprise. Learn more about shock and the symptoms in this medical how-to video.
This medical how-to video demonstrates the proper technique for evaluating a patient with knee pain. Follow along and learn how to do a knee examination. Always begin the knee exam with the patient standing and observe any abnormalities. Please note this instructional video is intended for medical professionals.
Even getting your hair trimmed at the salon costs a fortune these days, so why not cut back on unnecessary expenses and do the trimming at home? Take a look at this video to learn how to cut edgy side bangs using a razor.
Any medical student should be able to perform a basic cardiovascular exam. This medical how-to video tutorial outlines the guidelines to perform a basic cardiovascular exam. Always begin by by observing the patient from head to toe. Inspect the face for signs of cyanosis. Note visible scars or pulsations in the neck and edema in the feet. This video is intended for medical professionals only.
An important part of surgery is knowing the various types of closures to perform. This medical how-to video demonstrates how to do a deep dermal suturing technique. The deep dermal technique is especially good for laceration repair or wound closure in the operating room. Follow along with the medical video to learn the deep dermal closure technique.
Studying to be a pediatric nurse? Then here is a nursing how-to video that teaches you how to effectively communicate with child patients using medical play. Every nurse should know the basics of this technique, follow along and see how easy it is to assess the status of child patient with play. These medical tips are sure to help you pass your nursing exam with flying colors.
Identity theft typically occurs when someone uses your personal information such as social security numbers, credit card numbers or account information to perform various misdeeds, and you are left to clean up the mess.
In this medical-minded how-to from the folks at ICYou Health Videos, you'll learn how to tell whether you have hemorrhoids and, if you do, how to determine whether you should see a medical professional for treatment. For
This medical how-to video gives you tips on obtaining venous blood samples. Follow along and learn how to obtain blood samples with a venipuncture procedure. This procedure is very common in the medical field. To start venipuncture you need to have the needles, vacuum container, and blood tubes ready. Watch to learn the step by step process.
This medical how-to video demonstrates how to catheterize males and females with a Foley catheter. Follow along and learn how insert the catheter into a bladder using mannequins. The first part of the video shows a female Foley catheterization and the second half shows the male version of this medical procedure.
This video tutorial shows how to set up an intravenous line, or intravenous drip. Most are familiar with IVs, as a way of providing people undergoing medical treatment that are otherwise unable to ingest food with vital nutrients. Watch this educational medical science video and learn how to set up and insert an intravenous line.
This medical how-to video demonstrates how to perform a cast removal with a cast saw. Follow along and learn how to remove a wrist and forearm cast. The cast saw may appear dangerous but it is actually pretty safe to use. A cast should only be removed when the attending doctor deems it safe to do so. Note that this casting procedure is intended for medical professionals.
This medical how-to video demonstrates how-to suture an open wound. Follow along and learn the step by step process of closing open skin. Note that suturing should be performed by a medical professional.
This medical how-to video demonstrates the proper technique for evaluating a patient's shoulders. Follow along and learn how to do a shoulder physical examination. As with all examinations of the joints it is important to follow a standard routine including range of motion, inspection, and to compare the affected shoulder to the unaffected shoulder. Please note this instructional video is intended for medical professionals.
Venepuncture is the process of collecting venous blood. Or more simply, it's the process of drawing blood from a vein for medical testing. Watch this video medical health tutorial and learn how to prepare and perform venepuncture.
This how to video demonstrates how to do a male Foley catheter insertion. Before beginning any catheterization procedure make sure to properly identify the patient, wash your hands, and that all the supplies are handy. Watch and learn how to properly insert a Foley catheter in a man. This medical how-to video is intended for medical students and professionals.
This how to video demonstrates how to do a female Foley catheter insertion. Before beginning any catheterization procedure make sure to properly identify the patient, wash your hands, and that all the supplies are handy. Watch and learn how to properly insert a Foley catheter in a woman. This medical how-to video is intended for medical students and professionals.
ER showed the world what goes on inside the emergency room, and in every episode, we experienced a common but very important procedure— intubation. But ER never made it seems easy; it showed just how hard it is for medical students to successfully intubate a patient due to fear and naivety. And for real-life doctors and medical practitioners, learning the art of airway management is just as difficult.
Zently — the mobile app for renters — is taking on Venmo with its newest feature. Traditionally used to automate rent payments, deliver rent checks for free, and communicate with your landlord, it now allows you to connect to your bank account and split bills with housemates. Following the addition of Zelle to several major banks apps — to allow users to transfer money to their contacts — the battle of the mobile payment apps is getting increasingly fierce. With this new update, Zently is als...
The MCL or the medial collateral ligament is a thick fibrous tissue that spans the distance between the bottom of the thigh bone and the top of the tibia on the inside of the knee joint. A MCL injury is caused by stretching or tearing of the MCL ligament in the knee. Learn more about the causes, symptoms and treatments for a MCL injury in this medical how-to video.
This medical how-to video demonstrates how to perform a endoscopic Zenker's diverticulostomy with cricopharyngeal myotomy. Watch and learn how it is done. This Diet & Health videos is intended for medical students and patients who will be have this procedure done.
This medical how-to video demonstrates a bilateral lymph node dissection in a patient with endometrial cancer using the da Vinci system with the HD optical system. The HD optical system allows surgeons to perform more precise anatomical dissections with enhanced dexterity. Watch and learn how a dissection of a lymph nodes is performed on a patient. This surgical video is intended for medical students.
This medical how-to video details a robotic assisted hysterectomy in a patient with early stage endometrial/uterine cancer. Anatomy of the pelvis and the technique of a robotic hysterectomy is demonstrated. Watch and learn the surgical techniques used to performed a robotic hysterectomy on a patient using a da Vinci System. This surgical video is intended for medical students.
This medical how-to video details a laparoscopic extraperitoneal aortic lymph node dissection. Watch and learn how to perform this surgical procedure on a patient. This surgical video is intended for medical students.
