High Impact Excel: Answers to Three Pivot Table Questions

On January 30, I led a free, one-hour webinar, High Impact Excel: Pivot Table Edition. If you missed the presentation, it’s too late to get CPE credit, but you can watch an on-demand recording. After the webinar, I held a one-hour Q&A session during which attendees asked me questions about the presentation and Excel. In this article, I’ll share three of the best questions asked by the audience.

1. Lyle, president of an accounting firm, asked: “Rather than using a text file as my raw data, could I connect to a SQL database table or tables instead?”

During the presentation, I showed how to convert a rather ugly text file into an analysis-ready format. The answer to Lyle’s question was a resounding "yes," as shown in Figure 1.

 

Figure 1: Excel pivot tables can be based on connections to an SQL server and other data sources.


Already a member? log in here.

Editor's Choice

Upcoming CPE Webinars

Dec 3The materials discuss the concepts and principles in the AICPA’s new special purpose framework.
Dec 8Kristen Rampe will cover how to diffuse the tension in challenging situations in this one-hour webinar.
Dec 9A key component to improving your firm’s workflow efficiency while enhancing your profitability at the same time is how you leverage emerging technologies.
Dec 16Kristen Rampe will give tips on how to bring confidence into the room and build a valuable network.