Join in as our AVA Guides teach you:

Excel Advanced Skills

Sign Up

Starting at £10/month (billed annually) for all classes and sessions

Key Takeaways:

  • Employ built-in cell style templates, or produce a custom one, to streamline the data entry process
  • Organize worksheet data using the Group Function
  • Create a drop-down list to restrict data entry values


Skills You’ll Gain:

  • Group Function
  • Consolidation Function
  • Transpose Function
  • Pivot Tables
  • Advanced Filter Tool


Class Info:

Class Overview:

enroll for this Microsoft Word basics class on AVA. We help adults, 50 years and above learn new skills with their peers. We want to help adults become more skilled as they age. Start here today; friendlyava.com

This class 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.

Instructor(s): AVA Guides

Class Length: 1 hour (multiple classes)

Category: Arts & Entertainment, Writing

What’s in every AVA membership?

Sign Up
Gift
  • All 180+ live classes going on every day
  • Live-video-only lessons
  • Downloadable class guides for every class
  • Watch on desktop, TV, or mobile devices
  • New classes added every month


Common Questions

AVA is the live-learning platform that makes it possible for adults, 50+, to learn new skills, stay active with their peers.

Whether it be in digital skills, business and leadership, photography, cooking, writing, acting, music, sports and more, AVA delivers a world class online learning experience for adults. Classes are available anytime, anywhere on your smartphone, personal computer; all you have to do is book the time you'd like to take the class.

Membership includes access to an incredible catalog of 50+ classes taught by empathetic instructors called AVA Guides on digital skills, cooking, leadership, photography, writing and more.

Each class is hosted live and last about 4 5minutes to 1 hour.

With AVA, you can learn and be inspired anytime, anywhere, including your smartphone, personal computer. Just Login to your account and book the classes at the available times.

AVA offers 180+ classes across a variety of categories, including digital skills, business and leadership, photography, cooking, writing, acting, music, sports and more. Every class has been designed to be accessible for people with little to no experience and advanced students alike. With new classes launching regulary, you can learn practical skills, ignite new passions, and get everyday wisdom.