Excel

Excel:  Print Right

Excel: Print Right

  If you’re like me, you have a litany of Excel printing horror stories to tell. It seems that when things go wrong when printing an Excel worksheet they never go wrong by halves – it is usually a spectacular disaster. Hit the big red switch Well your printer probably doesn’t have a big red [...]

5 Cool Excel Chart Tips

5 Cool Excel Chart Tips

See how to tame unruly data by: – using multiple axes in Excel – adding pictures to charts – resize chart bars – add data to charts -deal with missing data Creating a basic chart in Excel is simple but when your data requires just a little bit extra attention to look its best, you’ll [...]

7 Cool ‘Must Know’ Excel functions

7 Cool ‘Must Know’ Excel functions

At its heart, Excel 2010 is a great tool for making calculations and Excel functions are the key to getting the work done fast. Here I’ll show you some of the most effective functions that Excel has to help you make calculations using worksheet data. 1          Calculating workdays To calculate the number of days between [...]

Word

Hyperlinks in Word

Hyperlinks in Word

Consider the situation where you are working on a Word document and you want to refer someone to an Excel worksheet. Instead of telling them where to find that worksheet it would be much more useful to give them a link to it that they could click to open it. You can do this using [...]

ClipArt in Office 2007 and 2010

ClipArt in Office 2007 and 2010

How to use the Microsoft Clip Organizer and some handy things to add to it. Since the early days of Microsoft Office, there has always been a tool for finding and using clip art in your documents, worksheets and presentations. While the clip art that comes with the Microsoft Office suite may not be to [...]

Customizing the Office 2010 Ribbon

Customizing the Office 2010 Ribbon

There is a lot to love about Office 2010 and one of its new features is the ability to customize the Ribbon. This lets you make the Ribbon looks the way you want it to look rather than how Microsoft thinks it should look. Here, I’ll show you how to get started customizing the Ribbon [...]

iPad

7 best draw, sketch and paint iPad apps for artists and designers

7 best draw, sketch and paint iPad apps for artists and designers

I’ve been trawling the iPad store to find cool apps for designers who want to draw, paint, sketch and generally do stuff on their iPads. I’ve also read a lot and seen way too many reviewers who think it is ok to pay  $9.99 for an app with one brush, no layers and no eraser. [...]

PowerPoint

Create Custom Presentations with pptPlex

Create Custom Presentations with pptPlex

Learn how to use the free pptPlex add-in to create custom PowerPoint presentations. pptPlex is a cool free add-in for PowerPoint that lets you make presentations that don’t follow a linear path. You can find the download for PowerPoint 2007 & 2010 at http://www.microsoft.com/en-us/download/details.aspx?id=28558. Here I’ll show you how to get started configuring and presenting [...]

Visual Basic

VB: Rock Paper Scissors – Part 2

VB: Rock Paper Scissors – Part 2

Here’s how to add additional functionality to the VB Rock Paper Scissors game. In an earlier post I showed you how to use Visual Basic to create the bare bones of a Rock Paper Scissors game. Now I’ll show you how to add some additional features to it. When you start adding things to a [...]

Visual Basic 2010: Rock Paper Scissors

Visual Basic 2010: Rock Paper Scissors

Learn some simple game logic and find out how to create this simple game. When you’re learning to program in a language like Visual Basic one interesting way to extend your skills is to recreate a game as a VB program. Here I’ll discuss the game: Rock Paper Scissors. I’ll discuss the logic that you [...]

Create a Visual Basic Radio Player

Create a Visual Basic Radio Player

Learn how to create your own custom radio player with the free download version of Visual Basic 2010. There are lots of fun applications that you can create with Microsoft Visual Basic 2010 utilizing the features that are built into Windows. Here I’ll show you how to create a radio player that plays your favourite [...]

Other Articles

Visual Basic Project

Visual Basic Project

| May 7, 2012 | 0 Comments

Learn how to create an alarm application for your system tray. One of the cool things about Visual Basic is that it’s very easy to create quite sophisticated looking applications with only a few lines of code. Here I’ll show you how to create a program that sits in your system tray and runs a [...]

Continue Reading

Create a Doodle Program – part 3

Create a Doodle Program – part 3

| March 1, 2012 | 0 Comments

In this final part of the series on creating a doodle application in Visual Basic I’ll show you how to add functionality in the form of ellipses and rectangles which can be created as filled or unfilled shapes. I’ll also show you how to add separate line colour and fill colour options and a two [...]

Continue Reading

Create a Doodle Program part – 2

Create a Doodle Program part – 2

| March 1, 2012 | 2 Comments

Finished part 1? Now it’s time to add some extra functionality to your Visual Basic Doodler application. In the previous article in this series we created a simple doodle application so you could draw lines in a picture box. This time I’ll show you how to add extra functions to the project including a save [...]

Continue Reading