Author Archive: admin
Create a Doodle program – Part 1
Follow these instructions to create a doodling program in Visual Basic Express 2010. This is a VB 2010 Express Edition program that lets you to doodle onto the screen. The program starts with a small window that you can draw on by dragging with the mouse. A line is drawn between the point you [...]
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
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
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 [...]
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
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
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 [...]
Word form data to Excel
Learn how to create a form in Word and how to import its saved data into Excel. Creating a form in a Word document is one half of a data collection process. Once the form is completed, you will need to extract the data so you can do something with it. Here I will show [...]
DIY Word 2007 & 2010 Cover Pages
Helen Bradley introduces the skills you need to create your own cover pages for Word 2007 and 2010. In Word 2007 Microsoft introduced a number of dynamic elements such as Cover Pages, Headers and Footers. You can use the Cover Page tool, for example, to select from a preset list of attractively formatted document cover [...]
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. [...]