Excel Data Analytics Register online at https://training.unl.edu

Date: Time: 9:30 am–11:00 am
Canfield Administration Building South Room: 316
Additional Info: ADMS
Contact: Ranelle Maltas, 402-472-0585, ranelle@unl.edu
If you work with a lot of data, you will want to learn how to tame that information and use it to find exactly what you are looking for. Learn to simplify how you work with large amounts of data by sorting and/or filtering the data to exactly what you need. Learn PivotTables to look at your data in a new way. You will work with more advanced functions and learn how to pull information from another spreadsheet together using VLOOKUP. Learn to control the workbook by linking cells, worksheets and workbooks as well consolidating your information. If you receive data from other sources that is not in the format you require, you can combine data from different cells together or parse your data with the tools and functions of Excel.

At the end of the workshop, attendees will be familiar with:
*Working with multiple worksheets and workbooks including linking cells
*Sorting and filtering data
*Working with tables
*Using lookup functions
*Creating data tables
*Working with PivotTables
*Using Flash Fill to concatenate and parse

Additional Public Info:


image for event 100055

Download this event to my calendar