Skip to Main Content

Indiana University Indiana University


Archive for the 'Excel' Category

Allowing Multiple Filters in Pivot Tables

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:

Jen

Can’t Uninstall Office 2013

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.

Cloud spreadsheets — not ready for statistics?

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.

via John Walkenbach’s Spreadsheet Page
(more…)

Microsoft Excel 2013: Using Flash Fill

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. (more…)

Excel 2010: Assigning Keyboard Shortcuts to Macros and Adding Macro Buttons

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:

dialog box for Macro Options

This dialog box shows the shortcut key.

(more…)

Excel: Word Wrap and Alignment Options in Cells

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.

Wide Column Header

The text in cell D1 is much wider than that in other cells in column D

(more…)

it2go Episode 48 – Excel Pie Charts

On this week’s episode we’re talking about creating Pie Charts in Excel and discuss semiotics in different cultures.

And don’t forget to join us for the IT Training Conference!

Follow us on Twitter

Like Us on Facebook

Add us on iTunes

it2go – The IT Training Podcast

it2go Special – Join us for Year 2 of the IT Training Conference

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.

Check our conference page for a full schedule and instructions on how to sign up and listen to our special conference episode for all the details.

Follow us on Twitter

Like Us on Facebook

Add us on iTunes

it2go – The IT Training Podcast

Excel 2010: Exporting or Importing Data to Text Files

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:

0000011111         Bill
0000022222         Susie
0000033333         John
0000044444         Mary

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).

(more…)

it2go Episode 45 – New On The Blog

On this week’s episode we’re talking about what’s new on the IT Training Tips blog.

Follow us on Twitter

Like Us on Facebook

Add us on iTunes

it2go – The IT Training Podcast

Get Training Tips via RSS Subscribe to Entries feed or Read Comments via RSS Subscribe to Comments feed.