Рет қаралды 26,578
In this tutorial, we will teach you how to use Excel to create a project management dashboard. We will start with a few Excel pivot tables to display the data to manage your project more efficiently. Next, we will show you how to use a slicer to filter out the data you want to see. We will also include data bars to show the progress of your project. Finally, we will show you how to display charts that show pertinent information to your project management. This is a great video to learn how some of the basics in Excel can help you create a project management dashboard.
Download the sample file used in How to Use Excel to Create a Project Management Dashboard here: www.myexcelonline.com/wp-cont...
How to Use Excel to Create a Project Management Dashboard Time Stamps ⌚
00:00 - Introduction to How to Use Excel to Create a Project Management Dashboard
00:26 - Overview of the Project Management Spreadsheet
01:15 - Creating an Excel Project Management Dashboard Sheet
01:30 - Inserting a Pivot Table on the Project Management Dashboard
02:52 - Inserting a Slicer for the Excel Pivot Table on the Project Management Dashboard
04:11 - Inserting a Tabular Pivot Table on the Project Management Dashboard
05:42 - Formatting Excel Data Bars for Project Status on the Project Management Dashboard
05:57 - Making the Slicer Change Both Pivot Tables on the Project Management Dashboard
06:35 - Inserting a Second Slicer on the Project Management Dashboard
07:29 - Inserting a Stacked Bar Graph on the Project Management Dashboard
11:35 - Inserting a Pie Chart on the Project Management Dashboard
13:24 - Conclusion for How to Use Excel to Create a Project Management Dashboard
------------
🔥 OUR BEST EXCEL RESOURCES 🔥
👨🏫 Get 30+ Excel & Office Courses & support for ONLY $1💵 (all levels covered)
Learn Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Power BI, Charts, Financial Modeling, Dashboards, Word, PowerPoint, Outlook, Access, OneNote, Teams, Project, PowerApps, PowerAutomate, Visio, Forms & MORE!
Join Now for ONLY $1 (limited time offer) 👉 www.myexcelonline.com/107-186...
📚 Download Our Free 101 Excel Tips & Tricks E-Book:
Download for FREE 👉www.myexcelonline.com/101-exc...
💻 Access 1,000+ Free Excel & Office tutorials over at our award-winning blog:
Access for FREE 👉www.myexcelonline.com/107-3.html
📚Get All Our 101 Excel E-Book series on Formulas, Macros & Pivot Tables:
www.myexcelonline.com/107-59....
📚101 Most Popular Excel Formulas Paperback on Amazon:
www.amazon.com/dp/1700300911
📚101 Ready To Use Excel Macros Paperback on Amazon:
www.amazon.com/dp/1700729675
📚101 Best Excel Tips & Tricks Paperback on Amazon:
www.amazon.com/101-Best-Excel...
👷 Excel Consulting Services:
www.myexcelonline.com/microso...
💻 Looking for more Microsoft Excel & Office tutorials? Check out our playlist below:
www.youtube.com/@MyExcelOnlin...
------------
Feel free to comment and ask questions about this Microsoft Excel tutorial below and we will get back to you with the answer ASAP!
If you enjoyed the video, please give a thumbs up, comment, share.
Do not forget to SUBSCRIBE to this channel to get our new Microsoft Excel tutorials delivered straight to you each week! Thank You :)
Cheers,
JOHN MICHALOUDIS
Chief Inspirational Officer & Microsoft MVP
www.myexcelonline.com/
❤️ Let’s connect on social ❤️
LinkedIn: / johnmichaloudis
Instagram: / myexcelonline
Pinterest: / pins
Facebook: / myexcelonline
Twitter: / myexcelonline
#MyExcelOnline #Dashboard #ProjectManagement #PM#Excel #MsExcel