Creating PivotTables in Excel with Jet Reports
Want to learn how to build Excel PivotTables? How can you build eye-catching PivotTables like this?
This introductory course will teach you the basics, and some advanced techniques, to build informative and stylish Pivot Tables.
Start with some basic concepts and terminology, then move into building your first PivotTable. Our instructor will provide an easy to follow example. Follow along as he develops a pivot table, then gives you a similar project to work on.
We’ll then move into some of the more advanced aspects of PivotTables, all at a pace that is comfortable for you.
Once this course is completed, you can move on to our Dashboarding course and learn how to leverage your PivotTables to build exciting dashboards. Learn about the different types of charts, when best to use them and styling techniques to make your dashboard stand out.
Your Instructor
Bryan brings to the table over 3,000 hours of training users how to use Jet and Excel. A native of Southern California, he found a new home in the Pacific Northwest where he, his wife and two children moved when he joined the Jet team in 2014.
He has a background in accounting and computer programming which has made working with Jet a perfect match.
Bryan is recommended by 4 out of 5 people that recommend things.
Course Curriculum
-
StartGeneral PivotTable Information
-
StartCreating a PivotTable from a Jet Enterprise Cube
-
StartCreating a PivotTable from a non-cube data source (3:38)
-
StartIntroductory Concepts
-
StartComponents of a PivotTable
-
StartPivotTable Example (pt 1) (3:34)
-
StartPivotTable Example (pt 2) (3:36)
-
StartFiltering Data
-
StartPivotTable Example (pt 3) (5:23)
-
StartPivotTable Student Exercise (pt 1)
-
StartPivotTable Student Exercise Solution (pt 1) (4:26)
-
StartPivotTable Layouts
-
StartPivotTable Example (pt 4) (3:20)
-
StartFormatting PivotTables
-
StartRenaming Column Headers
-
StartSorting PivotTable Data
-
StartPivotTable Example (pt 5) (5:02)
-
StartPivotTable Student Exercise (pt 2)
-
StartPivotTable Student Exercise Solution (pt 2) (3:16)
-
StartAdvanced PivotTables Introduction
-
StartShow Values As (3:30)
-
StartShow Properties in Report (3:33)
-
StartValue and Label Filters
-
StartConditional Formatting and Example (4:09)
-
StartPivotTable Example (pt 6) (7:02)
-
StartPivotTable Student Exercise (pt 3)
-
StartPivotTable Student Exercise Solution (pt 3) (5:03)