free tips tagged posts

Manually Find Formula Cells in MS Excel

December 10, 2012 Excel  No comments

Read More
Create an Instant Chart in Excel: Easy Power Shortcuts

December 4, 2012 Excel  No comments

Crating an instant chart in Excel is easy and convenient!

You’re in the middle of a meeting and you want to show all of the data you’ve collected as a chart. Don’t bore your coworkers by taking the time to click around creating one! In this brief tutorial, learn a quick keyboard shortcut to create a chart instantly!

Read More
How to Reply with Meeting in Outlook 2010

November 27, 2012 Outlook  No comments

Outlook 2010 Tutorial – Learn Reply with Meeting Function

Within an email, you have the option to “Reply with Meeting” in order to schedule a follow-up get-together that pertains to the email. Let’s see how it works! If you have any questions, as always, feel free to email us at questions@pbttinfo.com.
* * * * *

1...

Read More
Sorting in Pivot Tables

November 20, 2012 Excel  No comments

When your Excel 2010 worksheet becomes quite massive, using the Sort dialog box to sort on multiple columns can make it easier to find the data you need. The Sort dialog box can tell Excel what column to sort on next if two cells in the main sort column hold the same value or data.  If you have any questions, as always, feel free to email us at questions@pbttinfo.com.

Read More
Navigating through Workbook Tabs in MS Excel

November 13, 2012 Excel  No comments

Working with multiple sheets in a workbook can be useful if you’re working with similar data. However, moving through the workbook may seem difficult or even annoying. In this brief tutorial, learn a few ways to quickly & easily move from worksheet to worksheet in Excel. If you have any questions, feel free to email us at questions@pbttinfo.com.

* * * * *


1...

Read More
Adobe Acrobat & Microsoft PowerPoint

November 6, 2012 Adobe Acrobat ProPowerPoint  No comments

Did you know that you can utilize Adobe Acrobat to transfer a PowerPoint to a PDF? Learn how to transfer a file from Microsoft PowerPoint quickly and easily to Adobe Acrobat. Also, learn how to view your PowerPoint presentation as thumbnails in a PDF on Acrobat. If you have any questions, feel free to email us at questions@pbttinfo.com.
* * * *

Read More
Left & Right Formulas

October 23, 2012 Excel  No comments

If you have cells that contain a certain amount of data and you’re only looking for certain portions of it, one method you can use involves the =LEFT and =RIGHT formulas. They’re simpler than trying to go through and use Copy & Paste. Let’s see how they work. If you have any questions, as always, feel free to email us at questions@pbttinfo.com.


* *...

Read More
Using Basic Sorting in Excel

October 16, 2012 Excel  No comments

Want to sort your data alphabetically? There are a couple of key facts you need to know about sorting in order to make sure your data doesn’t get skewed when you sort by certain criteria. Take a look at this quick tutorial about basic sorting in MS Excel, and make sure your data is correct. If you have any questions, as always, feel free to email us at questions@pbttinfo.com.
* * * * *

Read More