Monthly Archives: May 2012

To quickly close all Microsoft Excel workbooks

You may have been working on several Microsoft Excel workbooks, but have now finished for the day. You want to close all open workbooks, saving the changes in each of them. With the workbooks open, hold down the Shift key … Continue reading

Posted in Microsoft Excel, Microsoft Excel 2003, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , | 1 Comment

Microsoft Word – spreading heading across newspaper style columns

You may want to use newspaper-style columns in a document, but want a heading that spans across all columns. Start by typing in the heading to go across all columns. Press the Enter key. In Microsoft Word 2007 upwards, on … Continue reading

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

Microsoft Project – copying the Timeline to other applications

If you have created a timeline in Project 2010, Project 2013 or Project 2016, you may want to copy it to another Microsoft application, for example, to a Word document as part of a report or to a PowerPoint presentation … Continue reading

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

Microsoft Project – adding tasks to the Timeline

The Timeline was new to Project 2010 and by default appears above your Gantt chart view. The Timeline shows the start and finish dares for the project, but if you want tasks displayed on the timeline, you need to add … Continue reading

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

Changing column widths of all Excel columns

When you have entered data into Microsoft Excel, you may want to change all column widths to exactly fit the width of the largest entry in each column; in some cases, this may make columns narrower and help when it … 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

Seven principles of negotiation

The seven principles common to all negotiations are: Two or more parties are involved needing each other’s involvement in order to reach some desired outcome. There has to be some common interest, either in the subject matter of the negotiation or in the context … Continue reading

Posted in Negotiating and Influencing Skills | Tagged , | Leave a comment

Inserting multiple rows or columns into a Microsoft Excel worksheet

You may want to add some extra rows into a spreadsheet. Click on the row number beneath where you want to insert the rows. Drag down with the mouse to select the same number of rows as you want inserting … 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 – splitting a table

You may have created one long table, which you would now like to split into two. To do so, position the cursor in the table in the first cell to be placed in the second table. If working in Microsoft … 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

Microsoft Project 2010, 2013, 2016 – setting default to auto-scheduling

In earlier versions of Microsoft Project, all tasks were auto-scheduled by default. In Microsoft Project 2010 this changed, so that by default all new tasks are scheduled manually. If you are used to the older versions, you may prefer to … Continue reading

Posted in Microsoft Project, Microsoft Project 2010, Microsoft Project 2013, Microsoft Project 2016 | Tagged , , | 4 Comments

Creating a Gantt Chart using Microsoft Excel – part 2

In a recent blog, I demonstrated how to create a Gantt chart using conditional formatting in Microsoft Excel. In this blog, I demonstrate creating a Gantt chart in Microsoft Excel using a stacked bar chart. In columns A, B and … Continue reading

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