BRWN-00216 - Leverage the Power of Excel for Basic Data Management and Analysis
Preferred registration deadline: August 8th
3 CEs/CPH units
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.
For continued learning, we recommend also registering for the following workshop on Sept 19th: Optimize Reporting with Excel: Data Models and Dashboards.
General Admission: $65**
**Eligible discounts can be applied during checkout.
Class size is limited to 30.
Course Outline
Content Level: Beginner
Target Audiences:
Agenda:
- Section 1: Data Management - 45 minutes
- Introduction and Overview
- Workbook Basics
- Data Management Best Practices
- Dataset Fundamentals
- Section 2: Analysis and Advanced Techniques - 70 minutes
- Data Analysis Using Excel Functions
- PivotTables
- Advanced functions
- Ensuring Data Integrity
- Section 3: Data Exploration and Cleaning - 55 minutes
- Data Cleaning Tools
- Exploring Data with Formatting
- Creating and Utilizing Tables
*Two 5-minute break will occur during the workshop.
Learner Outcomes
- Apply basic principles and best practices of data management and data entry
- Apply tools to explore and prepare data for analysis
- Summarize and analyze data using PivotTables and basic functions
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/cancelation policy, our grievance policy or other inquiries please visit our About Us page or email brownprofdev@wustl.edu.