Customizing spreadsheets for detailed analysis
Enhance your existing Excel skills- Learn to work with complex datasets
- Four-week live-online course — October 7-28 — REGISTER NOW
- Discounts, scholarships available
- LEARN MORE —View our fall 2021 information session recording
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.
Program details
Microsoft® Excel Advanced Concepts – Noncredit Course
LOCATION: Live-Online
SCHEDULE: October 7-28, 2021 — Thursdays, 6-9 p.m.
PRICE: $475, course manual included. Scholarships and potential discounts available, including: Early registration, Military, UD student or alum, 2 or more (group).
CEUs: 1.2 (12 contact hours)
- Who should participate in this program
- Learner outcomes
- Technology requirements
- For more information
Who should participate in this program?
- Students, recent graduates and other job seekers with Excel skills who wish to learn advanced Excel concepts
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
Technology requirements
- Please bring your laptop with Microsoft® Excel 2016 or newer and charger to class.
>> REGISTER NOW! <<
For more information
>> REGISTER NOW! <<
Power Up Your Career—free online seminars
Post pandemic — retooling during a time of change
TOPICS INCLUDE:
- Developing a positive mindset for returning to the office
- Networking communication skills to enhance your career
- Preparing yourself with the most valued skill sets in the marketplace
- Taking the leap: Is entrepreneurship for you?
- Learn more or RSVP now!
