Excel Basics

The UNC Libraries Research Hub provides spaces, technology, and expertise to assist with all phases of research. Services at the three Hub locations are tailored to the users of each library. The Hubs form an interdisciplinary network, complete with partners across campus.

 

The course materials is licensed under Creative Commons

Getting started with MS Excel

1
Excel Basics, Module 1: Getting Started
14.11
Learn keyboard shortcuts useful for navigating around large spreadsheets, and some best practices for entering data in spreadsheets.
2
Excel Basics, Module 2: Functions
31.58
Learn several functions useful for cleaning and rearranging your data.
3
Excel Basics, Module 3: Common Problems
25.50
Learn several ways to handle problems commonly encountered when using data from another source (as opposed to creating your own): splitting columns on delimiters and filling blank cells. Also, making absolute cell references.
4
Excel Basics, Module 4: VLOOKUP
29.13
Learn how to pull data from a source table into your spreadsheet using the VLOOKUP function.
5
Excel Basics, Module 5: Pivot Tables
34.51
Learn how to easily summarize data within your spreadsheets using pivot tables.

Course source:

https://unc-libraries-data.github.io/Excel/Excel_Workshop_Instructions

Be the first to add a review.

Please, login to leave a review
This website uses cookies and asks your personal data to enhance your browsing experience.