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 Tips & Tricks

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

Description

This course features 25 of the most popular Excel tip and tricks for both novice and advanced Excel users. In this course, you will learn time-saving techniques to boost efficiency, increase productivity and workflow, and improve and advance your skills. Topics include data entry, data organization, data cleaning, elements of style, data sorting, data filtering, and spreadsheet display tips. This course also covers three of the most popular lookup and reference functions: VLOOKUP, HLOOKUP, and Find + Replace. To follow along with the content and activities in this course, you will need access to Microsoft Excel. This course features Excel 2019, which may differ from other versions of Excel.

credits

  • IACET CEUs: 0.3
    • SHRM PDCs: 3

      features

      • Mobile-friendly
      • Audio-enabled
      • Fully accessible
      • Games & Flashcards
      • Expert-supported
      • Video content

      learning Outcomes

      • Employ copy and paste shortcuts
      • Arrange, filter, and sort data by text, color, and by custom criterions
      • Modify the worksheet view with various display tools, such as Freeze Panes, Hide/Unhide, Text-To Column, and Zoom In/Out
      • Understand and apply data organization tools and functions
      • Retrieve data using VLOOKUP, HLOOKUP, and Find + Replace
      • Apply patterns, gradients, cell borders, and other style elements to data
      • Experiment with the Quick Analysis Tools to create charts, graphs, and calculations
      • Make use of the lock/unlock and track changes features

      related courses

      • Computer Applications
        Excel Advanced Skills

        Excel Advanced Skills

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

        Excel Basics

        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