Get startedGet started for free

Grand total percentages

Your colleague from the finance department has come to you with a new request. They know you added a column related to cash payments that interest them. But they need help determining how many orders fall into the different Cash Payments categories and what the distribution looks like.

If you lost progress, close any open reports and load 4_4_grand_total_percentages.xlsx from the Workbooks folder. If a message appears saying "Security Warning - External Data Connections have been disabled", click on Enable Content and continue.

This exercise is part of the course

Data Preparation in Excel

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise