Course Description
UPDATED: July 2015
Are you looking to take your Excel 2013 skills to the next level?
Want a way to analyze your spreadsheets fast?
Tired of spending too much time filtering, sorting, and summarizing?
Some people spend so much time creating formulas, copying and pasting numbers and records, when they can use PivotTables.
Those
that do use PivotTables can make better business decisions, analyze
faster, and have more control over their data, and confidence in their
skills.
In this course you'll learn:
- How to create PivotTables
- How to filter, and create custom sorting lists
- How to format values, and create calculated fields
- How to create Slicers and Timelines for ultra fast filtering
- How to change the layout and style
- How to create PivotCharts
- and more
Learn
to create PivotTables in hours, not days. Then use that knowledge to
create user-friendly, interactive reports in minutes, not hours!
Whether
you are a small business owner looking to better understand sales
trends, an assistant creating weekly reports, or you're looking for a
way to better track household expenses, if you are using Excel, you need
PivotTables!
Most exercises can also be applied to Excel 2007, and Excel 2010.
Curriculum
Automatic v. Manual Updating
Calculated Fields
Clearing Deleted Items from a Pivot Table
Conclusion
Conditional Formatting
Creating a Custom Sort List
Creating Multiple PivotTables from Report Filters
Creating Your First PivotTable
Creating Your Second PivotTable
Displaying Values as Percentages, Difference, and Rank
eBook: 2013 PivotTables
Exercise
Exercise: Products by Country
Exercise: Sales by Salesperson Quarter
Filters
Finding the Top or Bottom Values
Formatting Values
Grouping Date Data
Grouping Records
Intro to PivotCharts
Keyboard Shortcuts
PivotTable Layout
PivotTable Styles
Report Filters
Section 1: Excel 2013 PivotTables
Section 2: More Exercises & Resources
Slicers
Summarize Data By…
Timelines
Viewing the Details
Welcome to Stress-Free Excel 2013 PivotTables
LINK FOR THE FREE COURSE
100% Off, Udemy 100% Off, Udemy Coupon, Udemy Coupon Code, Udemy course, Udemy course download, Udemy course reviews, Udemy courses, Udemy courses for free, Udemy courses free, Udemy courses free download, Udemy discount, Udemy download, Udemy education, Udemy free, Udemy free course, Udemy free courses, Udemy free online courses, Udemy online, Udemy online course, Udemy online courses, Udemy online courses review, Udemy reviews, Udemy tutorial, Udemy tutorials, Udemy.com free courses,