Page 37

Billing_NovDec14

FIGURE 1 FIGURE 2 FIGURE 3 FIGURE 4 document the spreadsheet without cluttering your printed final product. If you want to print comments, go to the “Page layout” tab and click the small button at the bottom-right corner of the Page setup area, as shown in Figure 4. There is an area for comments on the “sheet” tab of the Page setup window. The default is “None,” but you can choose “at end of sheet” to print all comments at the end of a printed document or “as displayed on sheet” to print the comments as they appear on the worksheet. an example of comments printed at the end of a sheet is shown in Figure 5. Be sure to get in the habit of using comments, particularly in complex spreadsheets, spreadsheets you don’t use very often, or in spreadsheets you collaborate on. a few minutes spent documenting SOFTWARE FIGURE 5 with comments now can make your spreadsheets more accurate and save hours of confusion down the road. Nate Moore, CPA, MBA, FACMPE, writes custom SQL server code to mine practice management data for analysis in Excel, on webpages, and via email. Nate’s first book, Better Data, Better Decisions: Using Business Intelligence in the Medical Practice, written with Mona Reimers, was just published by MGMA. His free Excel Videos have been viewed over 900,000 times and are available at mooresolutionsinc.com. Like PivotTableGuy on Facebook or follow @PivotTableGuy on Twitter to be notified each time a new Excel Video is released. ADVERTISE IN Reach your target audience by advertising in Billing. We have multiple advertising options available. If you are interested in learning more, please contact: THe jOurNal OF THe HealTHCare BIllINg aND maNagemeNT assOCIaTION 37 David Merli, HBMA Sales Manager dmerli@hbma.org 202-367-1219


Billing_NovDec14
To see the actual publication please follow the link above