New Horizons Get Schooled Blog

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 →

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 →

Make your own keyboard-shortcut cheat sheet

Posted on 3/14/11 10:03 PM by Get Schooled in excel keyboard shortcuts, in shortcuts, in Tips & Tricks

(Word 2000/2002/2003/2007)
We’ve all wracked our brains trying to remember shortcuts for rarely used — but important — Word applications.

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