New Horizons Get Schooled Blog

Filter your table in a snap with slicers (Excel 2016)

Posted on 9/14/18 10:36 AM by Get Schooled in Microsoft Excel

To make filtering your table even more straightforward, use Slicers. Select a range within a table or PivotTable, then click on the Insert tab on the main ribbon. In the Filters group, click on Slicer. In the resulting Insert Slicers dialog box, choose the column you want to filter. Excel creates labeled buttons that allow you to filter your table with a single click. After clicking on one of the buttons to filter your table, you can choose more buttons by clicking on the Multi-Select button. When you’re ready to undo the filter, click on the Clear Filter button.

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 →

Automatically apply a color gradient based on cell values (Excel 2016/2013/2010)

Posted on 9/12/17 9:59 AM by Get Schooled in Microsoft Excel

To get a quick handle on your data, change the color of your cells according to their numerical values. Select the entire block of data you want to format. Select the Home tab on the main ribbon, and then, in the Styles group, click on Conditional Formatting. Choose Color Scales from the resulting menu, and then mouse over the options to see a preview. Click on the option you prefer. Excel automatically applies a color gradient based on the range of numerical data in the cell. For example, if the data in your selected cells ranges from 1.29 to 275, and you choose the Red – Yellow – Green color scale, small numbers (e.g., 1.99) will be green, mid-range numbers (e.g., 12.49) will be yellow, and large numbers (e.g., 255) will be red. The smaller the number, the darker the shade of green. This striking graphic contrast allows you to quickly pick out the largest and smallest numbers in your selection, as well as the middle values.

0 CommentsContinue Reading →

Count unique values—with a ROWS function (Excel 2016/2013/2010)

Posted on 8/8/17 5:55 PM by Get Schooled in Microsoft Excel

 For example, say your worksheet lists attendee registration information for your company’s recent training session, and you’d like to know how many states (or countries) were represented at your training. A quick Excel filter will provide a list of every unique entry.

0 CommentsContinue Reading →

Save your sanity: Automatically fill data into your worksheet (Excel 2016/2013)

Posted on 6/12/17 8:39 AM by Get Schooled in Microsoft Excel

When you need to create a list of data that follows a pattern, let Excel’s AutoFill feature do the mundane work for you. To create a list from 1 to 10, type the number 1 and hit [Enter], then select that cell and hover your mouse over the black box in the lower-right corner of the cell until the cursor forms a plus sign. Drag ten rows down, and release.

0 CommentsContinue Reading →

Freeze a row and column at the same time (Excel 2016/2013/2010/2007)

Posted on 6/12/17 8:10 AM by Get Schooled in Microsoft Excel

In large worksheets where the first row contains headers, you’ve probably used Freeze Panes to ensure that the header row always displays, even when you’re scrolling to the bottom of the worksheet. You can freeze any number of rows or columns, but you must begin with the first row or column in your worksheet. But did you know you can also freeze rows and columns at the same time? We’ll show you how.

0 CommentsContinue Reading →

Excel text tricks: Here’s how to change case easily (Excel 2016)

Posted on 6/12/17 8:08 AM by Get Schooled in Microsoft Excel

You rarely use Excel for its text editing features—Excel exists to work with numbers and data. But when your spreadsheet data needs revamping, you don’t necessarily need to copy everything into Word. For example, Excel provides formulas for quickly changing the case of text. The UPPER, LOWER, and PROPER functions convert your text to all caps, lowercase, or proper case, respectively. The syntax is straightforward, too. Say your list of important contacts is in full caps, and you want the proper case (the first letter of each word capitalized). If the first name you need to convert is in cell B3, type =PROPER(B3) and press [Ctrl][Enter]. Select and drag the small black square in the lower-right corner of the cell containing your formula to instantly copy the formula for each item on your list.

0 CommentsContinue Reading →

Make The Best Use Of Worksheet Hyperlinks

Posted on 5/3/17 3:07 PM by Get Schooled in Microsoft Excel

When you think of worksheet hyperlinks, you probably think of website links. There's another great use for hyperlinks in your workbook that you might not use to its full potential: internal links. You can create a hyperlink that takes you to another location within the same workbook when you click on it.

0 CommentsContinue Reading →

Make The Best Use Of Worksheet Hyperlinks

Posted on 1/15/17 3:13 PM by Get Schooled in Microsoft Excel

When you think of worksheet hyperlinks, you probably think of website links. There's another great use for hyperlinks in your workbook that you might not use to its full potential: internal links. You can create a hyperlink that takes you to another location within the same workbook when you click on it.

0 CommentsContinue Reading →

Recover Unsaved Workbooks

Posted on 4/20/16 3:05 PM by Get Schooled in Microsoft Excel

We've all done it before—either you forget to save a workbook, you accidentally save it when you should have saved it as a different name, or maybe you lose work because of that rare power outage. Whatever the cause, there's no need to panic when you think you've lost your work in Excel 2010. You can quickly and easily recover older (unsaved) versions of your workbook.

0 CommentsContinue Reading →

Search by Topic

    Lists by Topic

    see 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.

     

    Subscribe