Export

Microsoft Monday: Data Analysis Shortcuts

• Monday, June 13, 2022, 2:00 PM - 4:00 PM

Microsoft Monday: Data Analysis Shortcuts
Monday, June 13, 2pm-4pm
$25 registration fee

Are you looking for a quick answer to a statistical question? If your data is stored on an Excel spreadsheet, there are several techniques you can use to find your answer quickly and without creating complex formulas.

In this virtual training session on Zoom, Delia Hubbard – Digital Literacy Educator and Microsoft office Master, will demonstrate how to take advantage of these data analysis shortcuts.

Participants will learn to:

• Analyze a range of data to determine its sum, average, minimum value, maximum value, or count of values without creating a formula
• Adjust table properties to quickly calculate values without creating a formula
• Use standard and custom sorting rules to help organize data
• Use multi-level data filtering techniques to find specific data

Participants should have basic foundational knowledge of using Excel, including how to select a range of cells on a spreadsheet, move between spreadsheets in a workbook, and how to navigate the Ribbon toolbar.

There is a $25 registration fee per person for this training.

Pre-registration is required: https://cornell.zoom.us/meeting/register/tJUrdOmsrjgtEtUBLzhiKoUPX8v2d-57u87v

Location

This event is online

Last updated April 12, 2022