Visit cpajournal.com to read the very latest from The CPA Journal
July/August 2023 » A Better Way to Keep PivotTables...
Full articles of The CPA Journal are available to NYSSCPA members and CPAJ subscribers ONLY. Please login to access this content.
Nonmembers and nonsubscribers, you can apply for NYSSCPA Membership here and get unlimited access to The CPA Journal, or you can create a non-member online account here and purchase individual articles.
James A. Weisel, DBA, CPA, CMA
Consider the following hypothetical scenario: You have some PivotTables in a Microsoft Excel workbook that rely upon an underlying set of data. That dataset gets periodically updated by daily, weekly, or monthly downloads from another source. Do you find the process of adding the new data to your PivotTables cumbersome and time consuming? Are you copying and pasting data from .csv files into your PivotTable workbook? If so, there is a better way. A little work up front can reduce the likelihood of errors and save hours of time in the long run.
Advertising with the NYSSCPA is your opportunity to reach the greatest number of business advisors in the most important business state in the nation.
Post a resume or job listing in our Career Center to connect with hundreds of employers or job seekers.
Join 21,000+ of your peers. Apply for membership today!
Find CPE Conferences, Seminars, and Online Courses Here.
Get insight and analysis into all areas of the profession.
Content provided by and exclusively for NYSSCPA members.
Stay up to date with important NYSSCPA news.
A daily roundup of the latest from around the accounting and financial industry.
A strong PAC means a strong profession. Donate Today.
Help develop a strong network of connections.
A resource for NYSSCPA Members.
Members, Get expert answers to technical questions.
Start your career off right with an experienced mentor.
It's never too early to start thinking about your career.