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.

M&A Due Diligence & Transaction Support

3 Tips for Responding to Requests in the Sell-Side Due Diligence Process

Entering a sell-side due diligence process? Here are 3 things to consider when responding to diligence requests. #1 – Understand the bigger picture. It is easy to get swept up in a sell-side process (especially one with multiple buyers) and be overwhelmed by the volume or difficulty of various data requests. We can avoid some… View Article

January 23, 2020Mitch Browne

Financial Planning & Analysis

BI & EPM Planning and Budgeting: Automation and Acceleration Tips

Budget season for companies can be extremely challenging if the budget process is manual, inefficient or not-scalable. An Enterprise Performance Management (EPM) / Business Intelligence (BI) software tool is needed in order to negate those process issues. Best practices also exist that can be adopted in the budgeting process, while using the selected tool. Let’s… View Article

January 21, 2020Vikram Mehta

Financial Reporting & Accounting

Startup Finance: Building Operations Through Two Rounds of Funding

After several years as Director of Finance at a major entertainment studio for domestic TV production and distribution, I was excited to be hired for a startup finance position – as the first finance/accounting/back-office person and the company’s 12th employee. The company eventually became a multi-platform media destination offering Olympic and lifestyle sports programming on… View Article

January 16, 2020Yasuko Furuya

See All