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: app.box.com/s/...
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 theexceltraine...
🙋‍♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #tasktracker #pivottables #dashboard

[@pandamonium9834]

Afternoon Mike hope you are having an excellent day with birthday cake xxx. Gluten free xx

[@pandamonium9834]

Very smart