Professional & Continuing Studies

Two hands on laptop with Excel table on screen and cup of coffee to the right

Customizing spreadsheets for detailed analysis

Learn More about UD PCS Virtual Info Sessions

  • Enhance your existing Excel skills
  • Learn to work with complex datasets
  • Four-week live-online course — October 13-November 10 REGISTER NOW
  • Discounts available
  • LEARN MOREview info session presentationlaptop icon

This course introduces advanced concepts in customizing spreadsheets for analysis and requires a foundational understanding of working with datasets in Microsoft® Excel. Topics covered include customizing the ribbon, conditional formatting, data validation, the 10 most important functions used in the workplace, nested IF statements, macros, creating user forms, advanced charting, pivot tables and pivot charts, and the Analysis ToolPak. Students will work independently on exercises and short quizzes throughout the course.

Save $310 by registering for all three of our Microsoft® Excel courses in a single transaction. Offered at a bundled rate of $1,175, this equates to more than a 20% discount versus registering for each course individually.

Program details

Register Now buttonMicrosoft® Excel Advanced Concepts – Noncredit Course
LOCATION: Live-Online
SCHEDULE: October 13-November 10, 2022 — Thursdays, 6-9 p.m.
PRICE: $495, course manual included. Potential discounts available, including: Elevate Delaware funding, Early registration, Military, UD student or alum, 2 or more (group).
CEUs: 1.5 (15 contact hours)

Who should participate in this program?

  • Students, recent graduates and other job seekers with Excel skills who wish to learn advanced Excel concepts

[back to top]

Learner outcomes

  • Gain the skill set needed to work with complex datasets using advanced functions and formulas in Excel.
  • Acquire an understanding of how to present data insights using advanced charting techniques.
  • Learn how to set up forms for collaborative projects in the workplace.
  • Prepare interactive pivot tables for distribution on a professional level.
  • Learn the 10 most important functions used in the workplace
    • Concatenate, Substitute
    • Len, Trim
    • Cell, Left, Mid, Right
    • Upper, Lower, Proper
    • Min/Max
    • Vlookup/Hlookup
    • Index/Match
    • Round, Roundup, Rounddown
    • Convert, Value, Text
    • Flash Fill, Auto Fill

[back to top]

Technology requirements

  • Please bring your laptop with Microsoft® Excel 365, or a previous version, and a charger to class.

[back to top]


For more information

[back to top]


Power Up Your Career free online seminars

Button. Power Up Your Career. Career and personal strategies. Free online seminars.Fall 2022 — “Industry Insights” series

  • Hear from industry insiders about their field
  • Industries represented — Healthcare | Legal | Fintech (financial technology)
  • Networking, live-online Q&A
  • Learn more or RSVP now!

[back to top]

Live Chat

Help Desk Software