Advanced Filtering Using Functions: Beginners’ Tutorial (DSUM, DCOUNT and other D functions)
In this beginners’ tutorial we learn all the basics of using the DSUM, DCOUNT, DCOUNTA, DAVERAGE, DMIN and DMAX functions to filter complex datasets in a much more dynamic way. This is a great tool for creating dashboards to summarise your data quickly in different ways. Learn this great filtering option in this easy-to-follow beginner-friendly tutorial.
You can also download the file from our Google Drive: https://drive.google.com/file/d/1xECD...
0:00 Introduction
0:40 Filtering a table - reminder
1:53 DSUM
3:10 Inputting criteria
4:58 DCOUNT
5:49 DCOUNTA
6:11 DAVERAGE
6:30 Using MATCH function with D functions
8:14 DMIN and DMAX
Learn Excel online for free: Our Excel for beginners tutorial will teach you all you need to know to take you from zero to Excel hero! What Microsoft Excel tips and tricks do you want to learn? Let me know for future videos! I'll continue to develop tutorials covering Excel basics for beginners and will build up a catalogue of free Microsoft Excel course materials! :-)
Check out our other playlists, such our playlist covering INDEX, MATCH and variations on IF: • FREE Excel course for beginners: Week...
Or check out videos on INDEX and MATCH:
INDEX function: • INDEX tutorial: Learn all you need to...
MATCH function: • MATCH tutorial: Learn all you need to...
Using INDEX and MATCH together: • Using INDEX and MATCH together to loo...
INDEX and MATCH functions to lookup data from multiple tables: • Excel for beginners: INDEX and MATCH ...
