Excel Advanced Skills

MIND1500 - Excel Advanced Skills

Learning Path | Continuing Education Units | Estimated 3-Hour Workload

In Collaboration with Mindedge Logo
Availability:
  • In Stock
  • feature icon Professional Development
  • feature icon All Level
  • feature icon Continuing Education Units
  • feature icon Estimated 3-Hour Workload
  • feature icon Self-Paced
  • feature icon Accessible for 180 days

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 to request a full refund after purchase. No hidden fees. All books and materials are included with purchase.

Features

Interactive Content

Interactive Content

Learn through games, flashcards, and other engaging content

Ask an Expert

Ask an Expert

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

Flexible Learning

Flexible Learning

Easily consumable segments to adapt around your busy life

Awards

Certificate of Completion

Certificate of Completion in Advanced Excel Skills

Availability:
  • In Stock
  • feature icon Professional Development
  • feature icon All Level
  • feature icon Continuing Education Units
  • feature icon Estimated 3-Hour Workload
  • feature icon Self-Paced
  • feature icon Accessible for 180 days

How to enroll?

  • 1Add course to cart
  • 2Create your account
  • 3Register for course
  • 4Make payment and submit application
  • 5Start learning
-or-
email lifelonglearning@mail.waldenu.edu 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 lifelonglearning@mail.waldenu.edu 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 calendar days to request a full refund after your date of purchase. 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 please contact lifelonglearning@mail.waldenu.edu.