Maximizing Connectivity & Productivity

Archive for July 2012

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

Excel Cell reference type change shortcut

You can change the cell reference type, manually and painfully using $ signs before the row numbers and/or column headers.  Or, you can take the easy route using the F4 key. To use, insert the ‘=’ sign in the  cell, then use your mouse to select the […]

Read more

Creating Word Templates

Why create word templates and how do we create them without unwanted add-ons? The number one no-no is to not base your template on an existing document. This will only invite every little attribute or hanger-on that is either not really obvious, but not deleted, to come […]

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