E-Learning Library  *  Virtual Classrooms  *  Face 2 Face Workshops  *  Online Shop

Microsoft Excel - VSTACK Function

DID YOU KNOW ... VSTACK is one of Microsoft new Dynamic Array functions available to those using Microsoft 365 that creates one live, combined list from multiple ranges, updating automatically whenever the source data changes?

 

VSTACK is great because it lets you combine several tables into one dynamic list that updates automatically, works seamlessly with functions like SORT, FILTER, and UNIQUE to build automated reports, and can still merge data even when the ranges don’t match in size, making it flexible for real‑world, imperfect datasets.



Click here to learn more now!

 

Inspire Confidence. Drive Performance. Unlock Potential

Whether it's flexible eLearning or instructor-led virtual training, Bite Size Online Learning Solutions deliver learning that can really make a difference. Our programmes are designed to build confidence, strengthen capabilities and drive real productivity gains across your business. Take a look at Bite Size and invest in training that delivers impact.

eLearning - Self-paced Learning Library

We Deliver : Try our Three Month Summer Taster - start anytime


Our Bite Size eLearning Library is packed with thousands of 3-5 minute lessons for Microsoft 365, Copilot, Teams, SharePoint, Excel, Outlook, PowerPoint, and lots more, including knowledge tests and games. Give us a try! Support your staff and take their skills from Introduction to Expert Level with our Summer Three Month Taster

You Deliver : Maximise your LMS Investment - launch our courses


If you’ve invested in an LMS, now’s the perfect time to unlock its full potential. Upload our SCORM‑compliant, easy to follow Microsoft 365 eLearning courses, tests and games - created by our Microsoft Office trainers - all delivered within your own learning system. Prefer us to host instead? No problem. Just give us a call. Find out more

Virtual Classes - Instructor-led via Microsoft Teams

Unlock the Power of Copilot and 

transform the way you work


Work faster, smarter and with more confidence with Microsoft 365 and Copilot. Whether it's a Full Day Copilot Introduction Course or a half day Driving Efficiencies or Copilot Chat Workshop, these tutor-led courses will give the practical skills to turn everyday tasks into business results. Find out more

Power BI Courses - Introduction to Advanced - in 3 easy steps


Join us for hands‑on sessions where we guide you step‑by‑step from the fundamentals of Power BI right through to advanced analytics. You’ll gain practical experience, confidence, and the expertise you need to create powerful, insightful dashboards and analytics that truly stand out. Find out more

 

Discover the Power of Power Query

Virtual Workshop - spaces available - Thursday 6 August - 1:30pm – 4:30pm

Are you spending too much time cleaning, reformatting, and manually fixing data in Excel week after week - repeating the same actions? If so, Power Query could transform the way you work. Learn how to create a reusable query that does the hard work for you - saving time, improving consistency and reducing the risk of errors. Our virtual workshops are a perfect way to see what Power Query can do, and learn how to automate repetitive data prep tasks with a few clicks.


Take a look at our workshops and see why so many Excel users are making Power Query part of their daily toolkit. Find out more.

Lead the Way. Work Smarter. Boost Confidence

The digital workplace is moving fast. From new productivity tools to smarter ways of working, we enable organisations to unlock the full value of Microsoft 365 - boosting efficiency and confidence. We are passionate about what we do and helping teams to work smarter in a changing world. Get in touch for an informal chat today.

Facebook  LinkedIn  X

Why not forward this newsletter to a friend or colleague. They can sign up for our free weekly tips here

Learning Solutions for Business | Shop Now for Individuals | Contact Us

You are receiving this newsletter because you requested our Tip of the Week or are a Member of our Bite Size Lesson Library. Our Weekly Tips are FREE and provide useful hints and tips on how to get the most out of your computer. You can manage your preferences at any time by using the update profile or safe unsubscribe links below.