BRWN-00216 - Leverage the Power of Excel for Basic Data Management and Analysis
Preferred registration deadline: February 13th
3 CEs
This is an in-person workshop that will be held on Washington University’s Danforth Campus. The exact location and direction will be emailed to registered participants before the course date. A computer or laptop equipped with Excel 2016 or later is required.
General Admission: $65**
**Eligible discounts can be applied during checkout.
Class size is limited to 30.
Course Outline
Content Level: Beginner
Target Audiences: This workshop is ideal for beginners looking to build a solid foundation in Microsoft Excel. It is suitable for individuals involved in entry-level data management and data analysis in their daily work, or those looking to gain experience in these areas. Participants may include students, academic professionals, and staff working in non-profits, government, foundations, or administrative and office settings.
Agenda:
- Section 1: Data Management - 50 mins
- Introduction and Overview
- Workbook Basics
- Data Management Best Practices
- Dataset Fundamentals
- Section 2: Data Exploration and Cleaning - 60 mins
- Data Cleaning Tools
- Exploring Data with Formatting
- Creating and Utilizing Tables
- Section 3: Excel Functions for Data Analysis - 70 minutes
- Data Analysis Using Excel Functions
- Common Analysis Functions
Learner Outcomes
- Apply basic principles and best practices of data management and data entry.
- Use Excel formulas and functions for basic analysis.
Course Completion Requirements:
The Brown School is an approved provider of Social Work CEs in Missouri and Illinois. To earn credit, attendees must arrive at the scheduled time, attend the entire course, and complete an online course evaluation. You may still qualify for partial Social Work Missouri and Illinois CEs if you miss part of the training. CE Certificates will be available online within 10 business days of course completion by visiting your learner profile at https://ce.wustl.edu/portal/logon.do?method=load&parentSite=brown. You will receive an email notification with specific instructions for accessing the online certificate when it is available.
For more information about CEs, accessibility, refund/cancellation policy, our grievance policy, or other inquiries, please visit our About Us page or email brownprofdev@wustl.edu.