Excel Tips

Tips from the Finance Trenches: Best Shortcut Ever! Create a Pivot Table In 3 Seconds

If you are a heavy user of MS Excel, and use pivot tables on a regular basis, you know that utilizing such features can take a long time. By my calculation, it takes about 13 seconds to set up a pivot table containing all necessary data. In this day and age of maximizing productivity and streamlining workflow, that may as well be an eternity.

To speed things up, I suggest using the following two keyboard shortcuts that will cut down this pivot table task by 76.9 percent (to just 3 seconds). The best part? Using these shortcuts doesn’t even require a mouse. So set your timer and let’s give it a try.

Step 1: Start with a basic set of data as follows:

 

Step 2: Use the shortcut CTRL+A to select all data on the tab for use in your pivot table.

Time required = 1 second. 

Step 3: Now that we have the data selected, use the shortcut ALT+N+V+T and press ENTER.

Time required = 2 seconds.

Then POOF! Just like that, your worksheet contains a pivot table right next to your data set and is ready to use, as shown below:

Now that you just added 10 seconds back into your day, all you have to do next is decide what you will do with your extra time.  Perhaps make three more pivot tables?

Love Excel shortcuts? For more quick and easy Excel solutions from the trenches, be sure to check out the following:

Would you like to leverage more advanced capabilities in Excel that can make an immediate impact on your organization? Keep in mind that 8020 Consulting is here to help. Just click below to ask us a question or learn more.

Contact Us

Categorized in:

similar articles

Learn to think and approach problems like our financial consultants.

Financial Systems

Key Questions When Implementing a Global Consolidation and Reporting System

This blog is based upon my previous experience managing the global roll out of SAP Business Process and Consolidation (SAP BPC) for a multinational company. The company I worked for was a $7B IT Distributor that was organized along four geographical regions: North America, LATAM, EMEA, and Asia Pacific. In our case, the company was… View Article

December 5, 2019David Krassin

Business Advisory

How to Create an Internal Business Plan for a New Company Initiative

Business plans for start-up companies have become mainstays in the business world. But more and more company initiatives and projects have begun to require business plans as a way of validating prudent investments and company spend as maturing businesses look for innovation within to drive future revenue growth. A time may come in a business… View Article

December 3, 2019Lester Robert

Financial Planning & Analysis

Tips from the Trenches: Salesforce Sales Forecasting

At the end of 2012, I joined a Finance team supporting the International TV Distribution sales group of a major entertainment company. As the year was coming to an end, Sales strongly voiced its frustration regarding the extremely manual and archaic sales tool that was available for sales forecasting. Their homegrown tool was created many… View Article

November 19, 2019Lizzette Acuña

See All