Get & Transform in Excel can help you search for data sources, make connections, and shape that data in ways you deem fit. For instance, you can remove a column, change a data type, or merge tables.
To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.