Articles
Published by J. Carlton Collins, CPA
View Biography for J. Carlton Collins,
CPA
Since 1985, Mr. Collins has published articles in numerous
publications on the areas of Accounting Systems, Microsoft Excel, Microsoft
Office, Security, Inventory Management, Supply Chain Solutions, Technology,
QuickBooks, Financial Reporting, the Internet, Computer Tips. Links to
selected articles are provided below:
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 - Microsoft Excel Pivot Tables, Microsoft Dynamics 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 Fineberg, 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
