Customize Excel’s default file location so you don’t have to hunt for your most commonly used folder anymore. Suppose that most of your spreadsheets belong in a folder named Forecasts.

Excel actually provides a way to modify all your spreadsheets at once, but this task is unreliable when sorting. Follow the Record Macro instructions (4, 5, 6 under Macro1 above) to create this ...

Microsoft is still finding ways to inject drama into spreadsheets. The Verge points out that Microsoft is giving Excel support for custom live data types, expanding the content you can include ...

Among the new features is support for Azure Machine Learning and custom JavaScript functions to Excel to extend its capabilities. Excel now also allows Power BI developers to bring the custom ...

Note that the content that follows is based on Microsoft Excel 365 for PCs. Other versions of Excel may work differently. Let’s go through an example. We will create a LAMBDA to calculate Cost Per ...

CUSTOMIZE EXCEL’S CURSOR DIRECTION AFTER ENTERING DATA When I was using Excel 2003, I could easily adjust which direction the cursor would move—either to the right or down—after I entered data in a ...

Create from-scratch spreadsheets, or choose from a variety of included Excel templates. You can easily import and export data to/from Excel from a variety of sources. And take it up a notch with ...

Some programs are easier to customize than others, however. Microsoft’s Excel 2007 has some obscure attributes that can be extremely helpful for tweaking the program’s settings, but many people don’t ...