Master a versatile spreadsheet application

• Understand the basics of Microsoft Excel, including data entry, basic formulas and formatting
• Learn advanced features such as conditional formatting, data validation and pivot tables to enhance your data analysis
• Discover popular tips and tricks to boost your efficiency
• Learn to create detailed and visually appealing reports
• Develop the ability to organize and manage large sets of data effectively
• Participate in online classes anywhere, anytime
• Discounts available
• For more information 

Unlock the full potential of Microsoft Excel with our comprehensive suite of courses designed to cater to all skill levels. Whether you’re managing data, analyzing trends or automating tasks, Excel can significantly enhance productivity and efficiency.

These courses provide a comprehensive learning path to master Excel and leverage its power to drive business operations and strategies.

Courses

• Microsoft® Excel Basics
• Microsoft® Excel Advanced Skills
• Microsoft® Excel Tips and Tricks

[back to top]

Microsoft® Excel Basics
LOCATION: Online
ESTIMATED LENGTH: 3 hours
ACCESS TIME: 90 days
PRICE: $119, MS Excel software not included. Potential discounts available, including: Military, UD student/alum/employee, 2 or more (group).
0.3 CEUs | 3 PDUs | 3 PCSs

Begin your journey with the foundational skills needed to navigate and utilize Excel effectively. Learn essential functions such as data entry, basic formulas and formatting to create and manage spreadsheets with ease.

LEARNER OUTCOMES

• Identify and understand the different components of the Excel interface.
• Enter and convert numerical and text data, dates and times.
• Select, copy and paste data in a workbook.
• Employ elements of style to the workbook.
• Create images, illustrations, shapes and hyperlinks in a worksheet.
• Arrange, filter and sort lists of data.
• Apply basic formatting elements to the worksheet.
• Formulate basic mathematical formulas and functions, including SUM​, AVERAGE and MAX and MIN VALUE.
• Reorganize data by removing duplicates, blanks spaces and misspellings in a worksheet.
• Open, save and protect the workbook.

NOTES

• This course has an “Ask the Expert” feature, which submits your questions directly to an expert in the field you are studying. Questions are answered as quickly as possible and usually within 24 hours.
• Students must achieve an average test score of at least 70% to meet the minimum successful completion requirement and qualify to receive International Association of Continuing Education and Training (IACET​) CEUs. Learners will have three attempts at all graded assessments.

[back to top]

Microsoft® Excel Advanced Skills
LOCATION: Online
ESTIMATED LENGTH: 3 hours
ACCESS TIME: 90 days
PRICE: $119, MS Excel software not included. Potential discounts available, including: Military, UD student or alum, 2 or more (group).
0.3 CEUs | 3 PDCs

Elevate your proficiency by diving into advanced features like conditional formatting, data validation and pivot tables. This course is perfect for those who want to enhance their data analysis capabilities and streamline their workflow. Skills covered include style templates, conditional formatting, data validation, data manipulation and pivot tables.

LEARNER OUTCOMES

• Employ built-in cell style templates, or produce a custom one, to streamline the data entry process.
• Create a drop-down list to restrict data entry values.
• Utilize the Conditional formatting feature to apply formats to a cell or a range of cells based on specific criteria.
• Organize worksheet data using the Group Function.
• Use the Consolidation Function to combine data from several worksheets into one.
• Differentiate between and discern when to use a relative or an absolute reference in a formula.
• Change the orientation of an array of data using the Transpose function.
• Use the Advanced filter Extract data from a dataset based on complex criteria using the Advanced Filter tool.
• Analyze data using Pivot Tables.
• Calculate data across several worksheets with the same structure using a 3D reference.

NOTES

• This course has an “Ask the Expert” feature, which submits your questions directly to an expert in the field you are studying. Questions are answered as quickly as possible and usually within 24 hours.