Excel Advanced Skills

Add to favorites

$79.00

How To Enroll?

Description

This course is designed for the learner who already has a solid understanding of Excel's basic tools and functions. The course teaches learners some of the more advanced skills and features available in Excel, which may be useful in data analysis. These skills include style templates, conditional formatting, data validation, data manipulation, and pivot tables.

Continuing Education Units and Credits

IACET CEUs: .3 | SHRM PDCs: 3

Upon successful completion, learners can download MindEdge continuing education certificates from the classroom. Learners must achieve an average test score of at least 70% to meet the minimum successful completion requirement and qualify to receive IACET CEUs. Learners will have three attempts at all graded assessments.

What You Will Learn

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 data set 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.
Perform partial searches when filtering or analyzing data using wildcard characters.

Eligibility

Must be 18 or older

Refund Policy

You will have seven days, or until you receive your completion certificate, to request a full refund after purchase, whichever comes first. No hidden fees. All books and materials are included with purchase.

Features

Interactive Content

Learn through games, flashcards, and other engaging content

Ask an Expert

Receive answers to your course questions directly from an expert in the field

Flexible Learning

Easily consumable segments to adapt around your busy life

Awards

Certificate of Completion in Advanced Excel Skills

$79.00

How To Enroll?

Add to favorites

How to enroll?

1Add course to cart
2Create your account
3Register for course
4Make payment and submit application
5Start learning

-or-

email [email protected] for additional assistance

Who is this for

Working professionals and anyone looking to improve Excel skills

Things To Know About Walden's Partnership With MindEdge

Founded by Harvard and MIT educators in 1998, MindEdge is a leading online training provider that has served more than three 3 million learners. Walden University’s School of Lifelong Learning is partnering with MindEdge to offer courses in high-demand, focused areas to help learners upskill.

Courses offered in partnership with MindEdge are designed by subject matter experts in the field and reviewed by Walden’s faculty experts to ensure content meets our educational standards and bridges critical skills gaps.

Courses are designed by subject matter experts in the field and reviewed by Walden’s faculty experts to ensure content meets our educational standards and bridges critical skills gaps. After purchasing a course, learners will access the course content in the Walden learning environment and will be supported by MindEdge’s experts and Walden’s staff. You can always contact [email protected] for additional assistance.

You will earn a certificate of completion in your classroom after completion of each course’s required criteria. Most courses offer continuing education units (e.g., CEU, PDU, SHRM, HRCI, CFRE, ISC2). Once you have successfully completed and passed your course, you will have access to the continuing education certificate(s) offered.

You will have seven days, or until you receive your completion certificate, to request a full refund after purchase, whichever comes first. There are no hidden fees, and all books and materials are included with purchase. If you have any questions or would like to request a refund, contact us at [email protected].