Learning with Lynda.com: Easily Discover Information About Your Excel Data

Often, it can be challenging to understand large amounts of Excel data from different perspectives. Excel has a number of direct formulas to find solutions for items like the sum of the data or the averages, but it can be difficult to understand how many variations of results, or unique entries, exist in a certain selection of data. For example, if you have 1,000 survey results that include respondents’ favourite dessert but would like to know how many types of desserts were suggested, it would be a cumbersome task to determine the number of unique entries manually. The author in this short Lynda.com video, “Count the number of unique entries,” explains a simple alternative for summarizing the number of unique results within a dataset and provides a few other helpful Excel navigation tips along the way!

Read more at our lynda.ubc.ca site to learn more about this subject and to find associated resources.

Hot Lunch: Feb. 22, 2017 (feat. Andrew Simpson, Vice President, Finance & Operations)

hot-lunch-Plate-300x236

Hot Lunch is a cross-campus networking initiative that brings together UBC staff over lunch to meet new people and talk about topics that impact the university.

February Hot Lunch

Join your colleagues on Feb. 22, 2017, for lunch and a chance to chat with Andrew Simpson, Vice President, Finance & Operations.

Tickets are available at http://stjohns.ubc.ca/hot-lunch/. The cost for the lunch is $10, payable in advance.