Data Analysis with Excel
| Course code: | 27-SS-148 |
|---|---|
| Dates: | September 23, 2026 Alternate Course Dates |
| Meets: | W from 9:00 AM to 4:00 PM |
| Hours: | 6.00 |
| Location: | VCU Academic Learning Commons 4110 |
| Instructor: | Rosemary McCracken |
| Fee: | $275.00 |
Description
In today’s data-driven workplace, the ability to analyze and interpret data is essential for informed decision-making. This course builds advanced Excel skills for professionals who need to manage, analyze, and report on data with greater accuracy and efficiency.
Through hands-on exercises and real-world applications, participants will work with complex datasets, apply advanced formulas, and create dynamic reports. The course focuses on practical techniques that can be immediately applied to streamline workflows, improve data accuracy, and enhance reporting.
Key Topics- Exploring advanced Excel formulas and functions, including text, date, lookup, and IF functions
- Examining tools for summarizing and visualizing data, including PivotTables and PivotCharts
- Reviewing methods for cleaning, structuring, and preparing datasets for analysis
- Introducing tools and techniques that support workflow efficiency
Learning Outcomes
By the end of this course, participants will be able to:
- Apply shortcuts for navigating and selecting cells
- Apply advanced formulas to analyze datasets and reduce manual calculations
- Build PivotTables and PivotCharts to identify trends and improve reporting accuracy
- Utilize Excel functions to clean and transform data
- Highlight key insights using conditional formatting to support faster decision-making
Who Should Enroll
This course is ideal for individuals who work with data, have foundational Excel experience, and are ready to strengthen their skills in data analysis and reporting.
- Business professionals, analysts, and administrative staff responsible for reporting and data management
- Individuals looking to improve efficiency, reduce manual data tasks, and better analyze and communicate insights
Digital Badge
Participants who successfully complete this course will have the opportunity to earn a digital badge that can be shared on LinkedIn and other professional platforms. To earn the badge, participants must attend the full session, actively participate, and successfully complete a course-based activity demonstrating application of key concepts.
Notes
Registration Deadline: Early Registration ends August 26, 2026. Registrations will be accepted through September 21, 2026Cancellation/Refund Policy: You may cancel your registration up until 7 days prior to the course start date (or specific date inserted), and receive a full refund minus any credit card processing fees. Cancellations must be received via email at ocpe@vcu.edu
In the unlikely event that this program is canceled or postponed due to insufficient enrollments or unforeseen circumstances, the university will fully refund registration fees, but cannot be held responsible for any other expenses, including change or cancellation charges to include but not limited to airlines, hotels, travel agencies, or other organizations.
Student/Participant Conduct:
Participants are subject to all university policies applicable to students, unless a specific university or VCU Continuing and Professional Education policy explicitly states otherwise. University policies governing students are available at https://vcu.public.doctract.com including:
Student Code of Conduct
Honor System and Standards of Academic Conduct
Preventing and Responding to Discrimination
Title IX Sexual Harassment Policy-Interim
Sex-Based Misconduct Policy-Interim
For Academic Accommodations, please visit https://ocpe.vcu.edu/courses/policies.html#accommodations
There are still openings remaining at this time.
