86
LESSONS
ALL
SKILL LEVEL
5:46 hr
DURATION
ENGLISH
AUDIO
ENG
SUBTITLES
OVERVIEW
Excel is one of the most requested analysis tools in the job market. The ability to use it to an advanced level is a desirable skill.
Completing the course will enable you to create Pivot Tables, starting with the initial data and variety of options available to you, along with a few advanced options. By the end, you will be able to use Pivot Tables to create reliable analyses which can be quickly drilled-down.
.
WHO IS THE COURSE FOR?
This course is suitable for anyone who has heard of Pivot Tables but don’t really know what one is or how to use one.
It is also suitable for those with some existing knowledge who want to understand them more deeply.
.
LEARNING PATH
PIVOT TABLES AND PIVOT CHARTS
- Create a Pivot Table and Pivot Chart.
- Expand the Pivot Table.
- Delve deeper into the Pivot Table.
- Modify field selections.
DEVELOPING
- Pivot Table options.
- Slicers.
- Dates.
- Formatting.
- Advanced calculations.
- Pivot Charts.
REVIEWS
“It was great to learn about pivot tables and other aspects that affect tabular data in excel that has become so crucial for businesses nowadays!” Paul
“Great course, I’m sure I learned pretty much everything there is to learn about Pivot Charts, and everything that goes with them. Plenty of useful general Excel tips as well to help the whole experience. Phillip is a great teacher, and quickly answers questions, which was much appreciated. I would strongly recommend this course!!” Ario
“Very clear and helpful. Explains the reasoning behind the different actions. Pace is slow enough so that I had time to assimilate what Phillip was doing/explaining yet fast enough to keep me engaged all the way through.” Jocelyne
.
READY TO START?