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.

los angeles financial consulting firm

Categorized in:

similar articles

Learn to think and approach problems like our financial consultants.

Financial Reporting & Accounting

A Brief Primer on Financial Data Management and Reporting

During my recent engagement with a leading management consultancy firm, I discovered an issue that is quite common among complex organizations: over-customization in financial data management, data tagging and financial report creation. This over-customization often manifests itself in financial reporting views that ultimately fail to correspond to GL data hierarchies. The issue is exacerbated by… View Article

March 15, 2023Chris Routhe

Business Advisory

A Look at Team Assessment Projects

As 8020 Consultants, we focus on issues that produce provable results measured by an increase in our Clients’ bottom line. While financial project execution and interim financial management are our bread and butter, sometimes, operational improvement goals bring our attention to the softer side of a corporation – its people. In the cases where the… View Article

March 8, 2023Ellen Vayner

Financial Planning & Analysis

Finance and Operations: The Path to Strategic Alignment

When thinking of Finance and Operations, envision two sides of the same coin. Operations executes the company mission and strategic goals while consistently adapting to ever-changing global dynamics. Finance assures resources are allocated properly to these same strategic goals, while working as the gatekeepers of the organization’s financial health. These two departments are more interrelated… View Article

March 1, 2023Romesh Jayawardene

See All

Back to Insights