• Skip to primary navigation
  • Skip to main content
  • Skip to footer
NCTI logo image

NCTI

Train up

  • Content Solutions
    • NCTI Courses
      • All Technical
        • 5G & Wireless
      • Customer Care
      • Leadership
      • General Education
    • Custom Content
    • Learning Delivery
  • Certifications
    • Master Technician
    • Master Representative
    • Emerging Leader
    • Master Dispatcher
    • Telecom Specialist
  • College Program
    • Broadband Technology
    • Customer Care
    • Broadband Leadership
  • Hall of Fame
  • About
    • Our Team
    • News & Announcements
  • Support
    • Contact
    • FAQs
    • Resources
  • Login

Excel Advanced Skills

Delivery: Online

Estimated Length: 3 seat hours

Price: $95.00

 
Add to My Account    Create New Account
 
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.

Completion Time:

The estimated completion time for this course is three hours. The maximum allotted time is four months from enrollment.

Benefits:

  • receive a MindEdge certificate of graduation

Upon completing this course, students will be able to:

  1. employ built-in cell style templates, or produce a custom one, to streamline the data entry process
  2. create a drop-down list to restrict data entry values
  3. utilize the Conditional formatting feature to apply formats to a cell or a range of cells based on specific criteria
  4. organize worksheet data using the Group Function
  5. use the Consolidation Function to combine data from several worksheets into one
  6. differentiate between and discern when to use a relative or an absolute reference in a formula
  7. change the orientation of an array of data using the Transpose function
  8. use the Advanced filter Extract data from a data set based on complex criteria using the Advanced Filter tool
  9. analyze data using Pivot Tables
  10. calculate data across several worksheets with the same structure using a 3D reference
  11. perform partial searches when filtering or analyzing data using wildcard characters

Footer

Follow Us on Social Media!

  • Email
  • Facebook
  • LinkedIn
  • Twitter
  • YouTube

Can’t Find It?

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors

NCTI logo image

 

©2024 Jones/NCTI®, Inc.
All rights reserved.

Terms of Use | Privacy Policy

 

7807 E. Peakview Ave.

Ste. 450

Centennial, CO 80111 USA