Grouping by days of the week in a pivot table

Question: I am trying to create a report from Excel data that was exported from a web application that has date fields and values in which I can get an average of values for the various days of the week. How can I do that?

Answer:  If your data contains a date field, you can display the day of the week using one of the date formatting styles, but a pivot table does not allow you to group by days of the week. However, you can create a new column for your your data which creates a text field from the date field  -  i.e. =text(A2, “dddd”). Then copy that formula down the column (shortcut to copy is  double clicking on the dragging handle) and be sure to add a column heading. Then save your file before creating a pivot table. You can now add that field in the pivot table and you can change value field settings (in the values section) from sum to average.

Learn more about pivot tables and other time-saving Excel features by attending Kim’s Favorite Excel Tips session on 3/6/14 at 9 -10 a.m. in 2020 Bennett Hall. No registration is required.

Shut down iPad to fix synching

Question:  My PC stopped updating my iPad. Do you know if there is a setting I should check to correct this?

Answer: I don’t have an iPad, but before I had a chance to research the issue, he responded back and said he simply rebooted (shut off and on) his iPad and it corrected the syncing issue. I know I have had to shut down my iPhone occasionally if it didn’t seem to be acting correctly. When in doubt, shut it down and restart. Works a lot with computer desktops too!

Applying a template with my presentation

Question: I am trying to convert a couple of ppt presentations over to a new assigned template for a national meeting.  I can’t seem to figure out how to do this simply.  I tried using the re-use slide options and also saving the template as a theme, but the slides don’t seem to convert.

Answer: How you were describing it should work, but the problem was you were on the title page when you saved the template as a theme, and for some odd reason the title page did  not convert properly. When you tried saving the theme from a bullet text slide, the design saved properly. However, I think the easiest way to accomplish this is to open the template sample, and then use the Reuse Slide option from Home tab > New Slide. Then browse for your presentation and right click on one slide and select All Slides. All slides should be inserted into the template, taking on the template’s design. You may have to delete slides from the template you are not using and you may have to tweak the layout on the slides. We found on your presentation the title page needed to be applied separately because the original presentation may have had manual changes.