Course details
No matter if you are a Beginner or an Advanced user of Excel, you are sure to benefit from this course which goes through every single tool that is available in an Excel Pivot Table. The course is designed for Excel 2007, 2010 or 2013.
In no time you will be able to analyze lots of data and tell a story in a quick and interactive way, learn how to build stunning Dashboards and get noticed by top management & prospective employers.
There are 14 different chapters which include 51 short tutorials so you can work on your weaknesses and enhance your strengths whenevr you have a spare moment. Each chapter was designed to improve your Pivot Table skills with extra time saving Tips and real life business Case Studies.
So go ahead and learn from the following in depth Pivot table subjects:
| 1 | CUSTOMISE YOUR PIVOT TABLE |
| 2 | VALUE FIELD SETTINGS > SUMMARIZE VALUES BY |
| 3 | VALUE FIELD SETTINGS > SHOW VALUES AS |
| 4 | GROUPING |
| 5 | SORT |
| 6 | FILTER |
| 7 | SLICERS (NEW IN EXCEL 2010) |
| 8 | CALCULATED FIELDS & ITEMS |
| 9 | PIVOT CHARTS |
| 10 | CONDITIONAL FORMATTING PIVOT TABLES |
| 11 | GETPIVOTDATA formula |
| 12 | MACROS |
| 13 | DATA MANAGEMENT |
| 14 | BONUS VIDEOS |
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Microsoft Project 2016 Advanced St. Paul's CollegeUSD 12Duration: Upto 18 Hours
- Microsoft Office Advanced Adams AcademyUSD 39
USD 410Duration: Upto 58 Hours
