Monthly Archives: August 2016

Microsoft Project – resourcing in a master plan

Originally posted on ifonlyidknownthat:
If you combine two or more Microsoft Project files into a master project and have used the same local resources within the plans, you will discover if you look at the resource sheet that the resource…

Posted in Uncategorized | Leave a comment

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

Originally posted on ifonlyidknownthat:
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…

Posted in Uncategorized | Leave a comment

Microsoft Excel – width of columns in charts

Originally posted on ifonlyidknownthat:
I was working with a client the other day creating column charts of data where the horizontal axis was made up of dates. We wanted to make the columns wider, but trying to format the data…

Posted in Uncategorized | Leave a comment

Microsoft Excel – putting negative numbers in brackets

Originally posted on ifonlyidknownthat:
Rather than having negative numbers with a minus sign in front of them, some people prefer to put negative numbers in brackets. To do this, select the cell or range of cells to be formatted, then…

Posted in Uncategorized | 1 Comment

Microsoft Excel – third working day of every month

Someone asked me recently whether they could produce a series in Excel to find out the third working day of every month. To be honest, it may be as easy to do this manually as you still need to input … Continue reading

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

Microsoft Office SmartArt – curving text in shape

Recently someone I was teaching had created some Stacked Venn SmartArt similar to below but she wanted the text to follow the curve. Select the text, then on the SmartArt Tools Format tab, in the WordArt Styles group, click the … Continue reading

Posted in Microsoft Office 2007 and 2010, Microsoft Office 2013, Microsoft Office 2016, Uncategorized | Tagged , , , | Leave a comment

Microsoft Office – labels for stacked column totals

If you create a stacked column chart it is easy enough to show data labels for the individual parts of the stacked column but not so obvious how to create a label just showing the column total. To do so, … Continue reading

Posted in Microsoft Office 2007 and 2010, Microsoft Office 2013, Microsoft Office 2016, Uncategorized | Tagged , , , , , | Leave a comment