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!
You will be prompted to login with your CWL. Click on the image for one time viewing and for future reference, bookmark your free login access at http://lynda.ubc.ca.
Do you have any other recommendations for discovering insights from data in Excel? Share your ideas in the comments below or send us a note and we’ll feature it in a future Learning with Lynda.com.
Learn more great tips in the full course Excel 2013 Tips and Tricks (4h 34 m)
Other UBC Learning Resources
- 2016 Excel Essential Training: Lynda.com, on-demand (8h 51m)
- Become an Excel 2013 Microsoft Office Specialist: lynda.com, on-demand learning path (25h )
- Excel Introduction: Continuing Studies, Feb. 21 & 28 / June 7 & 14
- Advanced Excel Skills for Managers: Continuing Studies, March 17
- Excel 2013 Basic and Advanced – Essential Administrative Skills Program: Human Resources – Okanagan Campus
Troubleshooting with lynda.com:
Having trouble with lynda.com? Can’t login? Email firstname.lastname@example.org and we will assist you.