The Insider Picks team writes about stuff we think you’ll like. Business Insider has affiliate partnerships, so we get a share of the revenue from your purchase.
Microsoft Excel is arguably the most powerful program on your computer, and those who know its inner workings can do some pretty amazing things with it.
While managing your finances and constructing your fantasy football draft board are fair uses of Excel, neither task is utilising the program to its fullest potential. Excel is usually working its hardest when large tables with tons of data are involved, and that is when it is important to know how to incorporate pivot charts and pivot tables into your Excel experience.
If you haven’t heard of pivot charts and tables you aren’t alone. It’s estimated that only 10% of Excel users use the feature within the program, but those that do can do wonders with it — it’s a go-to tool for finance professionals for good reason. When you have a table filled with extremely large datasets, pivot tables allow you to simply compare segments of data without going through each cell.
For those looking to take their Excel knowledge to the next level, Udemy is offering a two-course series on pivot tables produced by Optima Train. The first course, “Practical Excel 2016 Pivot Tables and Pivot Charts,” teaches students how to construct and incorporate pivot tables into their Excel usage. Once students have a working idea of how to use pivot, they can choose to move on to “Excel 2013 PowerPivot and Advanced Business Intelligence Tools,” if they wish to further hone their skills
The phrase “work smarter, not harder” is extremely applicable to Microsoft Excel. If you’re looking to fine tune your Excel skills — be it for personal or work-related reasons — these two classes can help you do just that. Each are available for just $US19 with the promo code “FEBUDEMY”.
This article was originally published on 1/14/2016.
Disclosure: This post is brought to you by Business Insider’s Insider Picks team. We aim to highlight products and services you might find interesting, and if you buy them, we get a small share of the revenue from the sale from our commerce partners, including Amazon. Jeff Bezos, CEO of Amazon, is an investor in Business Insider through his personal investment company Bezos Expeditions. We frequently receive products free of charge from manufacturers to test. This does not drive our decision as to whether or not a product is featured or recommended. We operate independently from our advertising sales team. We welcome your feedback.Have something you think we should know about? Email us at [email protected]
Business Insider Emails & Alerts
Site highlights each day to your inbox.