Solved

Excel Assignment Schedule template

Posted on 2013-10-28
6
613 Views
Last Modified: 2013-11-12
I am using the Assignment Schedule template from Excel 2013. How do I edit the formula or content of the Assignment box (the pivot table) in the Assignment Detail worksheet. Thanks
Capture.JPG
0
Comment
Question by:leblanc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 1

Author Comment

by:leblanc
ID: 39607053
Nobody can help me out?
0
 
LVL 92

Expert Comment

by:Patrick Matthews
ID: 39608254
That appears to be a Slicer, not a PivotTable...

In any event, posting images of your file is not tremendously helpful.  Posting the actual file would be much more useful.
0
 
LVL 1

Author Comment

by:leblanc
ID: 39608410
Sure. It comes with Excel. Here it is again (see attached). Also, I am having problem in changing the title of the column from Instructor to People. Each time I did that, when I clicked on refresh, the Instructor column disappeared. Thanks.
Assignment-schedule1.xlsx
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 14

Accepted Solution

by:
Stacy Brown earned 500 total points
ID: 39608884
The data is changed by changing it on the Assignment Schedule Tab

You can change the slicer settings by right clicking the title area of the slicer and then choosing Slicer Settings.  You can also Clear Filters and Refresh all with a Right-click.

If you rename the Instructor field People on the Assignment Schedule Tab you then need to reselect PEOPLE as a field to be displayed and then in the ROW area Right-click People and choose move to the beginning.

I hope this helps.  See the modified attachment
Assignment-schedule1.xlsx
0
 
LVL 1

Author Comment

by:leblanc
ID: 39609321
Thank you for the fix. I see that each time I added a row with data in the Assignment Schedule tab, it updated the table in the Assignments Data tab with the refresh of the Assignment slider. What function linked the Assignment Schedule with the Assignment slider? I tried to start this spreadsheet from scratch and it did not update the data like this spreadsheet. Thanks
0
 
LVL 14

Assisted Solution

by:Stacy Brown
Stacy Brown earned 500 total points
ID: 39609466
It seems to be a pivot table with slicers added at the end.  So your main grid (People through Progress) is the pivot table.  The little mini-tables (Assignments through Courses) are the slicers.  The Pivot Table was made first then the rest.
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This process describes the steps required to Import and Export data from and to .pst files using Exchange 2010. We can use these steps to export data from a user to a .pst file, import data back to the same or a different user, or even import data t…
Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

632 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question