Question: With Covid-19 and the lockdown, my project schedule is put on hold for a number of weeks. How can I reflect this in my Microsoft Project Gantt Chart? This is useful for tasks that haven't started yet - you don't want to change the start date of tasks that...
If you try to create an Excel report in Microsoft Project but have a different version of Excel, then you will have come across this error: "This operation requires that you have Excel 2003 or later installed on your computer." In disbelief, you check that you have...
Once you start using these top 10 Excel keyboard shortcuts, you will never look at your Excel spreadsheets the same way again. If you want to become more efficient with Excel, shortcuts are a good way to speed up your data entry, find your way around your spreadsheet...
How do I print just the Gantt chart in Microsoft Project without it being 50 million pages? I have tried every option possible and so far wasted about eleven trees of A3 paper but I just keep printing blank pages – is there some way to scale it without making it...
Top 5 Reasons to Learn PowerPivot -Training for Results Hey there! Have you discovered the power or PowerPivot for Excel yet? Or are you stuck with boring old Excel sheets and formulas that quickly become cumbersome, inflexible and impossible to maintain without...
Not so long ago, I showed you how to insert comments using the N() function in Excel formulas. But can you get the comment out of that cell using a function, reader Dobrin asks? Thank you for this article - the N() funtion is very usefull and I use it often in my...
A tri-colour in Excel? Is feider linn. Contextures blog did it using a column chart, removing the gaps between bars and customising colours. A simple project with useful techniques thrown in. Happy St Patrick's Day from Business Brains. How To Make the...
Question: How to make a PivotTable automatically select new data as it is added to the source? Answer: Follow these steps - or even just the first one - to see your data source extend automatically for any PivotTable Step 1 - Convert your Source Data into a Table...
Wonderful question from a very recent Time Management using Outlook course held on-site. Question: How can I make sure that I never forget an attachment when I send an email using Outlook? Answer: If you use Outlook 2013, the feature is built into the programme so all...
No better time to learn about the weird and wonderful: how Excel measures stuff. If you have ever tried to fit your spreadsheet columns to fit exact measurements in inches or centimetres and have failed before, this short post explains measurement units in Excel and...