Category Archives: Office

Home »  Office

This was driving me bonkers since a few weeks. I know the only constant in the world is the quality of MS products, and this proofs the case once more. However its a preview and I have good faith that maybe it will be fixed before the final or latest in SP2 or 3 😉 Update 13.03.2013 it appears this has not been fixed in the final release and I wonder if this will be fixed ever. I added a few screenshot to make it clearer where to look for the issue in case it’s not the Abbyy Finereader. Issue: Word or Excel 2013 crash or close after start. Windows 7 x67, Abbyy Finereader installed Possible solution: Do you have by any chance Abbyy Finereader installed. If so then I suggest you do the following for each Application (Word and Excel). 1. Start Word (or Excel) in safe mode. Hit […]

Some Teams are working either 7 days a week or maybe you need a 24×7 coverage in planning for a support team. Per default Project has a 5×8 hours weeks. This describes the easiest way to change to work 16 hours over the weekend. What do I have?       I want to show and calculate the weekend working days:             1. Open a new Project in MS Project 2. Goto “Tools” -> “Change Working time” In the “For calendar” “Standard (Project Calendar) you see the weekends grey marked as non working days.   Now the easiest way is to go to “work weeks” -> “Details” -> and change the Saturday and Sunday to work from xx:00 – xx:00   See the result straight after clicking “OK”   No related posts.

Excel 2007 – Create Custom Pie Chart (For Example With Horizontal Data) 1) To Start off, you have a table looking something like this. 2) Goto Ribbon “Insert” – in Charts Bar select “Pie Chart” and choose the pie chart of your choice. We can and will change the layout later. 3) Right click in the empty new chart field and click “select data” 4) In the “Select Data Source” Window click on “Add” 5) In the “Edit Series” Window – “Series Values:” remove “={1}” and select firstly the row with the data you want to report on. Just select the data cells not the tile. (marked with RED in the screenshot) Afterwards click on the “Series Name” and select the title of the data ie. the title of the graph. (marked with BLUE in the screenshot) Click OK afterwards. 6) Back to the “Select Data Source” Window click on “Edit” […]

This task was so easy that I couldn’t find it in the first place. Condition is, I don’t want to remove duplicate cells or rows because I like to see first what is duplicate to delete myself. Under “Data” there is a “Remove Duplicate” command which deletes my duplicates. And that’s what I don’t want to archive.   Plan B: Highlight my duplicate Cells: 1. Select the columns or rows where you want to find the duplicate cells. 2. Go to the “Home” Tab and click on “Conditional Formatting” -> “Highlight Cells Rules” -> “Duplicate Values” 3. In the “Duplicate cells that contain” pop-up select “Duplicate” and the highlight color.  And don’t forget “OK”   There you go. Related posts: Excel 2007 – Create Custom Pie Chart (For Example With Horizontal Data)

%d bloggers like this: