How to Create Interactive SharePoint Charts With Zero Coding

Using Microsoft SharePoint 2010 chart web part, you can quickly create charts with data from SharePoint Lists and other data sources. Here’s how.

Microsoft SharePoint 2010 comes with a built in Chart Web Part, which lets you build interactive charts quickly, and without writing a single line of code, using data from various sources, such as SharePoint lists, Microsoft Excel spreadsheets, SQL Server databases, and so on. This offers a major advantage, letting you add interactive charts to presentations in a jiffy. Here’s how you can go about creating a chart with this handy tool.

  1. Create a Microsoft SharePoint custom list and give it a name. Include 3 custom columns, all of which should be of type – Single Line of Text.
  2. Once the list is ready, add some data to it.
  3. Create a new page in SharePoint by clicking on Site Actions, and then New Page. Give it a name.
  4. Click on the blank area in the middle of the page and select the Group named Editing Tools. From the ribbon, select Web Part. On the categories pane, select List and Libraries. Now click on the name of the custom list you created in step 1, and click on the Add button.
  5. Repeat step 4 and select Chart Web Part under Business Data category.
  6. Now click on Data and Appearance on the Chart Web Part. In the wizard that opens, click on Connect Chart to Data.
  7. Select Connect to a List. Click on Next.
  8. Select the list you created earlier. Click on Next.
  9. Once again, click on Next.
  10. From the drop down for Y-field, select the appropriate name from your custom list.
  11. Click on Finish to create your chart.
  12. Now click on Data & Appearance.
  13. Click on Customize Your Chart to add graphical enhancements to your new chart.
  14. Tinker around with the options given in the section named Select Chart Type. Once you are satisfied, click on Finish and your chart will be ready.

Creating a chart with the Chart Web Part of Microsoft SharePoint 2010 can help you visualize data stored in SharePoint lists, external databases, or even Microsoft Excel spreadsheets, depending on the software being used to manage data in your organization. However, if you use third party add-ons, you might be able to incorporate additional visual elements to your charts. That way, you will have access to additional chart types, color schemes, and even the option to export the visualizations in different formats, or print them directly through the add-ons themselves.

Source by Sayed Nasir Uddin

Ingrown Toenail Removal Coding Confusions? 11750 Answers Them

In a particular case, a patient presents for a follow-up of an ingrown toe nail. The podiatrist finds that the patient now has two ingrown toenails – one on each foot. He removes both from each toe and also did a silver nitrate cauterization. How should I report this? Should I report 99212-25?

Well, the answer is yes. Besides coding 99212-25, you should bill 11750 (Excision of nail and nail matrix, partial or complete [example, ingrown or deformed nail], for permanent removal) appended by modifier 50 (Bilateral procedure).

Logic for evaluation & management: Since the diagnosis is new to one toe, you could justify 99212 (Office or other outpatient visit for the E/M of an established patient which requires at least two of these three key components: a problem focused history; a problem focused examination, and straightforward medical decision making; Significant, separately identifiable E/M service by the same physician on the same day of the procedure or other service). The patient presents for follow-up of one ingrown toenail. However, the podiatrist has not examined the other (new) ingrown toenail earlier.

Adding modifier 25 (Significant, separately identifiable E&M service by the same physician on the same day of the procedure or other service) to 99212 indicates the podiatrist carries out a significant, separate service from the ingrown toenail removal.

Logic for incision: You should report each toenail removal: 11750 for the first complete removal and 11750 for the second removal. Using modifier 50 to the second removal tells the insurer that the podiatrist carries out the toe removal as bilateral procedure.

For more specialty-specific articles to help your podiatry coding, stay tuned to a medical coding resource like Coding Institute.

Source by Erin Masercola

Best Medical Coding and Billing Online Courses

How can you find and know what are the best medical coding and billing online courses? Not all of them are offering you all types of accreditation. You should first see if they offer specialized or just general courses and you should choose the one that is providing the type of knowledge and specialization you aim for.

You should see how flexible are with deadlines and compare with your own time frame. Some schools have a tide schedule that you might not be able to meet. On the other hand, with a tide schedule you will finish it faster.

To choose the best medical coding and billing online courses you should always look for details. Some of them are nationally accredited; some of them are regional accredited. The number of programs is different in number and types of specializations they offer. Take a look or ask for a full program. Also you should ask for all costs involved. If there are applications fees or not, if any additional books will make you spend some extra money, if the final exam costs are included or if you can get any financial aid and what would be the terms.

Also you should look at what types of degrees they offer – Associate’s, Bachelor’s or Certificates. The best medical coding and billing online courses are offering also Master’s or even MBA, very useful if you want to turn this type of job in a business opportunity. Not all of them are offering all types of degrees. Or at least you should look for the course that is providing the degrees you need for depending on how committed or not you are for a career. Don’t forget to check if you can get the final degrees via internet or not.

When you are looking for the best medical coding and billing online courses don’t hesitate to search for reviews, ratings, opinions or even get in touch with people who attended one course or another. Sometimes, the official information you get on a website might not perfectly match with real life.

Source by Freddie Vincent

The Process of Medical Coding Certification

One does not need to have medical coding certification to work as a medical coder. Unlike other healthcare professions, which require intensive training and several years’ worth of book knowledge and practical experience, the tasks relegated to medical coders are relatively more mechanical and therefore easier to learn whether or not one has had any kind of medical training before.

Medical classification is the process of transforming descriptions of medical diagnoses and procedures taken from a variety of sources within the medical record into universal medical code numbers. These diagnosis codes are used to track different diseases and are a valuable source of information that may influence such sectors as government health agencies, private health insurance companies and worker’s compensation carriers.

Having medical coding certification gives the individual a competitive edge. Just having it listed down on one’s resume provides proof that the person has studied well and is qualified to work in her chosen career. Certified coders are more likely to be immediately hired and given higher compensation. They are also more likely to be recognized for higher positions after just a short term of experience within the healthcare institution.

To become a certified medical coder, one will have to pass a special certification exam. Depending on the program they have enrolled themselves in, individuals who are just starting to learn about medical classification can take the exam once they have passed their medical coding course. What awaits after is a flexible, stable and financially rewarding career in the flourishing healthcare industry.

Source by Jack M Patterson

Attend Otolaryngology Coding Conferences

Otolaryngology coding conference

If you are stumped while coding a tympanoplasty with mastoidectomy, you are not alone as with the list of similar-looking codes, anyone could get turned around. The important thing is memorizing which codes represent a wall up and wall down approach, and identifying an ossicular chain reconstruction (OCR).

1. Canal wall up with OCR preserves canal, removes Ossicles

The trademark of a canal wall up mastoidectomy is preserving intact the bony posterior external auditory canal. The CPT codes for a wall up approach with OCR are: 69636, 69637, 69642, 69644.

2. Canal wall up no OCR maintains canal and Ossicles

If the surgeon maintains the external auditory canal but does not mention the incus you are looking at a wall up approach without OCR, the codes for which are: 69635, 69641, and 69643.

3. Canal Wall Down means radical Mastoidectomy

The terms ‘radial’ or ‘complete’ tell you the surgeon used a canal wall down approach for the mastoidectomy.

For more Otolaryngology coding updates, sign up for Otolaryngology coding conferences. One such conference is taking place later this year at Orlando, FL which will certainly prove beneficial for all otolaryngology coders. When you sign up for one, you will get expert solutions to all your otolaryngology coding and reimbursement challenges under one roof.

Even if you find it difficult to attend one, you can train your team from the comforts of your home with the help of audio CDs and MP3s. So get the benefits of an otolaryngology coding conference and see the big difference in your practice’s revenue.

Source by Julia Rose

Gastroenterology Medical Coding – Upper GI Procedures

Gastroenterology is a medical specialty that deals with the digestive system and its disorders. Gastroenterologists use a number of diagnostic procedures to accurately identify the patient’s medical condition and prescribe treatment. Coding for gastroenterology involves accurate coding of the various procedures and services offered by the physician. Reimbursement is offered for procedures provided in in-office, in-facility, hospital outpatient and ASC facility settings. Payment policies vary with individual payers and therefore these should be verified before providing treatment to identify limitations if any, on diagnosis, site of service or coding requirements.

Common Gastroenterology Procedures

• ERCP (endoscopic retrograde cholangiopancreatography) – this procedure combines the use of X-rays and endoscope. It is used to identify disorders such as gallstones, tumors, cysts, blockages and narrowing in the ducts.

• Sphincterotomy – to treat abnormalities diagnosed during an ERCP

• EUS (endoscopic ultrasound) – ultrasound of the pancreas, transduodenal or transgastric

• Sigmoidoscopy – enables the physician to view the lower end of the colon.

• Gastroscopy – this helps to examine the lining of the oesophagus, stomach and duodenum using an endoscope.

• Colonoscopy – is utilized by physicians to have a direct view of the whole of the large bowel or colon.

Upper Gastrointestinal Procedures and Codes

Upper gastrointestinal procedures include endoscopic and esophagoscopic procedures. These help the physician to view the interior of the upper GI tract including the esophagus, stomach and duodenum. When billing for Upper GI procedures, you have to verify payer conditions for covering the procedure. The services are usually covered when medical conditions such as esophageal disease, anemia, gastric ulcer, Celiac disease, persistent upper abdominal symptoms, and involuntary weight loss have been diagnosed.

• 43200 Diagnostic esophagoscopy

• 43202 Esophagoscopy with biopsy

• 43215 Esophagoscopy with foreign body removal

• 43216 Esophagoscopy with electrocautery removal of tumor or polyp

• 43217 Esophagoscopy with snare removal of tumor or polyp

• 43220 Esophagoscopy with dilation

• 43227 Esophagoscopy with control of bleeding

• 43232 Esophagoscopy, rigid or flexible; with transendoscopic ultrasoundguided intramural or transmural fine needle aspiration/biopsy(s)

• 43234 EGD – simple primary examination

• 43235(dagger) EGD – diagnostic

• 43238 Upper gastrointestinal endoscopy with transendoscopic ultrasoundguided intramural or transmural fine needle aspiration/biopsy(s) esophagus (includes endoscopic ultrasound examination limited to the esophagus)

• 43239(dagger) EGD with biopsy

• 43241 EGD with transendoscopic catheter or tube placement

• 43242 Upper gastrointestinal endoscopy with transendoscopic ultrasoundguided intramural or transmural fine needle aspiration/biopsy(s)(includes endoscopic ultrasound examination of the esophagus, stomach, and either the duodenum and/or jejunum as appropriate)

• 43246 EGD with PEG tube placement

• 43247 EGD with foreign body removal

• 43250 EGD with electrocautery removal of tumor or polyp

• 43251 EGD with snare removal of tumor or polyp

• 43255 EGD with control of bleeding

Certain codes 43200, 43202, 43234, 43235 and 43239 require prior authorization with some payers, and this has to be verified beforehand.

Some Important Considerations

A comprehensive endoscopic evaluation of the upper GI tract has to be reported with the code 43235. This usually involves a detailed view of the esophagus, stomach and duodenum and a thorough examination of the duodenal bulb. Physicians should use code 43239 to report EGD (Esophagogastroduodenoscopy) with biopsy. An EGD that is provided just as a primary examination and does not include “comprehensive” components can be reported with the code 43234. Lesser services such as esophagoscopy and esophagoscopy with biopsy should be reported only using their specific codes, 43200 and 43202 respectively. Physicians should avoid the practice of adding modifier -52 to 43239 to signify these reduced services, because this usually results in pointless delays or even denials of payment. When reporting biopsies and procedures for removing foreign bodies, physicians should take care to choose the code that clearly specifies these.

In cases where more than one procedure is carried out during a single visit, physicians should ensure whether these come under the multiple endoscopy payment rules. Here, Medicare as well as most private payers will reimburse the full value of the highest-valued procedure, along with difference between the value of the remaining procedure and the base endoscopic procedure. Modifier -51 has to be used along with the lesser-valued procedure.

Source by Laura N Jones

Coding and Cutting Spare Transponder Keys

Transponder keys are an important aspect of a vehicle and have become very popular over the last few years because they prevent car theft. There are several electronic or computer coded chips utilized in the manufacture of transponder key blanks that are programmable for lost or for cutting spare keys.

You receive these coded keys when you purchase a car. Basically transponder keys are considered to be high security keys that will only work in your car’s ignition system using a radio transmission waves. The built-in transmission chip inside the transponder key allows the vehicle to star automatically.

Spare key is duplicated from another key but it still needs to be programmed in order for the car or SUV to recognize it. A key blank will not start a car even if it has not been programmed. Local Chicago locksmiths have the spare transponder keys or they know how to unlock your vehicle or start the engine with duplication. You don’t have to wait for the dealer to open up in order to get your keys.

Transponder key blanks are used to match and then laser cut with specific biting to match your car’s ignition switch. Locksmiths usually keep these blank keys in stock at all times so they can be cut. If you need a spare key there are other ways to get it. You can use a laser cut key that is made by creating a dimple like surface without actually using a blade.

The keys are safe because they have a programmed microchip inside that is coded as per the vehicle’s ignition code while serial number in the key chip is unique so it cannot be duplicated. When you enter the transponder key code it will validates the current chip code. If the numbers do not match, ignition will seize and your car will not start. Similarly, high security locks and safety vaults use similarly programmed keys to safeguard important documents and items. Just in case, you require spare keys or get the lock repaired, Chicago locksmiths are proficient in their multi faceted services.

Locksmiths use state of the art high quality expensive machinery in order to cut the keys correctly. Reputed and experienced Chicago locksmiths can take away the worry because if you just get it done anywhere one simple flaw and the key will not work. Most Chicago locksmith can create spare high security keys, laser keys, residential and security keys as well. They can also extract a key that has become stuck or broken off in the ignition.

If you leave your car keys inside your vehicle or get locked out, you need to have the number of a locksmith close by. A Chicago locksmith can do the following:

• Program the new transponder key
• Read the key number in the memory located in the immobilizer
• They can provide codes for a variety of different model cars
• Correctly identify the immobilizer system on a vehicle
• Cancel stolen transponder coded key so your vehicle cannot be broken into.

When you buy a car that is used, make sure that you check the original keys to make sure that it is the right one to your vehicle. Though you can always go to your car dealer, it is cheaper and faster to get your new key programmed by a licensed local locksmith.

Emergency service locksmith in Chicago should be licensed bonded and insured by the state laws so they can provide the right service wherever you are in Chicago, twenty-four hours a day, seven days a week.

Source by Jose M Hernandez Jr

The Basics of Medical Billing and Coding Schools

Education is the base of many careers and this is especially true in the medical industry where experience, practice and skills are required. Medical billing and coding schools are designed to offer students the education that is needed to build a successful career.

Steps Followed by Those Interested

If you are interested in pursuing a career in this path, there are a couple of things you need to consider before enrolling in any of these schools and these are as highlighted below.

• Start by selecting accredited medical billing and coding schools in order to get the necessary formal education. Keep in mind that not all institutions are created equally and as such, you need to weigh your options carefully before making a pick.

• Select the appropriate certification exam that is in line with what you want to pursue in order to increase the probability of landing the job you desire.

• Select highly reputed and relevant employers in this sector and ensure that they offer a superb salary and opportunity to enhance your career.

Is the Course Appropriate?

Before settling down to sign up with any medical billing and coding schools, you have to ask yourself some hard questions. For instance, are the programs you intend to pursue suited for your needs? This type of studying does not demand any fast prerequisites and as such, you simply need a DGED or high school degree in order to pursue an associate degree in this field. You should also be willing to learn fresh things everyday and handle different types of cases with a high level of expertise. There are several things you need to consider in order to ensure you are ready for this challenge and capable of getting into a school that meets your needs.


It is possible to find offline and online courses and these are availed to all students interested in pursuing a career in this field. A large number of the well known health organizations are known to demand specialized degrees from well known coding schools in order to employ new staff. Certification is obtained through a national exam which is conducted by some accredited national agencies. Re-certification is also required after 2 years for the purpose of ensuring that the certification is renewed to sit in well with the insurance and state medical laws which are known to change frequently. You should carry out thorough research and determine whether an offline or online school is the best choice for you.

Getting Admitted

In order to get into medical billing and coding schools, there are certain prerequisites that need to be followed. Depending on the institution selected, make sure that you confirm what these are and look at the coursework, accreditation and status before making a choice.

Source by Ali Raza

How to Use Color Coding Labels on Clothing Hang Tags

It all starts with the eyes. People are visual people and when you see something with your own eyes, that image tends to stick in your head. That is why color coding labels are so important. If you have a consignment clothing store or thrift store, be sure to use this idea for providing discounts to your customers.

How it works: Create a small sign towards the front of your store that says something like “Look for the colored dots and save money”. Place 4 different color dot labels on the sign and next to each color dot write the discount price.


Purple: $.25 cents off | Green: $.50 cents off | Blue: $.75 cents off | Red: $1.00 off

Then you would place the colored sticker on the hang tag. The labels would need to have permanent adhesive so that you don’t have to worry about customers removing and switching stickers. When the customer checks out you simply remove the hang tag from the garment. Customers love discounts of any kind. This will motivate customers to really search for deals. Kind of like “hunting for the best bargain”. It will get customers to really dig through all that you have to see what they can and can’t live without. You will be amazed at how people love this. It is like playing a game and everyone loves to search for deals no matter if it is.25 cents or $100.00 dollars. If you tell me that I can save anything then that becomes a deal to me.

People who go to consignment shops are searching for the best deals and a lot of times that means they are impulse buyers. The longer you keep customers in your store the better chances that they will end up purchasing more. Another idea is to separate men’s from women’s specials. For example you might have a pink color dot for women’s clothes and a blue one for men’s. If a customer finds a pink sticker then that means that item is on sale.

Lastly, you can place a color dot on the hang tags and provide a point scale. For example, purple is worth 1 point, blue is worth a half a point. When a customer makes a purchase they keep the hang tag with the color label and save them for discounts which they can use until the end of the month. So say for example someone purchases 20 items of clothing and 10 were purple labels and 10 were blue labels. That would be 15 points. Once a customer reaches 20 points they would get 10% off the next purchase.

Source by Ryan J Hollingsworth

Online Medical Coding And Billing Schools

Many people want to know how they can make money and work from home in a legitimate industry that will not only provide stimulating and interesting work, but will actually help them earn a decent income as well. The solution for many has been in the field of medical billing or coding. This growing profession is an ideal solution to anyone who prefers the freedom and flexibility of having your own at-home business and with the right training, you can start making money in a very sort time.

Becoming a medical coder or biller requires education, but there are many local Colleges and Universities who provide classes and even degrees or certificates. There are also many online schools that can help you get the education you need and become one of the many people who work from the comfort of their home every day.

Whether you are a parent who wants to be home with the kids or you are looking for a part-time job to supplement your regular employment. They can help you get the education you need to meet the goals you have for yourself. Many of these schools will also help you network and find work once you have completed your training.

Be sure to call several medical coding and billing schools and find one that fits with your schedule and your career goals and you will soon be on your way to becoming a medical billing or coding professional with the flexibility and income to do more than you thought possible.

Source by Bradley White