- Home
- tips and tricks
How to auto fill sequential letters in Excel
This week I was asked how to auto-fill sequential letters in Excel. What do I mean by this? If you type 1 in a cell and drag it down Excel can populate the cells with sequential numbers (2, 3, 4, 5, 6, 7, 8, etc). A user needed a list of sequential letters (a, b, […]
Continue readingBrackets And Commas in Excel
I am regularly asked for help with Excel files where people don’t understand some of the formulas used. In some cases the person is just not familiar with the formulas but there are often times when the person understands the individual formulas but can’t understand what they see onscreen because several formulas are used together. […]
Continue readingPhoto Editing Tutorial 3 : Zombie
This is the third in the series of photo editing tutorials. This time, we will take an image of a head and transform it to a zombie. In the above image I have put the end result side by side with the original image to show the difference. There are many ways of achieving […]
Continue readingHome Keys
One version of what “touch typing” is, is typing without needing to look at the keys. A typist knows their position on the keyboard from muscle memory alone. Usually, touch typing involves placing the eight fingers across the ‘home row’. The home row keys are in the middle row and are the letters “a-s-d-f” for […]
Continue readingPhoto Editing Tutorial 2 : Color and Black And White Part 2
The Story So Far If you have not already seen it, refer to the first part of this tutorial series which can be found here. You will need to know the basics of layers and zooming and erasing before changing the color image below to the image below that which is black and white, but […]
Continue readingPhoto 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 readingNavigating Tabs Shortcut
This tip is aimed at those of you who use keyboard shortcuts, or are interested in trying them out. A lot of people may already be familiar with using the Ctrl key and a lettered key for shortcuts (Ctrl+B for Bold, Ctrl+I for Italics, etc.), another really useful Ctrl shortcut is Ctrl+PgUp/PgDn. Combining the Ctrl […]
Continue readingPhoto Editing Tutorial : Zoom & Erase
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 In this first example, over the next couple of posts, we will be taking a photo of […]
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 readingPhoto Editing Tutorial : Lasso, Transparency and Layers
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 post below: Introduction In this first example, over the next couple of posts, we will be taking a photo of my arm holding and […]
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 reading