Maximizing Connectivity & Productivity

Archive for July 2012

Poll: IT Pros plan to buy Microsoft Surface tablets not iPads

What’s the pro opinion on tablets – Apple Ipads vs Microsoft Surface tablets (and others)?  Check the poll results by Techrepublic.. Related:;siu-container

Read more

Drawing toolbar in Excel 2010

If you are wondering where this disappeared in Excel 2010, you can blame the Ribbon.  The Ribbon is designed to show the menus with commands to help complete a task.  As such, there are the basic commands on each tab, and then there are the Contextual tabs […]

Read more

Word – Create a new style

Read more

Scroll through worksheet without losing active cell

 While in the Active cell, press the Scroll Lock key.  Excel will display Scroll Lock  in the Status bar.  Use the navigation arrows to scroll/navigate through the worksheet as required.  When done, use Ctrl-Backspace key to return to the active cell.  Press the Scroll Lock key again […]

Read more

Excel – Date axis in Sparklines

Sparklines in Excel tend to show values as if the dates exist even if there are gaps in dates, by showing even charts with no intervals.  However, if the date axis is selected,  the sparkline charts will show the gaps in the dates. To specify a date […]

Read more

Excel files as source for Excel Query

Data from other Excel workbooks may be used in a workbook.  You can put as many data tables in a workbook as a source for Query, but you will need to name the tables as ranges, because that’s how they are identified in Query.

Read more
Page 2 of 212
Mississauga, ON, Canada 905.607.3500