Finance & Accounting Online Course by Udemy, On Sale Here
Extreme Pivot Table hacks, and best practices in self-service dashboard
An excellent training about Financial Modeling & Analysis
Advanced Pivot Table – Ticket to Self-service Dashboard
The course is presented in four parts. First, the course illustrates where does pivot table stand in the Excel Techniques, and brings up the topic of when to and when NOT to use a pivot table. Second, the course illustrates how to build a self-service dashboard using:o pivot tableso pivot chartso slicerso timelineThird, the course provides 5 extreme hacks for pivot tables including:o How to collapse 12 months’ data into 1 field?o How to break free of Pivot Tables?o How to use Power Pivot without opening Power Pivot?o How to connect tables without using VLOOKUP()?Last, the course explores best practices in building a dashboard. They include:o Do follow data table naming conventiono Do fix changing column widtho Do keep column/bar charts sortedo Do add a heat map for pivot tables
Udemy is the leading global marketplace for learning and instruction
By connecting students all over the world to the best instructors, Udemy is helping individuals reach their goals and pursue their dreams.
Study anytime, anywhere.
Reviews
There are no reviews yet.