Mac OS X – Scrolling Tips

Have you ever been frustrated recently with how your Mac doesn’t scroll like it used to?  If so, I hope you find the tips in the video below helpful.

Microsoft Word: Insert Table of Contents

Have you ever wanted to insert a table of contents in your Word document, but aren’t sure how?  The video below will show you how to do just that on both a Windows and Mac computer.

Using Colby Apps: Out-of-Office E-mail Message

Below is a video tutorial on how you can set your out-of-office automated e-mail reply message.

Using Colby Apps: Search your e-mail

When most people think of searching the web, they think of Google.  Google has revolutionized the way we find web pages by using a very complicated (and secretive) set of algorithms to take the words we give it and find what usually turns out to be a very helpful list of web pages.

Colby Apps e-mail’s web interface allows you to utilize some of those same search capabilities.

[Read more...]

Creating a PDF

Portable Document Format (PDF) files are great because they act as electronic versions of printed pages but with several benefits over traditional paper copies:

  • They are a much greeneroption
    • No paper required
    • No need to power on a printer or heat up a fuser
    • No need for toner
    • No reprinting pages that have mistakes
  • As the name implies they tend to be small enough to be easily transferred via e-mail or on a USB thumbdrive
  • They are viewable on almost any electronic device (from computers to smart phones to tablets)

So, how do you create a PDF? [Read more...]

Self-paced Training

Colby subscribes to an online service called VTC that provides self-paced training opportunities on a wide variety of software applications. These software titles range from Office applications like Word and Excel, to database programs like FileMaker, to programming languages like HTML, to operating systems like Windows and Mac OS X.

[Read more...]

Extracting Data by Cell Values in Excel

 Let’s say you have a large workbook of names and addresses and you need to find only those folks listed with area codes of 207 and 613. You could sort the data by area code and copy and paste after each section – or you could use the FILTER function.

Here’s how:

ExtData-1 Select the entire range of data you want to filter for a specific value(s)
SortFilter Click the SORT&FILTER icon on the right side of the Ribbon
Filter Select “Filter
dropdown The selected range should now have drop-down arrows at the head of each column
SelectFilter Click the down-arrow on the column that you want to Filter on.Uncheck the “Select All” box.Check the values you want to filter for.Click OK
NumberFilters Note: If you click on “Number Filters“, a list of options will display. The default is “Equals“.If you wish to use another strategy, select it here.
Outcome The outcome of this action is shown to the left
Clear To clear the filter, click on the down-arrow again and select “Clear Filter…”The range will return to normal
text If you had chosen to sort the text column instead, you would have been presented with text options as shown to the left.