Easy Excel PivotTable Skills - PivotTable Power Tips
- 41 mins on-demand video
- 1 article
- 6 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to Udemy's top 3,000+ courses anytime, anywhere.Try Udemy for Business
- Build better PivotTables faster.
Know the secret "PivotTable Wizard."
Build a simple, quick and easy dashboard.
- Know how to consolidate multiple worksheets into one PivotTable report.
- Ask the instructor questions, and synergize with other students in the Q&A section.
- Have an Intermediate level of Excel proficiency or have been using Excel on a daily basis for at least 1 year.
- Be familiar with Excel 2010 and beyond.
- Have a 2010 or later version of Microsoft Excel.
No fluff here, just skills!
Unlike other courses, we will not get into the history of PivotTables, instead we just start learning right away.
Have you been using Excel regularly for over 1 year? Jump right in - you are ready to take your data analysis/reporting to the next level!
- Would you like to create an interactive report that can quickly be used to summarize large amounts of data? Then look no further than a Pivot Table.
- Are you swarmed by the mountains of data you have?
- Do you want to see trends and patterns at a glance?
- Your bosses want answers (QUICK!) from your collection of data and each of them want something different out of those numbers.
If you have ever been in any of these situations, then PivotTable reports are just the thing for you.
We just get right into it here.
Ready. Set. Go!
Don't Get Mad...Get Skills!
- Want to become a PivotTable Power User? Then this course is for you!
- Anyone that has been working with Excel for at least 1 year, and wants to learn PivotTables.
In this lecture you will learn how to use the Value Field Settings to view PivotTable data from one value field in two separate ways. One column will display the Total Sales in a currency format, and another column will display the same data as a Percentage of the sales Grand Total.
By learning how to use your Value Field settings you will be able to use custom calculations to better analyze your data.
There are many custom calculations available within your Value Field Settings dialogue box, so be sure to download the additional resource detailing them.
Keep on learning!
Have you ever had a pivot table report set up just right? You have the columns set up to a specific width, certain rows highlighted, you have the Accounting number format in place, and you've got your column headers centered.
Now you refresh your PivotTable so that you can update your data - suddenly the columns have Auto-Fitted, and all of the formattings are gone!
The centered Column Headings, the number format, and the highlighted rows are gone!
In this lesson, you will learn how to preserve the formatting when your Pivot Table report is updated.
Let's Keep On Learning!