March Newsletter 2013

Spring is in the air; the days are getting longer and it’s that time of year where you have to debate whether or not to wear your winter coat (too cold without it, unbearably hot with it).

What’s in March’s Newsletter:

·         New Tech Toy: HTC One

·         Deal of the Month

·         Tech Tip of Month by Alandale Training

·         Events Around Vancouver

·         This Month in Tech History

New Tech Toy: HTC One

Soon to be released on March 22nd (and now available for pre-order) through Rogers, Telus and Bell, the HTC One is definitely one of the sleekest looking phones on the market for the foreseeable future. On aesthetics alone it’s comparable to the iPhone 5 and BlackBerry’s Z10.

But as they say “looks aren’t everything” so here are the specs:

The big question is how does it compare to the most anticipated Android device this year: the Samsung Galaxy S 4? The answer may surprise you. According to most reviews out there the HTC One absolutely blows the Samsung Galaxy S 4 out of the water. But you don’t need to take my word on it. Below are some reviews on the HTC One as well as on the Samsung Galaxy S 4.

HTC One: Review 1 & Review 2

Galaxy S 4: Review 1 & Review 2

Deal of the Month:

Each month we will supply you with a product that we believe is a great deal and may suit your business or personal needs. This is an opportunity for you to save time and energy shopping around for what’s best at the best price, because we have done it for you!

Logitech K400 Wireless Touch Keyboard With Built-in Multi-Touch TouchPad Black

Price: $50.00 including tax, shipping & handling

If you are interested please contact the sales team at

Tech Tip of the Month:

Brought to you by Alandale Training a great resource online for tips and on-site computer training courses in Vancouver, BC. Visit their site at www.alandaletraining.com.

Quickly moving to the edge of a large block of data in Excel

If you work with large spreadsheets you will find yourself using the scroll bar to move to the top or bottom of a column.   A quicker way to move around in a large spreadsheet is to use keyboard shortcuts.

You may have discovered that using Ctrl+ an arrow key will move to the last cell with data in that direction.  So Ctrl+<Down Arrow> moves  the active cell down to the last cell before an empty cell and Ctrl+<Right Arrow> moves the active cell right to the last cell before an empty cell.

There’s a mouse alternative to these keyboard shortcuts.  Let’s say you are at the top of a large spreadsheet and the active cell M4. You want to move to the bottom of column M.  Move the mouse pointer to the bottom edge of the active cell where you would go to drag if you wanted to move the cell.  Instead of dragging, double-click.  Excel moves down to the last cell before an empty cell.

These shortcuts work best with columns or rows that contain very few, or no, blank cells because they both move the active cell to the cell before an empty cell.  If your row or column contains lots of empty cells switch to a column or row that doesn’t or use the scroll bar.

If you liked this tip click here to join the Alandale Training Mailing List to receive more great tech tips.

Events Around Vancouver:

March 20^th: Macaron Day

March 23^rd – April 1^st: Easter at the Stanley Park Miniature Train

March 30^th: The Great A-Mazing Egg Hunt at VanDusen Botanical Garden

March 30^th & 31^st: 1^st Annual Easter Egg-Stravaganza at Maan Farms in Abbotsford

Forward to a Friend