Wise Owl blogs written by Andrew Gould (page 4 of 5)

Showing blogs 61-80 (out of 81)

How to Remove Duplicates from a List in Microsoft Excel

Posted by Andrew Gould on 12 October 2011

If you've ever had the tedious job of manually scrolling through a long list of data to remove the duplicate entries in Excel then this blog is for you! Discover how to hide or delete duplicated data in Excel 2003, 2007 and 2010.

Using Fractions in Microsoft Excel

Posted by Andrew Gould on 03 October 2011

If you've ever tried to enter fractions in Microsoft Excel you'll probably have become frustrated when Excel insists on converting them into dates! Read this blog to see how to prevent this from happening.

Tags:   Excel | Formatting

How To Make Part Of An Image Transparent In Microsoft PowerPoint

Posted by Andrew Gould on 19 September 2011

If you've ever inserted a company logo or other image onto a slide with a coloured background in Microsoft PowerPoint you'll probably have been really annoyed when the image looks as though it's contained in a white box. Read this blog to find out how to remove the box and make your image appear transparent.

Choosing Colours In Microsoft Office Applications

Posted by Andrew Gould on 19 September 2011

Have you ever been asked to reproduce your company's brand colours in your latest PowerPoint presentation, or wanted to use your corporate font colours in your latest Word report? This blog will show you how to pick your colours accurately in any of the standard Microsoft Office applications.

Tags:   Excel | Formatting    |    Word | Formatting

Changing Form Appearance in Access 2007 and 2010

Posted by Andrew Gould on 07 September 2011

If you've upgraded from Access 2003 to either Access 2007 or 2010 you might be wondering why your forms don't look like forms any more. Read this blog to see how to change a simple setting that will return your forms to their normal state!

Using the VLOOKUP Function in Excel to Calculate Exam Grades

Posted by Andrew Gould on 22 August 2011

The VLOOKUP function in Excel is perfect for categorising a continuous range of numbers. This topical example shows you how to calculate an exam grade based on a numerical score.

Tags:   Excel | Excel functions

Using Range Names in Excel

Posted by Andrew Gould on 22 August 2011

Did you know that you don't have to use cell references in calculations in Microsoft Excel? You can use range names to create sensible, plain English names to refer to your cells and use those in your formulae instead. Read this blog to find out how.

Tags:   Excel | Formulae

Select All The Text In A PowerPoint Presentation

Posted by Andrew Gould on 17 August 2011

Have you ever needed to change the font that you've used for a PowerPoint presentation and laboriously clicked through each slide to change it one-by-one? Well the next time you find yourself in this situation you'll be able to do this in one go. Read on to find out how.

Stop Text Changing Size in PowerPoint

Posted by Andrew Gould on 17 August 2011

Do you get annoyed when you see the font size shrinking automatically as you type text into a PowerPoint slide? Us too! Turning off the AutoFit options is an easy way to stop this from happening. This blog explains how to do exactly that in PowerPoint 2003, 2007 and 2010.

Using the Organizer in Microsoft Project

Posted by Andrew Gould on 01 August 2011

If you've ever spent time customising the same calendar or the same field every time you create a new file in Microsoft Project, you'll definitely want to know about the Organizer. This handy tool lets you copy any customised content into the Project Global template so that it will be available to every new project that you create!

Tags:   Project | Custom fields

Custom Fields in Microsoft Project

Posted by Andrew Gould on 01 August 2011

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!

Tags:   Project | Custom fields

Using VBA in Microsoft Project to Set Up Unusual Calendars

Posted by Andrew Gould on 01 July 2011

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!

Tags:   Project | Calendars, Gantt    |    Writing VBA | Other

Introduction to Visual Basic for Applications (VBA)

Posted by Andrew Gould on 01 July 2011

If you've heard people in your office talking about macros or VBA but don't understand what they mean, this blog series will make everything clear. It's an introduction to the most basic skills you'll need to start creating your own programs in any of the Microsoft Office applications.

Tags:   VBA macros | General    |    Writing VBA | Other

Creating a Picture Frame Effect for Images in Microsoft Publisher

Posted by Andrew Gould on 15 June 2011

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!

Creating Custom Stencils and Custom Shapes in Microsoft Visio

Posted by Andrew Gould on 15 June 2011

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!

Tags:   Visio | Creating diagrams    |    Visio | Shapes and stencils

How to Draw a Jigsaw Puzzle in Microsoft PowerPoint

Posted by Andrew Gould on 15 June 2011

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!

How To Create a Self-Running PowerPoint Presentation

Posted by Andrew Gould on 14 June 2011

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.

Tags:   PowerPoint | Slide shows

Adding data labels to a chart using VBA

Posted by Andrew Gould on 08 June 2011

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.

Tags:   Excel | Charts    |    Writing VBA | Other    |    VBA macros | Working with charts

Changing the Legend in a Microsoft Project Gantt Chart

Posted by Andrew Gould on 06 June 2011

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.

Conditional Formatting in Microsoft Project Gantt Charts

Posted by Andrew Gould on 01 June 2011

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.

Tags:   Project | Calendars, Gantt    |    Project | Custom fields
This page has 0 threads Add post