Скачать или смотреть 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