Learn IT

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… Continue Reading

Ribbon command icons disappear

Question: When I logged on to Email this morning I found that the home menu was missing.  I click on Home and the menu bar reappears, but the minute I do anything else it disappears.  Is there something that I did to change the interface behavior?  I prefer to seen the menu/icon bars visible at all times.  Answer: More than likely you may have double clicked on a ribbon tab, which “hides” the icons to allow for more space. Just double click on the ribbon… Continue Reading

Word Mail Merge to Email – Microsoft Office Repair

Question: I am having a problem with my mail merge from Word to Outlook not processing. I keep getting a pop-up screen asking me to accept but if I do, it looks like emails are working but nothing appears in my Outlook sent folder. Answer: After identifying that she had Outlook set as her default mail system (See previous post), I discovered that one suggestion in an online forum was to run a Microsoft repair, by Click Start > Control Panel > Programs > Programs and Features. 2.   Click… Continue Reading

Pie chart series labels from non-contiguous data

Question: I have a pie chart  that is plotting correctly, but the labels of the legends are incorrect. My chart data is not in simple columns and rows, but rather selected cells within the data. I have tried changing many options but can’t seem to get the labels to display correctly. I would like to create the chart from this spreadsheet so I don’t have to re-enter my data in contiguous columns and rows. Answer: In looking at the spreadsheet, I first looked at the… Continue Reading

Word Tables

Question: I received a Word document with a table consisting of many small columns. The text in the columns does not seem to wrap correctly. Is there anything I can do? Answer: In this example, we used the Autofit Window option rather than Autofit Contents to which seemed to correct the issue. This is found on the Layout tab under Table Tools.