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

Modifying the “AutoCorrect” in Word

Word’s autocorrect feature attempts to make our lives easier by viewing the words that we type and deciding whether we did it correctly based on dictionaries and styles programmed into it.

For example, Word will automatically capitalize the first letter of a sentence and the days of the week.

If a common word is incorrectly typed into Word, it will be corrected automatically, i.e. if I type begni, Word will change it to “begin” as soon as I hit a trigger (space bar, period, comma, etc.)

However, if it is not a common word, but Word “thinks” that it has been typed incorrectly, a red squiggly line will appear instead, i.e.  Currency: british ponud sterling.

Read the rest of “Modifying the “AutoCorrect” in Word” »

Internet Explorer and YouTube problems?

The last week or so I’ve run into a problem with IE where when I try to view some YouTube videos I see a flash of the screen that should load and then I’m redirected to a page where I see this error:
This page can't be displayed

In looking for a solution, I found some comments from other people having the same problem. They had come up with two options to solve the issue, either:

  1. Use a different browser like Firefox or Chrome
  2. Log out of Google+

Not sure why logging out of Google+ fixes the issue but I found it worked for me.

Jen

it2go Episode 73 – Pluralsight Pilot

After a long absence, the it2go podcast is back with a look at the current Pluralsight pilot being offered by IT Training.

Pluralsight is a video training site that focuses on technical training topics like programming. They recently added Digital-Tutors, a site focused on high quality creative projects.

To sign up for the pilot, send an email to itpilot@iu.edu.

it2go – The IT Training Podcast

Follow us on Twitter

Like Us on Facebook

Add us on iTunes

Canvas spotlight: The Calendar Tool

Canvas, the learning management system recently chosen to replace Oncourse, has many tools that will help instructors and students better manage their academic lives. In this series we’ll be examining some of the nifty things we can do with these tools.

The first tool to be spotlighted is the Calendar tool. When I first started exploring this tool, I was very pleased at how intuitive it was. The more I played around, however, the more impressed I became. Let me show you some of the highlights.

Read the rest of “Canvas spotlight: The Calendar Tool” »

Firefox: Adding Sites to the New Tab Page

Recently, I wanted to add a website to the new tab page that appears in Firefox when a new tab is opened. In looking at the help pages from Firefox, I found it showed how to work with pages that were automatically added and how add a bookmarked page. However, it seemed to me that bookmarking a page first shouldn’t be required. I searched on Google and found other people with the same issue. At this pointed I decided to just try some things, and I found that it is possible. The screen cast included below shows how to add a website to the new tab page:

Audacity’s Envelope tool makes you a DJ

I recently had the chance to invite friends and family to a celebration, and as I was planning the event I decided I wanted music – both for ambiance, and for dancing – but I really don’t like hiring a DJ for these things. Aside from wanting to save money (which was a factor, of course), I’m not very fond of the emcee role that most DJs naturally take on. So I set about creating my own playlists for my iPod touch.

The playlist idea was shaping up nicely until I learned that my iPod touch, being 4th generation (I mentioned being careful about money, right?), did not have a very important feature: the ability to crossfade tracks. This is one thing that a DJ really helps with – getting rid of the pauses that come between songs. Some of those can be mitigated by going into the track info in iTunes and choosing specific start and end times for each song (very useful for songs that have ginormous gaps at one end or the other), but it doesn’t have that smooth transition that makes it sound professional.  Read the rest of “Audacity’s Envelope tool makes you a DJ” »

How to manage what syncs from Box on your local computer

Do you want some documents, such as just those files you use at the office, to remain only in your Box account but not be synced to your local computer? You can be selective about what your local Box Sync app slurps from your Box account. There are two ways to do this.

When using a browser in your account on the Web, for each folder you can right-click an options arrow located next to the Share link and choose Sync Folder to Computer or else Unsync.  This includes or excludes the entire folder for all your synced devices.

If you don’t want certain folders on a single local system, you can also delete the folder from your Box folder on that local system. Deleting a folder in your local system does not delete the same folder on Box; it will merely unsync the folder, remove it from your local system, and keep it saved on Box. However, if you want to delete this folder in both locations, you need to explicitly delete the required folder in your Box account on the Web. This behavior protects content from unintentional and accidental deletions.

A special note: This behavior only applies to folders. If you delete a file in your local system, you will automatically be deleting it from Box as well.

See https://support.box.com/hc/en-us/articles/200852677-Box-Sync-4-0-Release-Notes#unsyncondelete

Tableau Experience in Indianapolis, April 24

Join us for The Tableau Experience in Indianapolis and transform the way you think about data. Mark your calendar and learn how you can make an impact with data in your department and beyond. All are welcome!

Indianapolis | 24 April, 2014 | 2:00 – 5:30PM EDT

Free registration

Read the rest of “Tableau Experience in Indianapolis, April 24″ »

Comparing two folders in Windows

Have you been in the situation where you have two folders that are almost exactly identical, and you want to know the difference between the two folders? Maybe you want to compare the System32 folder of one computer with that of another, to make sure they both have the same drivers. Checking for differences between folders in Windows is pretty simple, but is a bit hidden from plain view.

For the sake of this tutorial, consider that we FolderA and FolderB, both on the Desktop, and we want to see the difference in the folders’ contents. To do this, we will make use of the Windows Command Processor, which is also known as the Command Prompt.

Read the rest of “Comparing two folders in Windows” »