⌘KCtrl KCourses Paths Pricing

Courses Paths Pricing

Microsoft Excel

Dates, dynamic arrays & Power Query

Dynamic arrays: FILTER, UNIQUE and SORT

Learn Microsoft 365, Google Workspace, Windows and macOS by doing, then prove it with a certificate.

Learn

Microsoft 365 apps
Microsoft 365 administration
Google Workspace
Windows & macOS

ClickDojo

Pricing
For teams
Account
Support
Terms
Privacy

© ClickDojo. ClickDojo is an independent training service and is not affiliated with, endorsed or sponsored by Microsoft, Google or Apple. Microsoft, Microsoft 365, Windows and the names of Microsoft products are trademarks of the Microsoft group of companies. Google, Google Workspace and the names of Google products are trademarks of Google LLC. Apple, Mac and macOS are trademarks of Apple Inc. Practice simulators are simplified illustrations. Certificates attest to completion of ClickDojo courses and exams; they are not vendor certifications.

⌘KCtrl KCourses Paths Pricing Log inStart free

Courses Paths Pricing Log in

Microsoft Excel

Dates, dynamic arrays & Power Query · Pro lesson

Dynamic arrays: FILTER, UNIQUE and SORT

One formula that spills a whole list of results in Microsoft 365.

5 quick checks
1 put-in-order task
1 formula challenge
About 5 minutes

Unlock with Pro, from $3.33/month

Already subscribed? Log in

Not ready? Try the free Basics lessons in Microsoft Excel