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)
