Maximizing Connectivity & Productivity


Quick Tip: Add Administrative Tools to the Windows 8 Start Screen

Read more

Twitter demonstrates troubleshooting capacity

Here are some thoughts on how Twitter can be helpful in increasing work efficiency..;carousel   By Erik Eckel –

Read more

Managing travel productivity

Notes from Travel Management Canada, Summer 2012 magazine: Mobile technology plays a role in enhancing travel safety and security, however checking on potential risks before booking travel is important. Most managed travel programs have as part of their travel policy, a provider or a third-party via their travel […]

Read more

Don’t use Yes/No fields to store preferences

This is an article by Allen Browne, about the use of creating a list of choices to select from, rather than creating seperate fields that are boolean (Yes/No) fields. Using choice fields, preferably choices laid out in a seperate table, rather than a list of values in […]

Read more

Excel – Change the default number format

The default number format in Excel is General. To  set the default format, you have two choices.  One is to preformat the range of cells, or select and preformat the entire worksheet.  And the second, more preferable method,  is to change the Normal style, as the default […]

Read more

Excel – Changing the link source

If your source workbook changes, you may need to change your external references.  For example if your original source file was Annual Sales, but the final file is then called Annual Sales 2012. To change the link source, use the Edit Links dialog box.  File-> Info -> […]

Read more

Why use VBA

Using VBA (Visual Basic for Applications), you can make Microsoft Office components such as Excel, Access, Outlook, Word etc. do almost whatever you need done. You can: Automate manual procedures Automate repetitive tasks. Insert boilerplate text Create number sequences as required Create custom commands Develop whole new […]

Read more

First look: Microsoft Office 2013 – Tech Republic

A quick preview of Microsoft Office 2013..

Read more

Excel – Summarizing data in a table

Convert a range of data into a table by choosing Insert ->Tables ->Table. The table is named Table1 by default. In the bottom row of the table, you now have a summary formula for a table column..

Read more

Excel – Copying a formula to another cell

Ever try copying a formula to another cell and then found that all the references change? To copy a formula so that it does not change when moved to another cell: Simply put an apostrophe before the formula that you want to copy, copy and paste into […]

Read more
Page 2 of 812345...Last »
Mississauga, ON, Canada 905.607.3500