It is a sad month for Microsoft Office users. Click here to find out why.
Archive for the 'Excel' Category
While working on metrics for our web site, I discovered that by default you are only allowed to apply one filter per field when using a Pivot Table. So if you try to apply a second filter, the first filter will be removed. In good news, you can change the PivotTable Options and allow more than one filter to be applied to the same field.
Here is a video I found that shows specifically how to do this:
IT Training will be teaching Microsoft Office 2013 workshops this fall, and we are anxious to begin telling the IU community about the new features that are available in this version of the popular suite. If you are planning on taking some of our free workshops or webinars, you might want to download and install the software from IUware. Remember, Indiana University faculty, staff, and students may download most of the software available from IUware for free.
If you decide to download and install Office 2013, I would encourage you to download the 32-bit package, even if you are planning on running it on a 64-bit system. Earlier in the summer I installed the 64-bit suite on a laptop running Windows 7, and I was very unhappy with the results. Every time I tried to use Outlook, Word, or PowerPoint, the application would freeze and/or crash. After discussing this issue with the Support team here at IU, and reading multiple forums and Microsoft Help articles, I uninstalled the 64-bit version and installed the 32-bit version instead. After that, I didn’t have any problems.
I have left out an important part of the story. When I first tried to uninstall Office 2013, I was unable to do so. While in the Control Panel, I selected Microsoft Office 2013, clicked on the Uninstall link at the top of the window, and waited. Nothing happened. I tried again. Nothing happened. I probably even tried a third and fourth time before I realized that this was simply not going to work.
After a little digging, I found the solution on this Microsoft Support page:
http://support.microsoft.com/kb/2739501. I downloaded the Fix it tool that they provided, and then I was able to uninstall Office 2013 from the Control Panel just as I normally would.
Hopefully this article will save you some time if you decide that you want to uninstall the package.
More of our computing lives are shifting to “the cloud” — organizations are seeing some costs savings, users are seeing more convenience, collaboration, and mobility advantages. But the shift may not be for everyone, yet. For instance, folks who are trying to do statistics using cloud-based spreadsheets — Google Docs, Excel Web App, Zoho Sheet were examined and all were found somewhat lacking, at least according to one study.
A new feature in Excel 2013 called Flash Fill allows the user to separate or combine data within entire columns based on the pattern that Excel picks up from the other columns. You can also use Flash Fill to change the case of text. As long as Excel can pick up a pattern, it will work to complete the column for you. Read the rest of “Microsoft Excel 2013: Using Flash Fill” »
Do you find yourself forgetting keyboard shortcuts for your Excel macros? When first recording a macro, you will have an opportunity in the Record Macro dialog box to specify a shortcut key for the macro. However, you may eventually forget the shortcut, or if you didn’t assign a shortcut key when you first recorded the macro, you may now like to assign one – or perhaps you have even decided to change the shortcut key to something different.
To view your macro shortcut keys, on the View tab of the Ribbon, click the Macros button, select your macro, and choose Options…. You will see the Macro Options dialog box:
Sometimes a column heading in Excel seems about a mile wider than any of the entries below it in the column. In the graphic below, the Column D heading, Years With Company is 18 characters wide while all the entries below it will be only one or two characters. In many such cases the goal is to keep the column as narrow as possible. Let’s look at some techniques for positioning the text – using word wrap and alignment.
The IT Training Conference is back this year, after the Statewide IT Conference. All of the sessions will be held on September 25th starting at 1pm in the Indiana Memorial Union. Enrollments are underway, and classes are filling up fast.
You may need to save Excel data in text files in order to be able to use the data in other programs or applications. There are several text file formats that are supported by Excel. The two commonly used file formats are: delimited text files (.txt) in which tabs separate each field of text, or comma delimited files (.csv) in which commas separate each field. You can easily save Excel data into one of these formats or import these text formats into Excel. Remember, however, that formatting, graphics, and other objects will be lost when saving data in a text file.
Saving as a Comma Delimited File
We will illustrate how to save Excel columns as a comma delimited file. The original data might look something like this:
NOTE: To display preceding zeros in a column, you can go to the Format Cells dialog box and choose Custom. On the right-hand side, scroll up (if necessary) and click the single 0. In the Type field, enter as many zeros as required digits (in this example, the number of zeros would equal 10).