How to Build Hierarchy in Excel. A hierarchy shows relationships between objects, processes or people. For example, a hierarchy can show the order of steps needed to bake a cake or it can show who ...