Articles
Published by J. Carlton Collins, CPA
View Biography for J. Carlton Collins,
CPA
2016 - Technology Q&A Column - January, Journal of Accountancy
Microsoft Word: Making the Grade, January - (Check the reading grade level of the letters and reports I write in Word 2016)
Tax return preparation: Outsource your grunt work, January - (Automatically organize your client's tax documents)
Secure data transmission: Button your share, January - (Using ShareFile in a secure manner)
Microsoft Excel: Rowing logically, January - (Parse and crunch the data contained on differing numbers of rows.)
User-friendly internet: Carlton's pondering, January - (Avoiding web based articles that overuse the NEXT button.)
2015 - Technology Q&A Column - December, Journal of Accountancy
Microsoft Word: The ideal setting, December - (Setting Word's default fonts and formats.)
Microsoft Excel reader tip: Simple and elegant date conversions, December - (Converting two-digit-year, text-based numbers into four-digit-year, date-based numbers.)
Microsoft Excel: Give me a break, December - (Troubleshooting Excel's page break between groups.)
Microsoft Excel: The highly coveted ceramic chicken award, December - (Finding the most Excel-savvy CPA in the room.)
Printers: Goodbye, printer cartridges, December - (High-capacity refillable ink printers)
2015 - Technology Q&A Column - November, Journal of Accountancy
Electronic payments: Credit cards getting smarter, November - ( U.S. credit card industry adopts the EMV credit card standards)
Google Android: Easy does it, November - (Troubleshooting Android's caller blocking function.)
Microsoft Excel: Hidden mergers, November - (Find the merged cells in an Excel workbook.)
Pinterest: Pinning for profit, November - (Using Pinterest's new Business Page.)
2015 - Technology Q&A Column - October, Journal of Accountancy
Microsoft Excel: Put this chart on your radar, October
Microsoft Word: Character reference, October
Microsoft Outlook: The quick step, October
Hardware & software: Gadget central, October
2015 - Boost your computer�s performance - September, Journal of Accountancy
2015 - Technology Q&A Column - September, Journal of Accountancy
Online accounting systems: Accounting for cloud security, September
Social media: Be careful what you �like�, September
Search engines: Smooth operators, September
Presentation hardware: The old switcheroo, September
Microsoft Outlook: Two Outlook quick tips, September
2015 - Technology Q&A Column - August, Journal of Accountancy
Google Maps: No internet, no problems, August - (How to save a Google map area to your smartphone)
Computer hardware: Chip tip, August - (Discussion as to how many CPUs you need in your computer)
Google Alerts: Don't get alarmed, August - (How to unsubscribe to a Google Alert)
Internet Explorer: I'd like to open a tab, August - (Setting defaults tabs in Internet Explorer)
2015 - Technology Q&A Column - July, Journal of Accountancy
Microsoft Word: Word Jump, July - (Tip for jumping forward or backward a specific number of pages)
Computer Hardware: Chip Tip, July - (Discussion about how many CPUs your computer should have)
Internet Explorer: I'd Like to Open a Tab, July - (How to set Internet Explorer to open multiple tabs simultaneously)
YouTube: A Timely Video, July - (How to create a YouTube link that starts playing a specific point in the video)
Google Alerts: Don't Get Alarmed, July - (How to remove a Google alert)
Meeting Scheduler: Do Doodle, July - (Discussion about a cloud-based scheduling app called Doodle)
2015 - Cybersecurity Strom: Technology Roundtable, Part 2 (Yours truly is interviewed) - June, Journal of Accountancy
2015 - Technology Q&A Column - June, Journal of Accountancy
Scanning the Market, June - (Checklist of features to look for when evaluating scanners)
Resizing Your Home, June - (Managing picture images in Word)
PowerPoint Trumps Word, June - (Managing picture images in PowerPoint compared to Word)
Make it Fit, June - (Discussion of new smartphone and wearable fitness apps)
2015 - Beyond Spreadsheets: Technology Roundtable, Part 1 (Yours truly is interviewed) - April/May, Journal of Accountancy
2015 - Technology Q&A Column - April/May, Journal of Accountancy
Delve into This, April/May - (Microsoft's new file management tools)
Unforgettable Passwords, April/May - (Creating strong passwords)
My Favorite Quotes, April/May - (Querying stock prices in Excel)
Send Cash So I Will Know You Are OK, April/May - (Paypal's personal electronic payment solution called Venmo)
Carlton's Pondering, April/May - (Why are the number pads we use laid out in opposite directions?)
2015 - Take the Stage (cover story) - March, Journal of Accountancy
2015 - Technology Q&A Column - March, Journal of Accountancy
Weird Word Tip, March - (Select a rectangular area in Word, spatially rather than verbally)
Will the Next Windows be a 10?, March - (New features expected for Windows 10)
Hover Pictures, March - (How to insert mouse-over popup pictures in Excel)
Free Backup Gets Easier, March - (Windows 8's new File History tool)
A Defining Moment, March - (Word's new dictionary tool)
Don't Make it Count, March - (Discussion about avoiding the Count function in Excel PivotTables)
2015 - Technology Q&A Column - February, Journal of Accountancy
Excel: Windows vs MAC, February - (The feature differences between Excel for Windows and Excel for Mac)
Tech-no-phobes, February - (Dealing with people who are anti-technology)
Ex-if, February - (Tracking devices and the Stolen Camera Finder website)
Hotspot on Fire, February - (FreedomPop's free portable Wi-Fi hotspot)
Microsoft's Little Known Anti-Virus Tool, February - (Windows 8's free Windows Defender anti-virus tool)
5 iPhone Tips, February - (5 iPhone tips)
3 iPhone Camera Tips, February - (3 iPhone camera tips)
2015 - Technology Q&A Column - January, Journal of Accountancy
When Clipboard
Freezes,
January � (Managing
Windows copy-paste functionality)
Updating Links
in Excel,
January �
(Updating Excel workbook links automatically)
Forever Snippy,
January �
(The Windows Snipping tool)
Scrubbing
Facebook,
January � (Don�t let
Facebook content jeopardize potential job
opportunities)
Broken Formulas,
January �
(Excel trick for displaying multiple lines in
Excel)
2014 - Technology Q&A Column - December, Journal of Accountancy
Power Map, December - (Using Excel 2013's new Power Map tool)
Launching File Explorer, December - (Launching Explorer in Windows 8.1)
Mouse Trap, December - (Selecting the right mouse)
Out of Touch, December - (A discussion of touchscreen usefulness)
2014 - Technology Q&A Column - November, Journal of Accountancy
A Little Background, November - (Using Word's Built-in background removal tool)
A Convenient Risk, November - (Saving passwords in your browser)
Slicers verses SUMIFs, November - (Using Excel's Slicer tool)
Colorful Inline Replies, November - (Color coding your email replies automatically)
A Loopy Solution, November - (Creating loops in Excel macros)
2014 - 11 More Tips for Producing Stellar QuickBooks Reports - October, Journal of Accountancy
2014 - Technology Q&A Column - October, Journal of Accountancy
Divisive Security, October - (Checklist to secure mobile devices )
Model Behavior, October - (Pivoting multiple ranges of data in Excel 2013)
Trending Sizes, October - (Mobile devices are getting larger)
Say "Yes" to O/S "version" Upgrades, October - (Discussion about O/S Version versus Edition Upgrades)
Say "No" to O/S "edition" Upgrades, October - (Discussion about O/S Version versus Edition Upgrades)
2014 - 11 Tips to Optimize QuickBooks Reporting - September, Journal of Accountancy
2014 - Technology Q&A Column - September, Journal of Accountancy
Remotely Interested in Supervision, September - (Measures for monitoring work from home employees)
10 Excel Shortcuts, September - (10 quick Excel shortcuts)
What does it Meta?, September - (Using meta data to make your web pages rank higher)
Combination Charts, September - (Creating Combination charts in Excel)
2014 - Technology Q&A Column - August, Journal of Accountancy
Whiz Kids, August - (Defending technology, and spending time on the Internet with your kids)
How Well Do You Know PivotTables?, August - (A checklist for self-evaluating your knowledge of Excel PivotTables)
Searching for Privacy, August - (Prevent Google, Bing or Yahoo! from tracking your searches)
Excel Reader Challenge, August - (Calculating the top ten stock investments of 2013)
Substantiating Trust, August - (Can you trust third-party websites?)
Shortcuts for Evaluating a QuickBooks Bookkeeper, August - (Tips for evaluating one's QuickBooks knowledge)
2014 - Technology Q&A Column - July, Journal of Accountancy
You Gantt Do That, July - (Creating a Gantt chart in Excel with a little trickery)
Press ALT+P for Pizza, July - (Plea for more one-click ordering)
Tech-less-ness, July - (Dealing with old people and technology)
Office Sharing Arrangement, July - (Sharing office licenses with family members)
2014 - Technology Q&A Column - June, Journal of Accountancy
I'm Happy You Asked, June - (Technology to make your employees happy)
Five Techie TED Talks, June
What the Text!, June - (Using What's up text messaging)
Renewed Reasons to Change Names, June - (Finding the best, lowest cost registrar to host your domain name)
Sweeping Formats under the Rug, June - (Excel Error re: excessive formats)
2014 - Technology Q&A Column - May, Journal of Accountancy
Tag - Your It!, May - (Understanding the Metadata embedded in smartphone pictures)
The Hidden Scrolls, May - (Hiding and unhiding the scroll bars in Excel)
Several Windows 8 Questions, May - (Booting Win8 to Desktop View, Reorganizing the Win8 Start screen,
apply a background image to the Win8 Start screen, & Displaying apps from the Win8 Start button)
Seeing Things from a Different Perspective, May - (Keystone corrections for Epson projectors)
Going Paperless, Manually, May - (Saving electronic versions of your product manuals)
Future Tech, May - (Coin - a gadget that replaces your credit cards, Driverless cars, and Liquid Metal batteries)
2014 - Harnessing the Power of the Cloud - April, Journal of Accountancy (with J. Carlton Collins as a panelist)
2014 - Technology Q&A Column - April, Journal of Accountancy
Restore Time, April - (Restoring the clock in the system tray)
The Price is Right, April - (Using Excel's Ceiling.Math function)
LinkedIn Job Hunting Tips, April - (Tips for using LinkedIn to find a job)
Boot Proof your Email, April - (Measures to identify open emails after automatic reboots)
Kick Start your Computer, April - (Measures to make your Windows computer reboot faster)
2014 - Technology Q&A Column - March, Journal of Accountancy
In bed with YouTube, March - (Embedding YouTube video clips on your web page)
Anonymous Receipt, March - (How to receive emails anonymously)
A Better Letter, March - (Word 2013's templates)
A Bright Answer, March - (Checklist for selecting a data projector)
Bugged by Excel's Calculation Errors, March - (Exposing shortcomings in Excel's calculations)
2014 - Technology Q&A Column - February, Journal of Accountancy
The Queue Continuum, February - (Managing your Print Queue)
Navigate Excel Worksheets Faster, February - (Tips for moving around Excel Worksheets)
Backup Fee-Free, February - (Tips for backing up your data without a monthly fee)
Lights, Camera, Format!, February - (Using Excel's Camera tool)
Thread base, February - (Forwarding emails as Attachments in Outlook)
2014 - Technology Q&A Column - January, Journal of Accountancy
Photo bombing your own email, January - (Controlling the profile picture in your recipient's email)
Your message will self-destruct, January - (Using Snapchat to send disappearing messages and images)
Run Excel Safely, January - (Launching Excel without the add-ins)
Merging Outlook, Gmail and Android, January - (Setup instructions for reading email from your Android phone)
2013 - Technology Q&A Column - December, Journal of Accountancy
Link Preservation, December - (Persevering external Excel links when emailing multiple Excel files)
Inquiring Minds, December - (Using Excel 2013's new Inquire tools)
Sidebars, December - (Controlling teasers and sidebars in Word)
Loud and Square, December - (Advice about smartphone based credit card devices)
Cell Selections Reach New Heights, December - (Clicking a cell in Excel without triggering the hyperlink)
Excel Quick Tip, December - (Using Excel's Research sidebar)
Reader Challenge - Privacy Test, December (Test your email privacy with me)
2013 - Technology Q&A Column - November, Journal of Accountancy
What's Next? - (Discussion of RFIDS, transparent glass and 3-D printing)
The Lowdown on Utility Downloads, November - (Website suggestion for downloading utilities)
Pop-up Images in Excel, November - (An Excel formula that will pop up specific images based on data entered in other cells)
Sweet Savings, November - (The Honey website for discount coupons)
2013 - J. Carlton Collins wins Lawler Award - October, Journal of Accountancy
2013 - Technology Q&A Column - October, Journal of Accountancy
No Comment, October - (Adding a row and column grid to your Excel print outs to reference comment footnotes)
Playing Around, October - (Playing videos from Word 2013)
Norton's New Management Web Site, October - (A new website for managing your Norton antivirus licenses)
Pain in the Spam, October - (Email settings to reduce spam)
CPAs Think Big, October - (Recommendations regarding larger touchscreen ultrabooks)
Office 2013 is so Touchy, October - (Touch controls for Office 2013)
Excel Reader Challenge, October - (Summary of responses)
2013 - Technology Q&A Column - September, Journal of Accountancy
Let It Slide, September- (Displaying Photo Slideshows in Windows 8)
Your Work is Clear, September- (Resetting the Recently Opened documents list in Excel and Word)
Not So Obvious Update Procedure, September- (Updating the Apple iOS)
Test Your IQ: Solution, September - (Solution to last month's Excel-based Reader Challenge)
2013 - Technology Q&A Column - August, Journal of Accountancy
Everything, August - (A utility for searching file names across folders)
Sample This!, August - (Using Excel's RAND and RANDBETWEEN)
Small Business Growing Pains, August - (Accounting system advice)
Make It Rain, August - (Discussion about high-end computer systems)
Reader Challenge: Test Your Excel IQ, August - (Excel test for fetching the last row of data)
! Reader Challenge: Results, August - (The challenge results are reported)
! Reader Challenge: Excel File, August - (Excel File that includes a summary and the first 67 solutions)
2013 - Technology Q&A Column - July, Journal of Accountancy
A Good Measure, July - (Speed test your internet connection)
A Bit Confusing, July - (Installing the 64-Bit version of Office compared to the 32-Bit version)
Three Word-Based Hyperlink Questions, July - (Working with hyperlinks in Microsoft Word)
A Large Problem, July - (Using the LARGE function in Microsoft Excel)
Five iPad Tips, July - (Five iPad Tips)
2013 - Technology Q&A Column - June, Journal of Accountancy
Going Paperless Checklist, June - (Checklist of going paperless)
Five iPad Questions, May - (Five iPad questions)
OverScan, June - (Connecting a computer to a television monitor)
Excel at Hyphen Removal , June - (Removing hyphens and dashes in Excel)
Trigger Happy, June - (Scheduling applications to run at a prescribed time)
Five iPhone Tips, June - (iPhone tips)
2013 - Technology Q&A Column - May, Journal of Accountancy
Five iPad Questions, May - (Five iPad questions)
Use Excel this Instance!, May - (How the new Excel 2013 opens separate workbooks in separate instances)
Good Vibrations, May - (Discussion of the PowerPod 360 vibrating speaker)
Restore the Windows 8 Start button, May - (The free Classic Shell Start button in Windows 8)
Time to Stock Up, May - (Tips for researching free stock information on the Web)
2013 - Microsoft Office 2013 - April, Journal of Accountancy - (Feature article outlining the new features in Microsoft Office 2013)
2013 - Technology Q&A Column - April, Journal of Accountancy
A Complicated Inheritance, April - (Evaluating and auditing formulas in Excel)
Horsing Around with Paint, April - (How to remove background clutter from a picture)
Rule Your Spam, April - (Creating Outlook rules to reduce spam)
Can I Drop(box) QuickBooks?, April - (Discussion about hosting QuickBooks data on DropBox)
Five DropBox Tips, April - (Five DropBox Tips)
2013 - Technology Q&A Column - March, Journal of Accountancy
Reverse the Negativity, March - (Convert trailing minus signs to leading minus signs in Excel)
Missing Toolbars, March - (Display toolbars with InPrivate Browsing)
Make Your Point, March - (Formatting bulleted numbers in Word)
Snake!, March - (Make columns snake and print on one page in Excel)
A Bit Disappointed, March - (Caution regarding the O/S installation on new computers)
2013 - Technology Q&A Column - February, Journal of Accountancy
Do I Know You?, February - (Dealing with LinkedIn's IDKs)
Removing Hyperlinks in Excel, February - (Excel's new Remove Hyperlinks tool )
AutoTrusting E-Mailed Images, February - (Make email images appear automatically)
Creating Hyperlinks in Excel, February - (Using Excel's HYPERLINK function)
Searching for Acrobats, February - (Searching the web for PDF file formats)
No Coffee for My Mouse Please, February - (Mouse equivalent controls using the keyboard)
Dust in the Wind, February - (Reminder to clean the inside of your computer)
2013 - Technology Q&A Column - January, Journal of Accountancy
Sparklines Make Headlines, January - (Excel 2010's new Sparklines feature)
Green Computing Tips, January - (Going green with your technology)
Touchy Underlines, January - (Editing underline formats in Excel)
Wireless Breadcrumbs, January - (Wireless settings to track user's internet activity)
2012 - Technology Q&A Column - December, Journal of Accountancy
Sum Highlights for You, December - (Creating Sum formulas in Excel by highlighting data)
Small Keys Create Big Problems, December - (Beware the half-height keys on a laptop keyboard)
Run a Tab for this Table, December - (Controlling indents in a Word table)
I've Got You Pegged, December - (Using Google Latitude to track a person's smartphone)
Table Rows are a Drag, December - (Rearranging rows in a Word table by dragging)
The Games People Play, December - (Comments about playing social media games)
Five Tips Using Excel's Fill Handle, December - (Five tips using Excel's Fill handle)
2012 - Windows 8 - Jump or Wait? - November, Journal of Accountancy (Feature Article About Windows 8, Microsoft's New Operating System)
2012 - Technology Q&A Column - November, Journal of Accountancy
QuickBooks Job Costing, November - (8 Preference Settings to Get the most out of QuickBooks Job Costing)
Custom Calendar, November - (Custom Calendars in Word Document)
Lost Excel File, November - (Recover an Excel File You Forgot to Save)
The Incredible Shrinking Font, November- (Controlling Font Sizes in Excel)
Five Twitter Tips, November
Twitterfy Me, November - (Twitter for Business )
The Case Has Been Solved, November - (Controlling Text Case in Word)
2012 - Technology Q&A Column - October, Journal of Accountancy
Facebook Tips - October, Journal of Accountancy (Five Facebook Tips)
Complete Advice - October, Journal of Accountancy (Complete versus Typical Installations of Office 2003)
Seeing Green - October, Journal of Accountancy (Controlling the Green Error Tick Marks in Excel)
Excel PivotTable Questions - October, Journal of Accountancy (Four Questions About Excel PivotTables Answered)
Take a Swipe At This - October, Journal of Accountancy (Using Swype on Your Smartphone)
2012 - Technology Q&A Column - September, Journal of Accountancy
Area View - September, Journal of Accountancy (Using transparency in Excel Area Charts)
Exactly - September, Journal of Accountancy (Using Excel's =Exact Function)
Website Update - September, Journal of Accountancy (Using Adobe Acrobat to capture website content)
Cookies in Red Capes - September, Journal of Accountancy (How to delete Persistent Cookies and Super Cookies)
Confessions of a Data Hoarder - September, Journal of Accountancy (Strategy for Deleting Old Email)
Wi-Fi Dead Spots - September, Journal of Accountancy (Strategies for Preventing Wi-Fi Dead Spots)
2012 - Technology Q&A Column - August, Journal of Accountancy
Grid Lock, August - (Unlocking 1,048,576 rows in Excel)
Key Threat, August - (Understanding Keyloggers)
In Private Browsing, August - (Browsing the Web in Secure Mode)
Hide and Link, August - (Managing Links in Excel)
Windows Logo Key Shortcuts, August
2012 - Technology Q&A Column - July, Journal of Accountancy
Reader Tip - July, Journal of Accountancy (Using an iPad as a second monitor)
Footers Take a Step Backward - July, Journal of Accountancy (Including file names in Word footers)
A Taxing Question - July, Journal of Accountancy (Integrated Sales Tax Solutions)
A PivotTable Column Worth Repeating - July, Journal of Accountancy (Percent to Total Columns in Excel PivotTables)
A Relatively Easy Macro - July, Journal of Accountancy (Relative versus absolute macros)
2012 - Technology and CPAs: Vision of the Future - June, Journal of Accountancy (Collins is interviewed by the JofA)
2012 - 125 Technology Quick Tips - June, Journal of Accountancy (125 Assorted Tech tips)
2012 - Technology Q&A Column - May, Journal of Accountancy
GoToMyPC Tips - May, Journal of Accountancy (Remote Access Tips)
A Click in Time Saves Nine - May, Journal of Accountancy (Excel - Recent Files Tip)
Give me A Break - May, Journal of Accountancy (Word - Line Breaks Tip)
Follow the Conversation - May, Journal of Accountancy (Outlook - Thread Tip)
Check it or Leave It - May, Journal of Accountancy (Outlook - Reading Email Remotely Tip)
2012 - Technology Q&A Column - Apr, Journal of Accountancy
I Read You Loud and Clear - April, Journal of Accountancy
(Browser - Improve Readability Tips)
Elbows on the Table, Please - April, Journal of Accountancy (Excel - Elbow Formatting Tip)
Is it Time to Ditch your Thumb Drive? - April, Journal of Accountancy (Hardware - USB drive Tips)
Transposition Errors in Excel - April, Journal of Accountancy (Excel - Tips for Pasting Formulas)
Secure your Laptop - April, Journal of Accountancy (Windows - Encrypting Your Files Tips)
2012 - Technology Q&A Column - Mar, Journal of Accountancy
Tagging Along - March, Journal of Accountancy
(Microsoft Tags and Q R Codes)
Ready, Set, Excel! - March, Journal of Accountancy (Excel - Suggested Default Settings )
Monitoring the Field - March, Journal of Accountancy (Hardware - Portable Monitors)
Watering Your Documents - March, Journal of Accountancy (Word - Watermark Tips)
2012 - Technology Q&A Column - Feb, Journal of Accountancy
The Paperless Business Card - February, Journal of Accountancy (Outlook - E-Business Cards)
Help for People with Dating Problems - February, Journal of Accountancy (Excel - Apple/Windows Date Conflicts)
Ready, Set, Action! - February, Journal of Accountancy (Extranormal - Produce Animated Videos)
Keep Those Names Flowing - February, Journal of Accountancy (Word - Multi-Columns Tip)
PivotTable Growing Pains - February, Journal of Accountancy (Excel - Dynamics Source Range Tip)
2012 - Technology Q&A Column - Jan, Journal of Accountancy
An Aggregate Answer to Two Excel Questions - January, Journal of Accountancy
(Excel - New Aggregate Function)
A Solution for Dummies - January, Journal of Accountancy (Word - Creating Dummy Paragraphs Tip)
What 11-Letter Word Do All CPAs Spell Incorrectly? - January, Journal of Accountancy (Word - Dictionary Tip)
A Bolder Folder - January, Journal of Accountancy (Windows - Folder Settings Tips)
The Thomas Database - January, Journal of Accountancy (Every Word Uttered in Congress Published Online)
The Right Sort - January, Journal of Accountancy
(Excel - Sorting Left to Right Tip)
A Super Footnote Reference - January, Journal of Accountancy (Excel - Recent Files Tip)
2011 - A Guide to QuickBooks - December, Journal of Accountancy (Excel - Superscript Font Tip)
2011 - Technology Q&A Column - Dec, Journal of Accountancy
From Here to Eternity, December, Journal of Accountancy (Excel - Scrolling/Navigating Tips)
Solid Performance, December, Journal of Accountancy (Hardware - SSD Drive Tips)
A Prezi for You, December, Journal of Accountancy (Fresh Alternative to PowerPoint)
Personal Mobile Hotspot, December, Journal of Accountancy
(Hardware - Portable Internet Access)
ProSystem fx Tips, December, Journal of Accountancy (ProSystems fx - Five Tips)
2011 - Technology 2012 Preview: Part 1, November, Journal of Accountancy
(Moderated and Edited by J. Carlton Collins)
2011 - Technology Q&A Column - Nov, Journal of Accountancy
Can You Keep a Secret (Folder)? - November, Journal of Accountancy (Windows - Hidden Folder Tip)
Linking Can Be a Drag - November, Journal of Accountancy (Excel - Creating Links Tip)
Semi-block Your Facebook Wall - November, Journal of Accountancy
(Facebook - Privacy Tip)
Welcome to the Chop Shop - November, Journal of Accountancy (Video - Cropping Video Clips Tip)
Smart Question - November, Journal of Accountancy (Recommended Smartphone Apps)
2011 - Technology Q&A Column - Oct, Journal of Accountancy
Make a Difference With PivotTables - October, Journal of Accountancy (Excel - PivotTable Formulas Tip)
X Marks the Spot - October, Journal of Accountancy (Browser - Sharing Favorites Tip)
Control Your Accent - October, Journal of Accountancy (Excel - Auditing Formulas Tip)
A Sky-High Solution - October, Journal of Accountancy
(Cloud - Microsoft's SkyDrive)
Five Inexpensive Technologies - October, Journal of Accountancy (Five Inexpensive Gadgets)
2011 - Technology Q&A Column - Sep, Journal of Accountancy
A Puzzling Parse - September, Journal of Accountancy (Excel - Parsing Text Tip)
I've Been Framed - September, Journal of Accountancy (Web - Creating Hyperlinks Tip)
Clipboard on Steroids - September, Journal of Accountancy (office - Clipboard Settings Tip)
Prepare to Get Wet - September, Journal of Accountancy (Hardware - Migrating to a New Computer Tip)
2011 - Technology Q&A Column - Aug, Journal of Accountancy
Hiding Between the Pages - August, Journal of Accountancy (Word - Suppress White Space Tip)
Your Type is Not Allowed - August, Journal of Accountancy (Word - Editing in Reading Mode Tip)
Drive-By Virus - August, Journal of Accountancy (Security - Combating Viruses Tips)
Desperately Geeking Susan - August, Journal of Accountancy (Hardware Recommendations)
The Aftermath of Many Conditions - August, Journal of Accountancy (Excel - The SUMIFS Function)
Internet Explorer Shortcuts - August, Journal of Accountancy (Ten Browser Shortcuts)
2011 - Technology Q&A Column - Jul, Journal of Accountancy
Your Finest Port, - July, Journal of Accountancy (Outlook - Anti Spam Setting)
Outlook 2010 and 2007 Shortcuts, - July, Journal of Accountancy (Five Outlook Shortcuts)
Mastering Your CDs, - July, Journal of Accountancy (Windows - Burning CDs Tip)
A Colorful Preview, - July, Journal of Accountancy (office - Print Preview in Color Tip)
One Tall Solution, - July, Journal of Accountancy (Excel - Print Setting Tip)
2011 - Technology Q&A Column - Jun, Journal of Accountancy
Foot Your Financials in Excel, - June, Journal of Accountancy (Excel - Embedded Word Object Tip)
An Iconic Solution, - June, Journal of Accountancy (Windows - Organizing Your Icons Tip)
A Smart Solution to Formatting Bullet Lists, - June, Journal of Accountancy (Word - Smart Art Tip)
Add Value, Instantly, - June, Journal of Accountancy (Excel - Pasting Between Workbooks Tip)
Windows Shortcuts, - June, Journal of Accountancy (Five Windows Tips)
2011 - CPA's Guide to Improving Travel and Expense Management, ASA Research Press
2011 - Technology Q&A Column - May, Journal of Accountancy
Dating Tips, - May, Journal of Accountancy (Excel - Date Format Tip)
Count on It, - May, Journal of Accountancy (Windows Calculator Tips)
Hide me Quick, - May, Journal of Accountancy (Excel - Hiding/Displaying Columns Tips)
Caps Off To You, - May, Journal of Accountancy (Windows - Keyboard Tip)
An Excellent Arrangement, - May, Journal of Accountancy (Excel - Displaying Excel on Multiple Monitors Tip)
Pasting Away Again, - May, Journal of Accountancy (Excel - Pasting Tip)
2011 - Excel's New Slicer�It Slices, It Dices, - April, Corporate Taxation Insider (Excel's New Slicer Tool )
2011 - Technology Q&A Column - Apr, Journal of Accountancy
Picture a Smaller File Size, - April, Journal of Accountancy (Office - Compressing Picture Sizes)
XPS vs. PDF, - April, Journal of Accountancy (Windows - Microsoft's Alternative to the PDF Format)
Displaying a Two-Digit Year, - April, Journal of Accountancy (Excel - Date Format Tip)
A Refreshing Change in Your Portfolio, - April, Journal of Accountancy (Excel - Web Queries Tip)
Creating a New Worksheet Can Be a Drag, - April, Journal of Accountancy (Excel - Duplicating Worksheets Tip)
E-mail a Single Worksheet, - April, Journal of Accountancy (Excel - Email Tip)
Excel's New Slicer�It Slices, It Dices, - April, Journal of Accountancy (Excel's New Slicer Tool)
2011 - Technology Q&A Column - Mar, Journal of Accountancy
Your Cheating Chart, - March, Journal of Accountancy (Excel - How Charts Lie Tips)
The Blind Side of E-Mail, - March, Journal of Accountancy (Outlook - Blind Copying Tip)
A Search for a Better Search, - March, Journal of Accountancy (Windows - Folder Search Tip)
Five Excel Quick Tips, - March, Journal of Accountancy (Five Excel Tips)
I Don't Want to Lose You, - March, Journal of Accountancy (Tips for Backing Up Your Cell Phone Data)
I Stand Corrected, - March, Journal of Accountancy (Word - AutoCorrect Tip)
2011 - Increase Productivity With Multiple Monitors, Journal of Accountancy
2011 - Technology Q&A Column - Feb, Journal of Accountancy
Heaven Help Us, - February, Journal of Accountancy (Windows - GodMode Tip)
That's a Shifty Move, - February, Journal of Accountancy (Browser - Faster Browsing Tip)
Full Screen Ahead, - February, Journal of Accountancy (Browser - Readability Tip)
Say Goodbye to Wimpy Searches, - February, Journal of Accountancy (Windows - Search Tips)
Hidden Tips for Hiding Data, - February, Journal of Accountancy (Excel - Privacy Issues)
2011 - Technology Q&A Column - Jan, Journal of Accountancy
Would You Like to Share a Date? , - January, Journal of Accountancy (Outlook - Sharing Calendars Tip)
It's Time to Split, - January, Journal of Accountancy
(Excel - Split Screen Tools Tip)
I Command You, - January, Journal of Accountancy (Excel - Unlock 219 Hidden Commands Tip)
I Hope to See You Zoom, - January, Journal of Accountancy (Excel - Zooming Tip)
2010 - Fortify Your Facebook Privacy, Journal of Accountancy
2009 � The Tech-Savvy CPA, Journal of Accountancy
2008 � Evaluating & Selecting Not-For-Profit Accounting Systems, Serenic Software Press
2008 � Practical Advice For Companies Who Have Outgrown QuickBooks Executive Summary, Microsoft Press
2007 � Compliance Conundrum, Accounting Today
2007 � How to Choose the Right Accounting System Reseller, Microsoft Press
2007 � A Small World: Multicurrency and Multilanguage Software, Accounting Technology
2006 - Small Business Software Grows Up, Journal of Accountancy
2006 - Has Your Business Outgrown Peachtree?, Microsoft Press
2006 - Microsoft Excel Pivot Tables, Microsoft Dynamics Press
2005 - Financial Management Software Evaluation Guide, Microsoft Press
2005 � 25-Step Blueprint for Selecting the Right Accounting Software, Financial Mgmt Software Evaluation Guide
2005 � Serenic Navigator Ranked First In Industry White Paper, PR Newswire
2004 � Complying with Sarbanes � Oxley, How Microsoft Navision Can Help, Business Systems Solutions
2004 � Microsoft Business Solutions for CPAs, Slide Share
2004 � 15 Key Provisions of Sarbanes-Oxley, White Star USA
2004 � Business Accounting Software Evaluation, Microsoft Dynamics Press
2004 � Practical Advice for Companies That Have Outgrown QuickBooks, Microsoft Press
2004 � Review of Axapta, Technology Evaluation Centers
2004 � QuickBooks Analysis, Innovative Tekniques, Inc.
2003 � Excellence Series "Unsung Hero", Time Savers, Inc.
2003 � The Ideal Reseller, The Practical Accountant
2003 � Computer Security Checklist, Tourbillon Partners Press
2002 � A Review of Microsoft Navision, Anderson Essentials
1999 - How to Select the Right Accounting Software, Journal of Accountancy
1999 � Confessions of an Excel Junkie, Excel Advisor
1991 - How to Make a Success of Software Consulting, Journal of Accountancy
Quoted in Articles - J. Carlton Collins
2011 - Charles Chewning, Software Selection Articles, The Accounting Software Library
2010 - Amazon.com, Practical technology tips for CPAs, Leader's Edge
2009 � Geni Whitehouse, Even a Nerd Can Be Heard, Upton and Blanding Associates
2009 - Amazon.com, The tech-savvy CPA: it's a tech-focused world. Are you in it?
2009 - Anya Ciecierski, How Does QuickBooks Compare to Microsoft Dynamics GP, Microsoft Partner Blog
2008 � Anya Martin, SEAS Sets New Pace As CPAs Line Up For Credits, Atlanta Business Chronicle
2008 � Practical Advice for Companies That Have Outgrown QuickBooks, Workshift Systems
2008 � Supporting Not-for-Profits, Accounting Today
2008 - Ulric J. Gelinas Jr., Business Processes and Information Technology, Global Text Terry College of Business, UGA
2008 � Jeff Stimpson, Not-For-Profit Software Links, The Practical Accountant
2007 � Alexandra DeFelice, A Small World, WebCPA
2007 - Fara Elikai, Accounting Software Selection and User Satisfaction, The CPA Journal
2007 - Street Talk: Reader Views (Letter to the Editor), Accounting Today
2006 � Carolyn Tang, The Connected CPA, Insight Magazine
2006 - Kreag Danvers - Increasing the Relevance of Undergraduate Accounting Education, Strategic Finance
2006 � Bob Jensen, Tidbits, Trinity University
2006 � Small Business Grows Up, National Science and Technology Library (Published in Chinese)
2006 � Lisa Spinelli, Laps v. desks: So where should you put your computer?, The Practical Accountant
2005 � Joanna Glasner, Users Blast Intuit's Upgrade Fees, Wired Magazine
2005 � Tech Briefs (American European Consulting Company Inc.), Accounting Today
2005 � James Bryce Smith, ERP Selection Tips, Navision Press
2005 - Serenic Navigator Ranked First In Industry White Paper, Serenic Software
2005 � White Paper - Investing in the Future, The Resource Group
2005 � Gale, Cengage Learning, Society year peaks with 2005 Members Summit and Annual Meeting, Catalyst
2005 � ERP Overview Brochure, Sage Software Press
2005 � Lisa Spinelli, Online Accounting, The Wave Of The Future Is Still Out At Sea, Accounting Today
2005 � Street Talk: Reader Views, AICPA, Accounting Technology
2005 � Financial Insights � PFW Marketing Slick, Sage Software Press
2005 � How Great Plains Beats MAS 90/200, Microsoft Press
2005 � My Reaction to Sage�s Rebuttal
2005 � Microsoft to Deliver New Professional Accountants' Network, PR Newswire
2005 � Linda C. Chandler, Putting Your Money Matters Online, Association Management
2005 � Lisa Spinelli, CPAs See Mixed Returns On Their Technology Investment, Accounting Today
2004 � J. Tol Broome, Jr., Accounting For Everything, Pest Control
2003 - High-Tech Writers, BusinessVision Leaps Ahead, Business Wire
2003 � Seth Fienberg, The Key To Reselling Success Remains A Matter Of Opinion, Accounting Today
2003 - High-Tech Writers, BusinessVision Gives Alternative to Software Ownership, Business Wire
2003 � AccountMate Partners Gain Vertical Advantage, The Practical Accountant
2003 � Special Report: Partnership Programs, Accounting Today
2003 - High-Tech Writers, Softline BusinessVision Announces Vertical Solution Partner Program, Business Wire
2003 � John Covaleski, Clifton Gunderson Sets Up Stand-Alone Technology Unit, Accounting Today
2003 - Softline BusinessVision Announces Vertical Solution Partner Program, Canadian Corporate News
2003 � Business Editors, BusinessVision 32 Scores Sales Coup, Business Wire
2002 � The Accounting Software Library, Accounting Library Web Site
2002 � AccountMate Testimonials, AccountMate Press
2002- �I Want The Freedom To Focus On My Business, Navision Press
2002 � Robert Scott, Making Payments Online, Accounting Technology
2002 � Pivot Table and Pivot Chart Links, Peltier Technical Services
2002 � James Coates, Chicago Tribune Ask Jim Column, Chicago Tribune
2002 � Jeff Stimpson, Mid-Level Accounting Software Takes Off, The Practical Accountant
2002 � John Covaleski, Collins Foresees "Consumer Reports" Status In Accounting Software, Accounting Today
2002 � Collins Launches CPE, Accounting Technology
2002 � John Covaleski, 2002 Tech Conference Planners Anticipating Heavy Turnout, Accounting Today
2002 � J. Tol Broome, Jr., There's An Accounting Package To Suit Your Business, Gifts & Decorative Accessories
2001 � Business Editors, Softline Reports Fast Track Expansion Into U.S. Accounting Mid-Market, Business Wire
2001 � Jeff Stimpson, Explosion Of E-Accounting, The Practical Accountant
2001 � Softline Reports Fast Track Expansion , Canadian Corporate News
2001 � NavisionDamgaard US Prepares for `Dawn of Dominance' at Annual Compass Meeting, Business Wire
2001 - Clar Rosso, Worth the Risk? You Decide., California CPA
2000 � Gale Group, Sage Software Announces Launch of Web News Site for Accountants, Business Wire
2000 � ACCPAC Assists Accountants in Transition to Trusted Advisors, Canadian Corporate News
2000 � Sharon Krugman, Experts Say IT Consulting Is Full-Time Job, Accounting Today
2000 � Business Editors, Sage Software Announces Launch of Web News Site for Accountants, Business Wire
2000 � Epicor Ranked Top Manufacturing Solution for Large Midmarket Companies, PR Newswire
2000 � Business Editors, Navision Software Wins Best Mid-Market Accounting Honor, Business Wire
1999 � Anonymous, Committee Reports, Pennsylvania CPA Journal
1999 � John Covaleski, Peachtree Looks Upmarket, Readies $140 million IPO, Accounting Today
1999 � Melissa Klein, CPA Tech Incomes Double, Accounting Today
1997 - Peachtree Software Continues Outreach to Accounting Professionals, PR Newswire
1997 - Gary F. Peters - ERP And Accounting Information Systems - Terry College of Business at the University of Georgia
1995 � Robert Scott, Practitioners Advise: Look Before You Leap To Windows 95, Accounting Today
Web Site Links to J. Carlton Collins
Business System Solutions - A Review of Navision
Synesis Dynamics - 25-Step Blueprint for Selecting the Right Accounting Software
Sage BusinessVision - BusinessVision � la Carte is an excellent...
Awards and Honors for J. Carlton Collins
2011 - Top Twenty-Five CPA Thought Leaders in the United States
2008 - Thomas A. Radcliffe Outstanding Discussion Leader Award, ASCPA
2007 - Top Ten Most Influential People in Accounting Software Industry, SAP Internal Study (results not published)
2005 - Top 100 Most Influential Practitioners 2005, The National Public Accountant
2005 � Dan Hood, Spreading it Around - Top 100 People, Accounting Today
1998 - Innovative User Of Technology Named, The CPA letter
1998 - Solution Provider Wins Award, Journal of Accountancy
1990 - Computer Associates Most Valuable Partner Award, Computer Associates (Now Sage Software)
Conference & Event Brochures on the Web Featuring J. Carlton Collins
2009 � 2009 Management Conference, Fargo, ND
2008 � GSCPA Technology Conference, Atlanta, Georgia
2006 � DeKalb County, GA Chamber of Commerce: Microsoft Education Workshop, Stone Mountain, Georgia
2004 � Top Ten Accounting Software Solutions, Business Software Shootout, The Ashford Club, Atlanta, GA
2009 - Excel for CPAs, South Carolina Association of CPAs, Greenville, SC