I just want to give you some ideas about how you could use pivot tables with your own data.
First, you might want an overview of your time by week.
The website is a portal that provides product information to partners.
You open up the data and take a look.
There are more than 30,000 users in there!
The data looks something like this:
Lots of user data.
Emails are fictitious, of course!
Your boss wants to know some basic information: how many users are currently active?
How many users are being created each month?
What partners have the most user accounts, and so on?
Also, she’s meeting the CEO at lunch.
Can you get that info to her in the next hour?
First, active vs. inactive users.
Some users are “suspended”.
Next, the top 10 partners by number of active users.
This is easily done by using the pivot tables built-in “Top 10” value filter.
Once again, this is an easy job for a pivot table.
Just build a simple pivot table that summarizes by class day:
35 people have registered so far.
Only 8 for the Friday class.
By adding names, you’re free to quickly create a full class list.
One Pivot Table quirk is a tendency to want to counteverything.
Now that you’ve got a report layout you like, how do you update the report each day?
This should take less than a minute, with no busy work.
Yes, you could create formulas to do this, but it will be a lot of work.
In addition, you add conditional formatting to make the higher and lower percentages stand out.
Below, we’ve used green for higher percentages, and blue for lower percentages.
Now it’s clear: most sign-ups are on weekdays.
Tuesdays and Wednesdays are especially good days.
Here are a few more helpful links and resources:
