Exploring Excel

Jul 24, 2023 09:00 AM to 04:00 PM
Online

Registration Deadline: Jul 21, 2023 01:00 PM

In this hands-on Excel workshop, you'll learn how to navigate a spreadsheet, explore a dataset, and format it for readability. You'll then develop intermediate Excel skills such as using formulas and creating well-labeled charts. The day will wrap up with expert tips and tricks on preparing files, spreadsheets, and data to overcome some of the difficulties of working with Excel. 

Basic Excel (Morning)
Skills developed in this session:
·      Navigating and Selection
·      Formatting Cells
·      Conditional Formatting
·      Sorting
·      Filtering
·      Printing
 
Intermediate Excel (Afternoon)
Skills developed in this session:
·      Inserting formulas
·      Copying, pasting, and dragging formulas
·      Using relative and absolute cell addresses
·      Removing duplicates
·      Vlookups
 
Easing into Excellent Excel Practice
This session covers some tips and tricks on how to prepare files, spreadsheets, and data for working in Excel. If you're using Excel for data analysis in courses or in your research projects, this session will save you from some major headaches!  
Attendees will receive handouts and sample files created and openly licensed by Julie Marcoux, Dalhousie Data Librarian.

Technology notes:
This session is taught using Microsoft Excel 365 (available to staff, students, and faculty) on a Mac. I'll cover differences between Mac and Windows shortcuts. An extended keyboard (includes home, end, and arrow keys) is useful for some shortcuts.