Monthly Archives: May 2015

Crystal Reports – using a parameter field to generate a Summary or Detail report

Posted on May 29, 2015 by jdonbavand

You may have created a report and you want users to have the option of either just seeing the summary level or the full details. This can be achieved using a parameter. Create a new parameter  called Summary or Detail. … Continue reading →

Posted in Crystal Reports | Tagged , | 1 Comment

Microsoft Excel – using named cells instead of absolute cell references and updating formulas based on them

Posted on May 26, 2015 by jdonbavand

Recently I was training a group of people who had large workbooks with a lot of formulas containing absolute cell references. I taught them how to name cells which not only saves the need to use absolute cell references but … Continue reading →

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , | Leave a comment

Microsoft Excel – referencing a cell in a chart title

Posted on May 25, 2015 by jdonbavand

When working with charts in Microsoft Excel, you may want the title to reference a cell in your spreadsheet so that if the information changes in that cell, the chart title will also change. In the example above, I may want … Continue reading →

Posted in Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , | Leave a comment

Microsoft Excel – creating a work week series based on a Monday to Saturday working week

Posted on May 22, 2015 by jdonbavand

If you type in a date in Microsoft Excel and drag down, the subsequent cells will show subsequent dates and when you look at the Autofill options, you will see options for selecting for filling Days or Weekdays. However, for … Continue reading →

Posted in Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , | Leave a comment

Grouping and ungrouping worksheets in any version of Microsoft Excel

Posted on May 20, 2015 by jdonbavand

Originally posted on ifonlyidknownthat:
If you are going to want similar information in several worksheets in an Excel workbook, you can group the worksheets together, then any typing of labels, formatting and entering of formulas will be applied to all…

Posted in Uncategorized | Leave a comment

Microsoft Project – Resource usage view to show only resources being used

Posted on May 14, 2015 by jdonbavand

When you go into Resource Usage view, every resource in your resource pool is shown regardless of whether or not they have been assigned to tasks. Also any task that has not yet been assigned to a resource is shown. … Continue reading →

Posted in Microsoft Project, Microsoft Project 2010, Microsoft Project 2013, Microsoft Project 2016 | Tagged , | Leave a comment

Crystal Reports – changing date format from 20150131 to 31/01/2015

Posted on May 13, 2015 by jdonbavand

A client had dates coming into her report in the format 20150131 when she wanted it in the format 31/01/2015. The formula I used to convert this made use of the LEFT, MID and RIGHT functions: RIGHT({Orders_.Date},2)&”/”&MID({Orders_.Date},5,2)&”/”&LEFT({Orders_.Date},4) In this instance … Continue reading →

Posted in Crystal Reports | Tagged , | Leave a comment

Microsoft Excel – Conditionally format blank cells

Posted on May 12, 2015 by jdonbavand

To conditionally format blank cells: Select the data range that you want to format. From the Home tab, click the Conditional Formatting dropdown and click New Rule. Click Use a formula to decide what cells to format. In the Format … Continue reading →

Posted in Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , | Leave a comment

Microsoft Excel – showing the Field List in a PivotTable in alphabetical order

Posted on May 7, 2015 by jdonbavand

By default, when you insert a PivotTable into an Excel workbook, the field list is shown in the order of the column headings in the original data set. I was working at a clientt site recently where there were numerous … Continue reading →

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , | Leave a comment

Microsoft Word – keeping a phone number all on one line

Posted on May 7, 2015 by jdonbavand

I was asked at a seminar yesterday how to ensure that a phone number remained on one line whilst working in Microsoft Word. Normally, if I type a phone number such as 0432 117628 it carries on to the next … Continue reading →

Posted in Microsoft Word, Microsoft Word 2003, Microsoft Word 2007, Microsoft Word 2010, Microsoft Word 2013, Microsoft Word 2016 | Tagged | Leave a comment