Excel: How to Display the Percentage of Completed Tasks in a Task Tracker Dashboard
This video is based on a request for help that I received from Tim, one of my channel subscribers. He said..."I have a table of tasks which fall under different headings and the final column is complete/not complete. I want to create a dashboard using Pivot Tables but I am unable to work out how to present %complete in the Pivot Table and dashboard. Can you help?"
🗒 Notes and Resources
Download a copy of the file used in this video: https://app.box.com/s/fap92hzunxaioq6...
The formula that I used in the demos:
="Completed Tasks: " & TEXT(Tasks!I3, "0%")
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #tasktracker #pivottables #dashboard