New Horizons Get Schooled Blog

Deselect a cell without starting over with your selection (Excel 2016)

Posted on 12/27/18 10:00 AM by Get Schooled in Microsoft Excel, in excel training, in excel tips & tricks

While selecting a number of cells, it’s easy to accidentally click on a cell you didn’t intend to include. But you don’t have to start over with your selection after every misclick. You can deselect the mistakes.

Press and hold the [Ctrl] key while clicking on any cells you want to deselect. While holding down [Ctrl], you can also click on any additional cells you want to add to your selection.

This feature is only available with an Office 365 subscription.

0 CommentsContinue Reading →

Convert units of measurement within your data (Excel 2016/2013/2010)

Posted on 11/5/18 8:00 AM by Get Schooled in Microsoft Excel, in Excel, in excel tips & tricks

Convert units of measurement within your data (Excel 2016/2013/2010)Excel’s CONVERT function provides an easy way to display your data in another unit of measurement. For example, if you have a list of temperatures in Fahrenheit and you’d like to add a column that displays each temperature in its Celsius equivalent, you need look no further than the CONVERT function.

Let’s assume your first Fahrenheit temperature, 98.6, is located in cell C7. In cell D7, type =CONVERT(C7,"F","C"), where C7 refers to the temperature you want to convert, “F” refers to Fahrenheit, and “C” refers to Celsius.

Excel allows conversions for dozens of units of measurement, including mass, pressure, distance, magnetism, and many others. Search for the term convert in Excel’s help pages to find an exhaustive list of all conversions and their text values you’ll use in your formula. For example, “m” represents meter, “in” represents inch, “T” represents Tesla, and “ga” represents Gauss.

0 CommentsContinue Reading →

Apply Cell Styles to quickly call attention to important data (Excel 2016)

Posted on 7/12/18 9:32 AM by Get Schooled in Microsoft Excel, in excel tips & tricks

Color, bold face, and other elements draw the eye, and these elements can make your worksheets more user-friendly and scannable. Excel’s built-in Cell Styles simplify this process, allowing you to add multiple changes, such as background color, underlined text, and bold face, all at once. Cell styles also help you avoid mistakes, such as inconsistent formatting from one cell to the next. 

To apply cell styles, select all the cells you wish to format. Choose the Home tab on the ribbon, and in the Styles group, click on Cell Styles and choose the style you’d like to apply. You can also create your own personalized cell styles by clicking on Cell Styles | New Cell Style.

0 CommentsContinue Reading →

Instantly find cells connected to a formula

Posted on 9/11/11 4:03 PM by Get Schooled in excel formulas, in excel keyboard shortcuts, in excel shortcuts, in excel tips & tricks, in Tips & Tricks

When a formula relies on many other cells to calculate its result, it can be challenging to troubleshoot errors. Instead of using the Formula Auditing toolbar, which itself can be confusing, you can quickly pinpoint precedent and dependent cells using shortcut keys. First, select the cell you need to troubleshoot. To select all cells that depend on the current cell’s value to calculate their results, press [Ctrl](]). Or, press [Ctrl]([) to select all the cells the current cell depends on to calculate its own result. You may find it helpful to apply cell shading to the cells Excel selects: then you can troubleshoot your formula by reviewing the shaded cells one by one. Just remember to remove the cell shading when you’ve finished troubleshooting.
Check out our upcoming Excel classes

0 CommentsContinue Reading →

Search by Topic

    Lists by Topic

    see all

    Be at the center of it all.


    Knowledge Ninjas

    a web-based service that allows software application end users to access a subject matter expert in real-time via a chat interface to resolve questions or problems they encounter in their specific software.