To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.
With the INDIRECT function, you can reference and consolidate key data points across sheets. It's a straightforward process ...