Mapping Tables in Excel Tables to Create a Visio Org Chart | Everyday Office 061

Can we create a table that automatically ties every employee to their position and their manager? When the structure of the company changes, can we update the spreadsheet of every person in the organization, then automatically create a Visio Organization Chart from the data? In this video tutorial, Neil Malek from Knack Training demonstrates how to use Tables, Data Validation, VLOOKUP, and INDIRECT to build the perfect employee structure.

Music: "Unrhythm" by Birocratic
http://birocreatic.lnk.to/allYL

Knack Training is a software and professional development training company from Orlando, FL. Neil Malek, principal at Knack Training, records software tutorials everyday through the series Everyday Office.

Knack Training is recording their entire library to provide lifetime value through KnackCourses.com - soup-to-nuts training in Excel, Outlook, and more.

Subscribe to my channel here: https://www.youtube.com/subscription_center?add_user=neilmalek

Subscribe to the quarterly tutorial ezine: http://knacktraining.com

http://knacktraining.com
http://knackcourses.com
http://facebook.com/knacktraining
http://twitter.com/neilmalek
http://instagram.com/neilmalek

Видео Mapping Tables in Excel Tables to Create a Visio Org Chart | Everyday Office 061 канала Neil Malek