Home Link
Quest Grant

For Businesses

Business Services

Helping the Businesses in our Community.

Regional Services

Everything you need to know to grow in Yavapai County.

Grant Assistance

From grant research to writing services.

Data and Analytics

Research for sustainable business growth.

About Yavapai County

Everything you need to know about commerce Yavapai County.

For Employees & Job Seekers

Career Resources

Personalized training, career counseling, scholarships, and more!

Training Courses

Learn new skills and get ready for your next career move.

Job Fairs and Events

Connect with employers through local job fairs and career events.

Hot Jobs

Top Jobs, Occupations, and Skills in Yavapai County

Job Postings Data Trends

Explore the latest data on job opportunities available from local employers

Events

Loading upcoming events...

Training Courses

Training Course Options

See and compare the different course trainings available through the REDC.

Subject Matter Expert

Train employees and businesses in leadership, professional development, communication, and more

Back to all courses

Excel Advanced Skills

$79
Self-Paced3 Course Hours | 12 Weeks
View Course
Computer Applications
Excel Advanced Skills

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.

credits

  • IACET CEUs: 0.3
    • SHRM PDCs: 3

      features

      • Mobile-friendly
      • Audio-enabled
      • Badge and credit-awarding
      • Fully accessible
      • Games & Flashcards
      • Expert-supported
      • Video content

      learning 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 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

      related courses

      • Computer Applications
        Excel Basics

        Excel Basics

        Self-Paced3 Course Hours | 12 Weeks
        $79
      • Computer Applications
        Excel Tips & Tricks

        Excel Tips & Tricks

        Self-Paced3 Course Hours | 12 Weeks
        $79
      • Computer Applications
        Google Drive Basics

        Google Drive Basics

        Self-Paced1.5 Course Hours | 12 Weeks
        $39
      Home LinkThe REDC is a Division of Yavapai College.Go to yc.edu

      Sign up for the REDC Newsletter

      Stay in touch with the REDC and learn how we are impacting our community!
      Contact Us