Microsoft Excel

If you are routinely creating formulas that accomplish the same purpose, spending a little extra time upfront to create a function that can be reused will save you time in the end.

This month’s column walks you through all the special ways you can paste text, data, and even application capabilities in Excel.

Creating drop-down lists in your spreadsheets is a great way to ensure that only certain information
is entered into a cell.

You can include both a formula and text in the same cell in Excel.

If Excel can sense a pattern in what you are doing,
it will try to complete the task for you.

You can easily convert horizontal data to
vertical and vertical data to horizontal by using the
Transpose feature in Excel.

With spilling, you can create a formula in one cell, and that formula will then spill over into other adjacent cells when a set of values is calculated.

In certain scenarios, showing zero values can be
very distracting. They can be easily hidden in Excel.

You can convert text in Excel to linked data types. This is referred to as “linked” data types because the data is connected to an online data source.

Excel Personal Assistant can help you locate all the features Excel has to offer.