- Home
- Tutorials
Photo Editing Tutorial 2 : Color and Black and White
In this, the second series of photo editing posts, we will take an image created in the last series of a hand on a beach holding an apple. Then we will make the whole image black and white except for the apple. Our before and after photos look like this. This is a style […]
Continue readingWingdings
I receive a lot of requests for help with setting up files/charts (most often in Excel). Occasionally I think people try to challenge me on purpose by setting certain restrictions. In one case, I was given a table of weekly numbers and asked to visually highlight if one week was higher or lower than the […]
Continue readingPhoto Editing Tutorial : Finishing Touches
The Story So Far…. Note – This is not the first post in this series relating to a photo editing tutorial. If you haven’t already done so, please read the earlier posts below: Introduction Lasso, Transparency & Layers Zoom & Erase In this first example, have taken a photo of my arm holding and apple […]
Continue readingStyles In Word
Note : This applies to MS Word 2010 and later. For earlier versions of Word the steps involved maybe different. Styles in Word allow you to quickly format sections of your document – headings, subheadings, paragraphs, indents, etc. When putting together a large document, I use the Styles mostly to highlight headings and subheadings. One […]
Continue readingThe Scroll Button
If you are using a mouse with your computer/laptop you may already be familiar with the left button and the right button, but do you use the middle button much? Talking to different people at different levels of computer skill, I was surprised by the number that did not use the middle button, or know […]
Continue readingIntroduction To Photo Editing
I have played guitar with Metallica, met the last 6 US presidents and walked on the moon. Don’t believe me? What if I could show you photographic evidence? One of the most frequent tasks I’m asked to work on involve photo editing. These images can then be used for invitations, posters, t-shirts, place mats, mugs, […]
Continue readingDesktop Tidy
This may be a familiar image, you computer desktop full of icons, folder, files and shortcuts. How often have we searched through rows of icons looking for one file/folder/shortcut? How many times have we sat at someone else’s desk while they searched through the same organised clutter? Ideally, the desktop would only show what is […]
Continue readingContext Menu Shortcut
This tip is aimed at people who already use keyboard shortcuts or are looking to try them out. You may already have noticed that when you use the right-click button on your mouse you get a different menu on screen depending on what you are clicking on. This is a context menu, if you right-click […]
Continue readingThe Alt Key Shortcuts
This tip is aimed at those of you who use keyboard shortcuts, or are interested in trying them out. My example below uses Excel 2010, but can be applied to other Office 2010 programs Whether they use them or not, a lot of people are at least aware of some of the basic “Ctrl+” shortcuts: […]
Continue readingPowerPoint Tip
PowerPoint is a presentation software program that is part of the Office package. It comes with a host of options for creating professional presentations. However, in my experience it is a program that people aren’t as comfortable with as they are with others like Excel, Word, etc. I have sat with a lot of people […]
Continue readingQuick Access Toolbar
The Quick Access Toolbar (QAT) is a customizable toolbar that appears at the top of your screen in MS Office (Excel, Word, etc) versions 2007 and later. In older versions, it was possible to create your own toolbar. The toolbar allows you to add the commands that you use most frequently so that they always […]
Continue readingCombining Charts In Excel
One of the most common questions I get asked in relation to charts is how to combine two charts on one. The chart below shows actual sales numbers and target sales numbers. This is a common comparison of targets or expected numbers against actuals. The values can all be seen, the target numbers are blue […]
Continue reading& Let Us Begin! – Demonstrating Excel Logic
I am asked more and more often to give intermediate-advanced Excel classes. Aimed at people who are relatively comfortable with Excel and ready to go to the next level. Most of these students have made attempts at figuring out new formulae themselves, and usually ended up a bit frustrated! For the last year, I have […]
Continue reading