Uploaded March 2023 | Updated November 2026, 1 day ago
Impress your boss or colleagues with an interactive and dynamic to-do list in Excel. In this simple to follow tutorial, learn how to set up a to-do list for your projects or tasks.
π» DOWNLOAD THE TO-DO LIST Template π
====================================
Visit chandoo.org/wp/beautiful-to-do-list-excel-template
to download the Excel workbook demoed in this video. You will also find some instructions on that page.
β± IN THIS VIDEO
==============
0:00 - Beautiful To-do list Excel - Quick Demo
0:21 - Data set-up for the to-do list
1:42 - Creating the Visual To-do list Layout
3:34 - The formulas needed for showing ongoing to-do activities
6:00 - Linking the formulas to the output to-do list & Formatting
π§° MORE EXCEL TOOLS for your WORK
================================
π Make a beautiful & elegant tracker with Excel - youtu.be/e0s9xdx5FF8
π― Create an interactive Risk Map with Excel - youtu.be/N8J-t9JxQbA
π² Set up a dynamic Project Plan (Gantt Chart) with Excel - youtu.be/W7NVKjg56ZY
π©βπ» Another beautiful Project Gantt Chart with Excel - youtu.be/FXnyKU6xZeI
π Build a perpetual Calendar & Appointment Tracker with Excel - youtu.be/70ncIeJEDRY
π Embed Excel Workbooks on your Website - youtu.be/5ViZ7aOxF3I
π Amazing distance calculator using Excel - youtu.be/RU9D-CyKwEQ
~
#Excel #todolist
Have a beautiful day πππΌ
Impress your boss or colleagues with an interactive and dynamic to-do list in Excel. In this simple to follow tutorial, learn how to set up a to-do list for your projects or tasks.
π» DOWNLOAD THE TO-DO LIST Template π
====================================
Visit chandoo.org/wp/beautiful-to-do-list-excel-template
to download the Excel workbook demoed in this video. You will also find some instructions on that page.
β± IN THIS VIDEO
==============
0:00 - Beautiful To-do list Excel - Quick Demo
0:21 - Data set-up for the to-do list
1:42 - Creating the Visual To-do list Layout
3:34 - The formulas needed for showing ongoing to-do activities
6:00 - Linking the formulas to the output to-do list & Formatting
π§° MORE EXCEL TOOLS for your WORK
================================
π Make a beautiful & elegant tracker with Excel - youtu.be/e0s9xdx5FF8
π― Create an interactive Risk Map with Excel - youtu.be/N8J-t9JxQbA
π² Set up a dynamic Project Plan (Gantt Chart) with Excel - youtu.be/W7NVKjg56ZY
π©βπ» Another beautiful Project Gantt Chart with Excel - youtu.be/FXnyKU6xZeI
π Build a perpetual Calendar & Appointment Tracker with Excel - youtu.be/70ncIeJEDRY
π Embed Excel Workbooks on your Website - youtu.be/5ViZ7aOxF3I
π Amazing distance calculator using Excel - youtu.be/RU9D-CyKwEQ
~
#Excel #todolist
Have a beautiful day πππΌ






![Learn DAX ALL() Functions in Just 30 Minutes [POWER BI Essentials]
Learn the when and how to use ALL function in Power BI. We are also going to cover the difference between ALL, ALLSELECTED, REMOVEFILTERS, ALLEXCEPT and SELECTEDVALUE functions with real-world examples of when and how to use them for data analysis.
What we are going to learn:
1) Explanation of the data model
2) How and why we use ALL funciton
3) Using ALL(table) vs. ALL(table[column]) with a real-world example
4) DAX Query View to debug and check measures
5) Understanding the evaluation context and why sometimes doesnt work
6) ALL vs. ALLSELECTED
7) ALL vs. ALLEXCEPT
8) ALL vs. REMOVEFILTERS
9) Understanding ALLCROSSFILTERED & ALLNOBLANKROW
10) Practical Example #1: Rank among all vs. Rank in a specific category (ALL with RANKX)
11) Example #2: How a specific month sales vary compared to all months sales
π Sample Power BI File:
Blank file: https://github.com/chandoo-org/Power-BI/raw/refs/heads/main/sample%20files/All%20the%20ALL%20functions-blank.pbix
Completed file (available only for my Power BI Course members): join here π https://chandoo.org/wp/power-bi-course/
π Video Topics:
0:00 - Understanding all the ALL functions in DAX (Power BI)
0:45 - Why and when to use ALL function
3:01 - Using ALL() with a table vs. table column
4:50 - DAX Query View and how it helps you with understanding calculations
6:10 - The key to understanding DAX - Evaluation Context
9:49 - ALL vs. ALLSELECTED
13:27 - ALL vs. ALLEXCEPT
17:20 - ALL vs. REMOVEFILTERS
18:40 - ALLCROSSFILTERED and ALLNOBLANKROW
22:14 - Rank in all vs. Rank in Category - RANKX + ALL Example
26:01 - Specific month sales vs. all month sales - Variance Analysis
πΊ More Power BI Videos and Playlists
π₯ Complete Power BI Course: If you want to learn Power BI including Power Query, DAX, Data Modeling and Dashboards - Check out my comprehensive Power BI Course - https://chandoo.org/wp/power-bi-course/
Use Code SAVE100 to get upto $100 (or Rs 6,000) discount on my Power BI + Excel bundle.
πΆ Power BI Videos playlist - https://www.youtube.com/playlist?list=PLmejDGrsgFyClheDmsfikqOt0no-TKArs
πΆ DAX + Power Pivot Playlist - https://www.youtube.com/playlist?list=PLmejDGrsgFyCm0i58VobdriBr FA8lYh
~
#powerbi #dax Learn DAX ALL() Functions in Just 30 Minutes [POWER BI Essentials]](https://i.ytimg.com/vi/o1WPhrvwjLQ/mqdefault.jpg)



