ASP.NET is great at server-side processing, but how can you refer to ASP.NET web server controls at the client? The answer is to use the new(ish) ClientIdMode property to fix the controls' names.

The InputBox function in Visual Basic for Applications allows you to get - as the name suggests - input from the user. This blog shows how to use it!

This blog is part of our Excel macros online training series.

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.

The MsgBox command in Visual Basic for Applications allows you to display basic messages, but you can also make it prettier, and even use it to ask questions or display multiple-line messages! Read on to find out more about this versatile VBA command.

This blog is part of our Excel macros online training series.

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.

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.

With the introduction of the ListView data control in ASP.NET 3.5, there are now 4 separate tools for displaying multiple rows of data in ASP.NET. Which one is best - GridView, Repeater, DataList or ListView?

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!

This blog explains the nuts and bolts of Excel VBA variables, including how to declare them, how to set their scope and all sorts of other tips and tricks. The blog also covers constants in Excel macros.

This blog is part of our Excel macros online training series.

There are a bewildering array (excuse the pun) of data storage structures available to you in Visual Basic. Choose from arrays, ArrayLists, SortedLists, Dictionaries, HashTables, Lists and DataTables, among others. This blog gives an example of each type of structure, and benchmarks them to show which perform best and worst.

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.

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.

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.

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.

Use this free online training in Excel Visual Basic for Applications (VBA) to learn how to program macros within Excel. The tutorial covers everything from basic recording through to creating classes - something for everyone!

This blog shows the various techniques within Excel Visual Basic for moving around and selecting cells relative to the active cell or selection. The blog includes a discussion of the Offset, End, Resize, Range, EntireRow, EntireColumn and CurrentRegion methods.

This blog is part of our Excel macros online training series.

This blog gives the various possible ways to select cells, ranges, columns and rows using Visual Basic for Applications in Excel. Useful for the VBA newbie, but even gurus might find one or two commands they'd missed!

This blog is part of our Excel macros online training series.

You can change the fill colour of data series in Reporting Services in a number of different ways, as explained in this article - but none of them allows you to set gradient or other effects. This blog is a rare appeal for help!

Visual Studio is a great tool for developing websites using ASP.NET - it can be made even greater by tweaking some default settings. Use this blog to change the default start-up options, assign a navigate backward key, insert attribute quote marks and open pages in HTML view by default.

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!

This blog is part of a complete guide to customising Microsoft Project.