Introduction to Data Analysis Using Excel

Get experience with Microsoft Excel for use in your projects, theses or on the job. In this video, data librarian Daria Orlowska gives step-by-step instructions for combining, organizing and analyzing data using Excel. Learn how to navigate and use formulas, critically examine datasets for bias and limitations, and discover how secondary data can be leveraged for research projects.

0:00:00 Welcome
0:04:16 Workshop goals
0:08:34 Defining project needs
0:21:46 Downloading datasets
0:22:47 Renaming spreadsheets
0:24:57 Renaming sheets
0:26:42 Built-in Sum function
0:29:10 AutoSum function
0:37:12 Conditional formatting numbers
0:38:32 Sorting on conditional formatting
0:41:11 Conditional formatting texts
0:43:17 CSVs and formatting
0:46:10 COUNTIF formula explanation
0:48:25 COUNTIF formula demonstration
0:48:27 Applying formula down range
0:53:24 Using wildcards for fuzzy search
0:56:04 IF formula explanation
0:57:47 IF formula demonstration
1:00:40 Sorting on formulas
1:02:24 Documenting formulas
1:06:12 Summing within a range
1:07:45 Setting up analysis in separate sheet
1:09:46 COUNTIFS formula explanation
1:13:14 COUNTIFS demonstration
1:18:54 Toggling formula view in cell
1:19:21 Moving reference explanation
1:21:14 Locking reference for column headers explanation
1:22:22 Locking reference for row headers explanation
1:23:02 Toggling formula view in cell revisit
1:23:45 Locking table reference in table recap
1:25:07 Locking data reference explanation
1:26:34 Locking references demonstration
1:28:29 Applying revised formula
1:31:22 Identifying missing data
1:32:25 Changing formula to only look at date
1:33:37 Changing formula to look at presence information
1:35:41 Pivot table demonstration
1:40:47 Contemporary dataset cleaning needs recap
1:41:54 Adding missing year to date
1:47:39 Text to column by delimiter
1:51:25 End result discussion
1:54:49 Thank you

Learn more about Data Services at Western Michigan University Libraries: https://wmich.edu/library/data-services

This video is a recording of an online workshop presented on July 11, 2023.