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.

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

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

      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