Monthly Archives: June 2015

Microsoft Excel – creating bulleted lists

Posted on June 22, 2015 by jdonbavand

I had a client who wanted to use bullet points in a cell. This can be done by going to the Insert tab, then from the Symbols group, click Symbol, find a suitable bullet point and click Insert. However, that … Continue reading →

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

Microsoft Excel – making a PivotChart static

Posted on June 19, 2015 by jdonbavand

A PivotChart is connected to the PivotTable used to create it so every time you make a change to the PivotTable, the PivotChart automatically changes too. There are occasions when you might not want your PivotChart to change, i.e, you … 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

Crystal Reports – creating a date parameter where the end date is always today’s date

Posted on June 17, 2015 by jdonbavand

It may be that you want to run a parameter query within Crystal Reports where you can choose the Start Date but the End Date is always going to be today’s date. Create a parameter called Start Date which should … Continue reading →

Posted in Crystal Reports | Tagged , | 1 Comment