Excel allows you quite a lot of freedom to customize your user experience via the use of macros. This tutorial will show you how to create and name worksheets using an existing list via a macro. You ...

Number formats in Microsoft Excel define how data is displayed in your spreadsheet without changing the underlying values. As well as using number formats to present data as dates, times, percentages, ...

Excel Conditional Formatting already lets you format cells based on the value of those cells or the value of the formulas in those cells (see our conditional formatting tutorial for more details). Now ...

Excel's randomization functions generate values, shuffle datasets, and simulate timelines using simple formulas.

Excel drop-down lists, like those found on Web pages, help you view large amounts of data in a small area. They are also useful for limiting the choices an Excel spreadsheet user can make when editing ...

When you want to combine values in Microsoft Excel, instead of complex expressions or VBA, opt for Power Query – it’s fast and easy. My TechRepublic article How to combine values from a column into a ...