Guides: Excel Data-wrangling, Analysis, and Visualization Workshop: Excel Data Workshop

Exercises

Please download the exercise files and instructions for practice during the workshop. The PowerPoint slides are a reference to accompany the presentation.

Video Recording of Workshop Part 1

Archived recording of presentation on Feb. 9, 2021

Researchers are dealing with more and more data in their routine work. Although many tools are available, Excel spreadsheets remain an indispensable part of data management. Excel handles a variety of data formats, transforms raw data into other formats for further analysis, and has important features for summarizing and visualizing data. This two-part workshop aims to develop Excel skills. Part 1 of this workshop will demonstrate the Excel features PivotTable and PivotChart. This session will expect that attendees have at least basic familiarity with Excel. The methods of analyzing and visualizing data will be practical for attendees at the beginner or intermediate level. This workshop is open to people of any academic status—graduate, undergraduate, faculty, or staff.

Workshop Agenda

Feb. 9, 2:00–3:30 PM (Pt 1)

PivotTable
- Create a PivotTable
- Formatting
- Sort & Filter
PivotChart
- Create a PivotChart
- Improve data presentation
- Highlight important finding

Mar. 2, 2:00–4:00 PM (Pt 2)

Power Query
- Get Data
- Transform Data
- Import Data
Power Pivot
- Data Model
- Relationship
- Data Analysis Expressions (DAX)

Other Resources

Excel 2019 Bible by Michael Alexander; Richard Kusleika; John Walkenbach
ISBN: 9781119514787
Publication Date: 2018-10-23
The complete guide to Excel 2019 Whether you are just starting out or an Excel novice, the Excel 2019 Bible is your comprehensive, go-to guide for all your Excel 2019 needs. Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities to take full advantage of what the updated version offers. Learn to incorporate templates, implement formulas, create pivot tables, analyze data, and much more. Navigate this powerful tool for business, home management, technical work, and much more with the only resource you need, Excel 2019 Bible. Create functional spreadsheets that work Master formulas, formatting, pivot tables, and more Get acquainted with Excel 2019's new features and tools Whether you need a walkthrough tutorial or an easy-to-navigate desk reference, the Excel 2019 Bible has you covered with complete coverage and clear expert guidance.
Excel Data Analysis for Dummies by Paul McFedries
ISBN: 9781119518167
Publication Date: 2018-11-13
Take Excel to the next level Excel is the world's leading spreadsheet application. It's a key module in Microsoft Office--the number-one productivity suite--and it is the number-one business intelligence tool. An Excel dashboard report is a visual presentation of critical data and uses gauges, maps, charts, sliders, and other graphical elements to present complex data in an easy-to-understand format. Excel Data Analysis For Dummies explains in depth how to use Excel as a tool for analyzing big data sets. In no time, you'll discover how to mine and analyze critical data in order to make more informed business decisions. Work with external databases, PivotTables, and Pivot Charts Use Excel for statistical and financial functions and data sharing Get familiar with Solver Use the Small Business Finance Manager If you're familiar with Excel but lack a background in the technical aspects of data analysis, this user-friendly book makes it easy to start putting it to use for you.
Microsoft Excel 2019 Pivot Table Data Crunching by Bill Jelen ; Michael Alexander
Publication Date: 2019
Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you've never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power–including valuable improvements in Excel 2019 and Excel in Office 365. Drawing on more than 45 combined years of Excel experience, Bill Jelen and Michael Alexander offer practical “recipes” for solving real business problems, help you avoid common mistakes, and present tips and tricks you'll find nowhere else.

Excel Data-wrangling, Analysis, and Visualization Workshop

User Experience Librarian

Web Librarian