MS Office blogs
Showing blogs 81-100 (out of 102)
Have you ever been frustrated when you can't find a suitable field for entering the data you want in a Microsoft Project plan? Well why not customise your own field and enter anything from simple text, to drop down lists, to complex calculations and even graphical indicators!
PowerPoint isn't all about naff transitions and clichéd effects - add a touch of class to your presentation with some bespoke animation triggers!
This isn't a comprehensive list of every short-cut key in Word - just a summary of the ones I'd consider most important.
Do your Microsoft PowerPoint presentations contain lots of pictures? Are the files taking up a lot of space and refuse to email? This short blog shows you how to compress your pictures and save lots of space, and headaches!
Setting up a pattern of working time in a Project calendar is simple enough when your week runs from Monday to Sunday, but when you have an unusual working pattern setting up the calendar is a pain! This article explains how to use VBA to create a detailed calendar at the click of a button!
Have your Baseline Taskbars ever disappeared when using the Tracking Gantt view in Microsoft Project 2010? If so, this short blog explains why!
This short blog shows how to assign short-cut keys to macros in Excel 2010, Excel 2007 and Excel 2003. So if you've written a whizzy macro in VBA and want to be able to run it with a single keystroke combination, read on!
This short blog shows how to display the Developer ribbon in Excel 2010 (it's different from Excel 2003 and Excel 2007!).
If you're not sure what the Excel Visual Basic for Applications language is, or how it can help you, this blog attempts to explain! Learn what VBA is, and how you can record macros and then replay them again and again to automate work in Excel.
Are you bored of all your inserted pictures appearing in a rectangle in Microsoft Publisher? Read this blog to see how you can create a much more interesting frame shape for any picture you insert!
One of the most time-consuming things in Microsoft Visio is continually formatting shapes in the same way every time you create a new diagram. If only you knew how to create a custom collection of shapes that you could reuse in every diagram you create… Read this article to find out how to do exactly that!
This blog series shows you how to use some advanced drawing techniques in Microsoft PowerPoint to create a set jigsaw puzzle shapes. If you've ever wondered how pedantic a person can get about aligning objects in PowerPoint, read this article to find out!
Have you ever sat at a trade show or business exhibition clicking the mouse button every ten seconds to advance your company's promotional PowerPoint presentation? No, of course you haven't! And neither has anybody else, because they know how to create a presentation that runs itself. Read on to find out how you can do the same.
Adding basic data labels to a chart can be done without using any programming code. This blog, however, shows you how to fine-tune Excel chart labels using VBA (Visual Basic for Applications) macros.
Have you ever wondered how to change the items that appear in the legend when you print a Gantt Chart in MS Project? Did you even know that you could?! It isn't the most intuitive method, but this blog shows you how to apply a little more control to your printed Gantt charts.
Formatting Gantt Charts in Microsoft Project is a time-consuming process. This blog series explains how to create task bars that format themselves as you change information in the table.
Do your macros keep falling over due to users renaming their worksheets in Excel? Read this article to find out if sheet codenames could be the solution you need.
Adding a first or default item to a list control which gets its data from a table can be tricky. This blog gives an elegant solution using UNION queries, which works equally well for ASP.NET dropdown controls, Windows Forms dropdowns or Access combo boxes.
When you collapse a group of tasks in a Microsoft Project schedule you lose the ability to see the detail of when individual tasks start and finish. The solution is to roll up your subtasks so that you can see them even when the task group has been collapsed.
Fed up with hunting around on the ribbon for commands? This article shows you a quick way of changing task types in Project 2010.