To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.

How to Make a Cell on Microsoft Excel With a Changing Date. Microsoft Excel offers a Function Library with formulas that insert the current date when you open the worksheet or enter calculations.