Once you have successfully installed PowerExcel, these short video tutorials will help you learn the basics of how to use PowerExcel. If you are using PowerExcel for the first time, it is best to watch the videos in chronological order.
This video shows how to connect to a PowerExcel database directly from a standard Excel spreadsheet.
This video shows the use of the PowerExcl PivotTable to create a Slice.
This video shows the use of PowerExcel Power Query to create a Slice.
4. Entering Data in a PowerExcel Slice - Part 1
This video shows how to use PowerExcel to enter data by typing in numbers into a slice.
This video shows how to use PowerExcel to enter data into a Cube by copy-pasting numbers into a slice.
This video shows how to : 1. Create new Members or rename existing Members 2. Modify the Hierarchy structure or create a new Hierarchy 3. Edit Hierarchy weights, and 4. Sort and filter the Member list
This video shows how to add a second PivotTable to a Slice and change its Range Reference to show a different set of data.