Home Link

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.

Quest Grant

Learn for free and earn certificates with QUEST!

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!

On-Demand 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

Browse current job openings from local employers

Events

Loading upcoming events...

On-Demand Training

On-Demand Course Options

See and compare the different course bundles and trainings available through the BWS

On-Demand Industry Training

On-demand courses tailored to the fastest growing industries in Yavapai County

Leadership Ladder Course Bundles

Course bundles that teach technical and soft skills to current and future leaders

A la carte Courses

Choose your own individual courses.

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

      Home LinkThe BWS is a Division of Yavapai College.Go to yc.edu

      Sign up for the BWS Newsletter

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