Intermediate Excel
| Course code: | 26-SS-222 |
|---|---|
| Dates: | March 2-27, 2026 Alternate Course Dates |
| Location: | Online |
| Instructor: | Amy Klous |
| Fee: | $195.00 |
Description
Learn how to use tables, formulas, and popular functions to streamline your work. Improve spreadsheet appearance with formatting and templates, and discover how tools like data validation and pivot tables can help you analyze large datasets with ease. You’ll also explore lookup functions, date and time formulas, and Excel customization options that can improve your workflow.
Course Outcomes
- Create and format tables using styles, formulas, and filtering/sorting tools to organize and display data.
- Apply popular Excel functions for business use, including lookup, text, and date/time functions.
- Use named ranges to simplify formulas and improve worksheet navigation.
- Improve spreadsheet appearance through cell formatting, templates, and toolbar customization.
- Identify and correct common function errors for more accurate results.
- Analyze data using pivot tables, including creating basic layouts and applying formatting.
- Utilize data validation tools and the text-to-columns feature to clean and manage data effectively.
- Professionals who already use Excel and want to increase their productivity and data skills
- Administrative and operations staff who manage reports, data entry, or tracking
- Small business owners and entrepreneurs looking to enhance their reporting and analysis capabilities
- Students or job seekers who want to stand out with in-demand Excel skills
- Anyone familiar with Excel basics who wants to expand into functions, formatting, and pivot tables
Notes
Registration Deadline: Participants can register up to 5 days after the course begins.Course Access: Offered in partnership with LERN. Log in 24/7—no live meetings.
Course Format: Weekly units include readings, audio-slide lectures, self-quizzes, and discussion forums.
Tips for Success: Log in 2–3 times a week and contribute 2–3 thoughtful posts per unit for the best experience.
Recognized Credentials: Earn nationally recognized CEUs from the Learning Resources Network (LERN), a 501(c)(3) nonprofit association—perfect for meeting professional development goals or licensure requirements.
Cancellation/Refund Policy: VCU Continuing and Professional Education offers this class/certificate in partnership with LERN. Therefore, you may cancel your registration up until you receive your login and password from LERN 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 cancelled 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.
Online courses offered with the Learning Resources Network (LERN) continue to run, as scheduled during inclement weather. If there are changes to meeting status, you will receive an email at the address you provided upon registration informing you of the cancelation.
*exempt-this offering is ineligible for waiver use
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.
