Excel Fromatting Tips: Keys to Perfectly Set-up Your Worksheets

July 26, 2012 Excel  2 comments

We may all know the basics in Excel, but here are a few examples that may not be second nature, and they should be. If you make sure you follow these tips with every worksheet, your more complex calculations, sorting, filtering, and even pivot tables will run smoothly. If you have any questions, as always, feel free to email us at questions@pbttinfo.com.

Read More
Excel Ctrl + D & Ctrl + R: Keyboard Shortcuts for Your Daily Workflow

July 18, 2012 Excel  No comments

Are you learning to love keyboard shortcuts as much as we are? Glued to your mouse and want to know how to accomplish additional functions without it? Either way, these shortcuts are very helpful.

In this tutorial, you will learn how to use two different keyboard shortcuts in a couple of ways. These are very helpful when you need to fill many cells with identical data. Read on! If you have any questions, as always, feel free to email us at questions@pbttinfo.com.

Read More
Excel AutoFill Handle & AutoFill: How to Speed-Up Your Calculations

July 12, 2012 Excel  2 comments

Have you ever heard of Excel AutoFill Handle and AutoFill? If so, do you know all of the ways you can use it? Learn how to use one of the most efficient tools Microsoft Excel offers and enter data in a fraction of the time it takes to do it manually.

In this tutorial, you will learn how to use the “Autofill Handle” to calculate data for large (as well as small) amounts of data in the quickest way possible.

Read More
Excel Tips & Tricks: Navigation Shortcuts to Save Time

July 3, 2012 Excel  No comments

Whether you’re a seasoned veteran or a new user, you may not know about these quick navigation shortcuts.   You don’t have to be glued to your precious mouse, clicking away at everything you see – let’s check out some tips for keyboard shortcuts and mouse-friendly tricks to make your navigation go more smoothly.  If you have any questions, as always, feel free to email us at questions@pbttinfo.com.

Read More
Welcome to Desktop Training Academy – The Blog

June 27, 2012 Excel  2 comments

Welcome everybody to your new desktop training hub!

The blog is still under construction, but it will be up and running in no time: a nicer graphic, RSS feed, social media buttons and awesome content free for you!

Read More
Excel Tips & Tricks: Multiplication and Fill Down

June 27, 2012 Excel  No comments

Have you ever wondered what kind of “special” things you can do with Paste Special in Excel?  Or maybe you’re only familiar with the CTRL+C/CTRL+V shortcuts for Cut and Paste?  Here are a couple more tricks you can use with the Paste functions.

Read More