If you want to find numbers that are above or below average, you don’t have to calculate that average and then review the values for those higher or lower. With conditional formatting in Excel, you can automatically highlight…

Dates in Microsoft Excel are useful for tracking finances, orders, and sales. So, there may come a time when you want to pull a month or year out of a date entry. Functions and formulas make this an easy task….

Sometimes you want your Excel spreadsheet to have a good appearance in addition to displaying the data. Rather than wrapping text in a cell or adjusting a cell’s size to accommodate the text, you can shrink the text to fit….

When you work with decimal numbers, rounding might be part of your equation. Microsoft Excel offers a few functions to help you quickly and easily round to perfection.

Unit conversions are commonplace. Whether you need feet to meters, Fahrenheit to Celsius, or teaspoons to tablespoons, you can take advantage of the CONVERT function in Microsoft Excel for a dozen types of conversion….

While Excel offers many features and functions for working with times, you may want your times formatted as decimals instead. You might need them for use in other formulas, for a timesheet, or for your own preference….

Scroll Lock in Microsoft Excel makes your Up, Down, Right, and Left Arrow keys either move between cells or scroll the entire worksheet. We’ll show you how to switch between these functionalities on your Windows 10 or 11 PC….