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:

pivot table.png

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:

pivot table 2.png

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

Notes from the Field: Avoiding Surprises in ERP Stabilization Projects

This blog is based on my recent experience with a client that had implemented Microsoft Dynamics AX/Dynamics 365 for Finance and Operations. That enterprise resource planning (ERP) software offers benefits such as end-to-end system connectivity, resulting in profitability, transparency, and efficiency. It’s robust, but agile at the same time, and has a very familiar Microsoft… View Article

August 22, 2019Jackson Quach

Financial Planning & Analysis

Optimizing Your Price Increase Strategy

Price increases are a fairly controllable tactic for Finance teams looking to improve profitability. Ultimately, price increases can come in several forms (e.g., adjusting rebates or cost to serve) and may only apply to select customers. After collaborating with leadership, sales, and marketing teams to select the specific product/solution(s) for which to raise pricing, several… View Article

August 15, 2019Marco Moreno

Financial Systems

NetSuite SuiteAnalytics: Leveraging Built-In BI

While NetSuite has long been a leader in embedded analytics, Oracle clearly recognized the need for more robust reporting and analytics tools. As a proxy to and an improvement upon other third-party, plug-in solutions, Oracle developed its own solution natively embedded within its already industry-leading ERP. Netsuite SuiteAnalytics is a built-in analytics and reporting package… View Article

August 13, 2019Chris Moss

See All