Journal of Accountancy Large Logo

Search Results

Tech Tips

Sort by: Show:
Page  1 | 2 | 3 | 4 | 5 >> 

1. Link preservation  

BY J. Carlton Collins, CPA
Q: I have created a “digital dashboard” in an Excel workbook that summarizes information from multiple Excel workbooks. As long as I maintain the linked files on my PC, the links work perfectly. However, when I email the dashboard workbook and related linked workbooks to others, these links stop working for some but not for others.

2. Inquiring minds  

BY J. Carlton Collins, CPA
Q: In your April 2013 JofA article titled “Microsoft Office 2013,” page 32, you mentioned that Excel 2013 offers the ability to “compare two spreadsheets to display changes (similar to Word’s Compare tool),” but I can’t find this functionality. Can you please tell me where to find this tool?A: To use Excel 2013’s new Compare tool, you must first activate the Inquire add-in from Excel’s File tab by selecting Options, Add-Ins.

3. Cell selections reach new heights  

BY J. Carlton Collins, CPA
Q: In Excel, is there a way to click on a cell containing a hyperlink without triggering the hyperlink? (Surely my current method of clicking next to the cell and then using arrow keys cannot be the best method.)A: Make the row height bigger or the column wider, then you can click in the white area of the cell to select it without triggering the hyperlink.

4. Loud & Square  

BY J. Carlton Collins, CPA
Q: I’m using a Square credit card reader that attaches to my smartphone, but I’m finding that the transactions don’t always go through properly. Is there a certain smartphone or cellular service provider that works better with these devices, or should I be using a different smartphone credit card reader?A: The solution may be as simple as turning up the volume on your smartphone.

5. Reader challenge: Privacy test  

BY J. Carlton Collins, CPA
In the aftermath of so many revelations about computer privacy this year, I thought it might be interesting to put your own privacy to the test. Earlier this year I found myself shopping for camping tents on Amazon.com, but I did not make a purchase. Shortly thereafter, I noticed that the camping tents I had studied for a longer time began showing up in banner ads in various websites, and even in ads along my Facebook wall.

6. Excel quick tip  

BY J. Carlton Collins, CPA
Holding down the Alt key and clicking on any cell triggers a Bing search based on the contents of that cell. The results are displayed automatically in a pop-up Research side panel. Give it a try. (Note: For this to function properly, you may need to first adjust the Research panel’s options by selecting the dropdown box at the top of the Research panel and selecting Bing).

7. Pop-up images in Excel  

BY J. Carlton Collins, CPA
Q: Our company sells more than 4,000 sporting good items, and to help analyze these items, we export a list from our accounting system into Excel. The list includes size, weight, reorder point, reorder quantity, cost markup percentage, pricing, and images. To make individual items easier to work with, my workbook has a dropdown list and several formulas that repeat the data for any given inventory item at the top of the worksheet (in row 1) based on the item I select in cell A1.

8. Sweet savings  

BY J. Carlton Collins, CPA
Q: When I purchase merchandise on the web, I often see an option to enter a discount code on the checkout page, but I never seem to have one. I’ve tried searching the web for discount codes that I might use, but I never seem to find codes related to my purchase.

9. Playing around  

BY J. Carlton Collins
Q: I am in the process of updating a Word 2003 document containing videos that were inserted as embedded objects. Previously, these videos appeared in a video window and when double-clicked played in place within Word 2003. However, in subsequent editions of Word, these embedded videos appear as a file icon and, when the icons are double-clicked, Word launches the Windows video player and plays those videos separately from my Word document.

10. No comment  

BY J. Carlton Collins, CPA
Q: My Excel workbook contains numerous comments explaining the source of selected values in my report, and I want to include these comments on the printed report. I have tried both of the Page Setup options that enable me to print the comments either “as displayed on sheet” or “at end of report” as footnotes.
Page  1 | 2 | 3 | 4 | 5 >> 
CPE Direct articles Web-exclusive content
AICPA Logo Copyright © 2013 American Institute of Certified Public Accountants. All rights reserved.
Reliable. Resourceful. Respected. (Tagline)