Maximizing Connectivity & Productivity


How to select which programming (or other) skills to learn

This article from TechRepublic outlines how to select which programming skills to learn when looking for a job.  However, these points also apply to learning any skills when looking for a new job.  All, or at least most offices use Microsoft Office, and it is worth learning […]

Read more

Training ROI: How to Make Sure Training Is Worth Your Money

From All workers can benefit from professional development and training courses, but when times are tough, training is often one of the first things cut from the budget. Whether they’re to stay on top of industry changes or sharpen their skills, workers benefit from training, and […]

Read more

Excel – Creating and Testing new custom number formats

Creating new custom number formats is a create, test – rework, retest cycle.  It is best to check how the number appears for positive, negative, zero and text values.  However, each time the format is tested, the custom string will appear in the list to be selected. […]

Read more

Excel – Draw circles around invalid entries

Once you have set your validation rules, use the circle feature in Excel to circle the invalid entries.  This is an oft forgotten useful tool that is simple to use and apply. To use, highlight the column containing the validation rule(s).  Goto Data-> Data Tools-> Data Validation […]

Read more

Excel – Add a macro to the Quick Access toolbar

To add a macro to the Quick Access toolbar: Create the macro Right-click the Quick Access toolbar Click Customize Quick Access toolbar Select Macros from the drop-down list on the top left Select the macro Click the Add button To change the icon, click the Modify button

Read more

Ways to add commands to the Quick Access Toolbar

There are different ways to add commands to the Quick Access Toolbar.  Here are a few. Right-click the Quick Access Toolbar and select ‘Customize Quick Access Toolbar’ Dropdown the little arrow to the right of the Quick Access Toolbar.  Any of the commands listed there can be […]

Read more

Excel – Using SUMIF() to add only certain figures using criteria

So you don’t want all the numbers in a column added, using the SUM() function. Use the SUMIF() function to specify which figures are to be added, by specifying the criteria that Excel should use to identify these figures. ex. if you want to add only the […]

Read more

Excel – Increase number of rows

Spreadsheets in versions of Excel prior to Excel 2010 were limited to 65536 rows and 256 columns.  To increase these, simply open the workbook in Excel 2010, and save.

Read more

Excel Chart tip -ribbon vs format dialog

The ribbon controls do not have a complete set of tools for chart elements.  The Format dialog box has options that are not available on the ribbon.

Read more

Excel Charts – Pie, Doughnut or Stacked

Pie charts can represent only one data series, whereas doughnut charts can represent multiple data series.  Each of these series in a doughnut chart are represented by concentric rings.  Because one ring is smaller than the other, the slices of the ring(s) may give a visually decieving representation […]

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