3 hours hands-on workshop on how to use Pivot Tables & Charts Super Effectively and create meaningful, actionable Reports for your Business, in a flash!
Why should you invest 3 hours in learning pivot tables in-depth?
Pivot Tables in Excel is one tool that will give you the power to analyze data in an unbelievable and quick manner! Before even your boss finishes telling you his requirement, your report will be ready! ;-)
What all will you learn (completely hands-on) in these 3 hours?
- Introduction to Pivot Tables
- Data structures (what works, what doesn’t)
- Create single & multilayer pivot tables
- Display options
- Showing values differently
- Summarizing values in various ways
- Sorting & Filtering
- Custom Sorting
- Report filter & pages
- Grouping
- Drilldown
- Connecting slicers & timelines
- Pivot Charts
- Build your 1st DASHBOARD! No programming required!
- How Pivot Tables work in Google Sheet
Trainer:
Rushabh Shah, certified Microsoft Office Specialist (MOS) in Excel, has trained 1500+ working professionals and MBA students in Excel & Data Analytics. After 8 years of job experience, he started www.DLTC.co, a corporate training company.
LinkedIn - www.linkedin.com/in/rushabhjayeshshah/
Full Profile - www.RushabhShah.net
Blog - www.ExcelRush.com & www.YouTube.com/ExcelRush
What you need to get to the workshop
- It’s going to be completely hands-on, must carry your laptop.
- Windows users - Excel 2010 or higher version (2016 or Office 365 version preferred)
- Mac users – Excel for Mac 2011 (2016 or Office 365 version preferred)
- Mac users, must ensure you have Excel. Numbers (from Apple) won’t help for this workshop
- A notepad & a pen
- Super Excitement to learn and then apply your learnings!!!!