New Horizons Get Schooled Blog

Select your dataset without all that clicking and dragging (Excel 2016/2013)

Posted on 4/19/18 2:04 PM by Get Schooled in Excel

To select your entire dataset, do you always click and drag? For small groups of cells, this method works just fine, but as your dataset grows, you may find it awkward to drag outside the visible window. Sometimes the scrolling speeds up unexpectedly, and you have to really work to select your entire dataset and nothing more. Consider a faster approach: simply press [Ctrl][Shift][*] to select your entire dataset.

Once you click on a cell, you can select the remainder of that column by pressing [Ctrl][Shift][Down Arrow], or you can select the remainder of that row by pressing [Ctrl][Shift][Right Arrow]. Similarly, [Ctrl][Shift][Up Arrow] and [Ctrl][Shift][Left Arrow] select the dataset’s entire column above and to the left of the selected cell, respectively. Combine the arrows for even more options. For example, press [Ctrl][Shift][Up Arrow][Right Arrow] to select everything in the dataset above and to the right of the selected cell, and so on.

0 CommentsContinue Reading →

Microsoft Excel Order Of Operations

Posted on 3/1/18 2:31 PM by Get Schooled in Excel

Excel adheres to a strict order of operations when calculating formulas. Keep this order in mind when building formulas to ensure accurate results.

0 CommentsContinue Reading →

Excel: The More You Know, the More You Grow

Posted on 3/1/18 3:58 AM by Get Schooled in Excel

Many observers have noted that most people who use Excel probably know about 10% of what it can do. Those who learn how to use more extract far more value from Excel and become far more valuable to their employers. Here are some directions for learning and earning more with the world’s most powerful spreadsheet.

0 CommentsContinue Reading →

Turn your data range into an instant chart (Excel 2016)

Posted on 2/13/18 9:32 AM by Get Schooled in Excel

Intimidated by Excel’s chart function? You don’t have to be a whiz to get a quick, new perspective on your spreadsheet’s contents.

0 CommentsContinue Reading →

Tired of Your Excel Color Scheme? Change It!

Posted on 9/9/14 3:00 PM by Get Schooled in colors, in Excel, in Microsoft, in tips and tricks, in Tips & Tricks, in Windows 2010

Give Excel a new color scheme.

0 CommentsContinue Reading →

Eight Time-Saving Excel Shortcuts

Posted on 8/13/14 7:05 AM by Get Schooled in Excel, in excel keyboard shortcuts, in excel shortcuts, in Microsoft, in Office, in Tips & Tricks

Excel has a lot of useful shortcuts that perform various tasks. The more you know, the more time you can save.

0 CommentsContinue Reading →

Recover Unsaved Workbooks

Posted on 4/28/14 12:51 PM by Get Schooled in Excel, in Microsoft, in Recover workbooks, in Tips & Tricks, in windows

We've all done it before. 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 case, there's no need to panic. With Excel 2010, you can quickly and easily recover older (unsaved) versions of your workbook.

0 CommentsContinue Reading →

How to switch sheets in Excel using shortcuts

Posted on 1/7/14 3:09 PM by Get Schooled in Excel, in keyboard shortcuts, in Microsoft, in shortcuts, in Tips & Tricks

A simple way to switch sheets, even though most of us probably use the mouse, you can just press Ctrl+Page Down and it will get you there super fast.

0 CommentsContinue Reading →

Keep leading zeros in Excel

Posted on 9/30/13 2:18 PM by Get Schooled in Excel, in excel training, in Microsoft, in tips and tricks, in Tips & Tricks

If you need to enter the Zip code 02364 in your Excel spreadsheet, you'll probably throw your hands up when Excel automatically changes the value to 2364. Your Zip code must have five digits, but by default Excel doesn't display leading zeros.

0 CommentsContinue Reading →

Keyboard shortcuts for easy paragraph alignment

Posted on 7/9/13 8:30 AM by Get Schooled in Excel, in Justification, in keyboard shortcut, in Lists, in Microsoft, in microsoft office, in Office, in powerpoint, in Tips & Tricks, in Word

There are many ways to change the alignment of a paragraph in Microsoft Office: you can click the Align Left, Center, Align Right, or Justify buttons on the Formatting toolbar (the Home tab's Paragraph group in Word 2007 and 2010); you can also select Format | Paragraph, click on the Indents And Spacing tab, and choose the desired setting from the Alignment dropdown list.

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