is a senior correspondent and author of Notepad, who has been covering all things Microsoft, PC, and tech for over 20 years. Microsoft Excel used to only allow two types of data: text and numbers.

From data preparation to dashboard design, Excel offers features for analysis, automation, visualization, and formatting that ...