is a senior editor 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. After ...

Excel is probably Microsoft’s most popular developer tool. With a built-in functional programming language that now supports lambdas and variables, Excel has become a tool that people build businesses ...

Excel opens a preview window. If your columns look correctly split (Date, prices, and so on in separate columns), you're done ...

Will Critchlow shares some data visualization tips to build advanced link analysis charts. A deep dive into a client's link profile gives him an excuse to mash-up Linkscape application programming ...

Simplify your data transformation by skipping complex parsing expressions and instead using Flash Fill and Power Query in Microsoft Excel. Image: IB Photography/Adobe Stock If you work with imported ...