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 Planning & Analysis

Subscription Business Model Metrics: A Systems Check

Clothing retailer Bloomingdale’s recently launched a fashion-rental-subscription service, just one example of the growing trend towards “subscription” businesses. When executed successfully, the appeal of subscription revenue is apparent – recurring revenue, increased customer lifetime value (LTV), and reduced customer churn. However, because subscription business model metrics aren’t always planned from the outset, this business model… View Article

October 10, 2019Mitch Browne

Financial Reporting & Accounting

5 Ways to Speed Up Your Month-End Close Process [Tip Sheet]

Is your company plagued with that ever dreadful lengthy month-end close? Is it taking weeks to get the books closed and financial reporting out to management? How can you improve your month-end close process, close earlier, prepare timely financials, and give management the time they need to make the right business decisions necessary to stay… View Article

October 8, 2019Gabriel Benabou

Financial Planning & Analysis

Retail Marketing KPIs & Other Retail Finance Performance Strategies

As the success of online retailers skyrockets and online shopping continues its rise in popularity, brick-and-mortar retailers have seen a significant decline in business. While most subscription-based and online businesses have a strong digital marketing team and marketing plan in place, many brick-and-mortar shops are lagging in their knowledge of retail marketing KPIs and strategies.

October 3, 2019Jackson Quach

See All