Unable to Allow Comments

Unfortunately I have had to disable comments on this blog, due to the large number of spam comments that have been hitting my website.  I will open then again at some later stage, but unfortunately for now, there is no longer any opportunity to post comments.  My apologies :-).

| April 23rd, 2013 | Posted in Uncategorized |

 

Get the most from Excel’s AutoComplete

The AutoComplete feature anticipates the value you might be entering in a list by comparing it with previous entries in a column.  Let’s say I am typing a list and it looks something like this:

apples
oranges
pears
lemons
oranges

Because I had previously typed the word ‘oranges’, as if I started typing ‘oranges’ again (in fact as soon as I type the ‘o’), it will prompt me with the entire word. This is courtesy of the AutoComplete feature which recognizes input based on what  was typed previously.  If you wish to accept the entry simply press the Enter key.  If you don’t want the AutoComplete value being offered, just keep typing the new value. This feature’s only requirement is that the values be contiguous (e.g. one after another in the list, there cannot be any breaks/empty cells).

AutoComplete Tip 2.

Instead of allowing AutoComplete to finish a value, you can choose to be offered a pick list which is based on the previous values in a single column. Using the same example as above of fruit, you would simply go to the next empty cell and then hold down the ALT key and press the down cursor arrow.  This will display a pick list of values (items) based on what you have previously typed.

Autocomplete

Simply click on the entry you would like to use and then press either the Tab or Enter key to move on and keep working.

Tags: ,
| December 6th, 2017 | Posted in Excel, Microsoft Office |

 

Wrangling MS PowerPoint Objects

cats
When you have many objects (e.g. shapes, text boxes, pictures, etc) on a PowerPoint slide it is easy to lose track of them, especially if they are layered or grouped. To quickly find one of your objects just press the tab key and keep pressing – this will cycle through all the objects on a slide and you simply stop when you reach the object you wish to select.

Tags: , ,
| September 15th, 2017 | Posted in Microsoft Office, PowerPoint |

 

Google Chrome and Internet Handy Hints

zoomTip 1 Google Chrome only:
Pressing Ctrl, Shift and B keys will toggle the browser’s Bookmarks Bar in and out of view.  Any site you’ve saved into the Bookmarks Bar folder will appear along the top of the screen and when you repeat this key combination it will hide them.

Tip 2 Chrome and Internet Explorer: 
Did you know that pressing the F11 key will change Chrome into full-screen mode, hiding all the regular browser elements and everything else on your screen?  (useful to know if you’ve accidentally pressed the F11!!).  Extra tip – F11 works the same way in Internet Explorer ;-).

Tip 3 Chrome and Internet Explorer – I like to zoom it zoom it
  If you hold down the Ctrl  key and the plus + on the keyboard will zoom out (make the webpage and its elements grow bigger), while Ctrl key and minus – on the keyboard will zoom in (making the webpage and its elements smaller).

Need to go back to the default 100% size? Easy-peasy, just hold down the Ctrl key and press the zero (0) to snap you back to the default view.

 

Tags: , , ,
| August 18th, 2017 | Posted in Google, Internet Explorer |

 

Google Chrome Handy Hints

As many of us are now using Google Chrome , here’s a handful of hints that may be useful when using this internet browser:google chormeTip 1: Quickly open closed tabs
If you have closed one of your tabs (e.g. containing a website you have a visited) and then need to get back their quick, simply hold down the Ctrl & Shift keys and then press the letter T.
– Voila, the last closed tab re-opens!

Repeat the keystroke to re-open other tabs in the order they were closed.

Tip 2: New searches, new tabs
Try pressing Alt-Enter after you type a search term or URL into the Chrome search bar – that’ll cause your results to open in a new tab instead of in your current tab.

Tip 3: Easily moving around web pages
You may already know that pressing the spacebar will scroll down one screen length on any web page… but did you know that pressing the Shift key and spacebar together will scroll up in the same manner? Works in Google Chrome or Internet Explorer!

 

Tags: , ,
| August 3rd, 2017 | Posted in Google |

 

Searching a Webpage in Chrome

These steps take you through how to search for a word or phrase within a webpage when you are using the Chrome Browser.

1. Open a webpage in Chrome.

2. In the top right click the More button.

Websearch

3. Click on Find…

3. Type your search term in the bar that appears in the top right and all matches will be highlighted. Use the up and down arrows in the search bar to move to the next found term.

Hot Tip: would you like to use the keyboard instead?

Hold down the Ctrl key and press F on your keyboard!

Tags: ,
| April 27th, 2017 | Posted in Google |

 

Zooming in or out on webpages

Here are two very simple keyboard shortcuts you can use if you want to make text or images on a webpage larger (zoom in), or smaller (zoom out):

  • Make everything larger by holding down the Ctrl key and pressing the + on the keyboard.
  • Make everything smaller by holding down the Ctrl key and pressing the on the keyboard.

This works equally well in Internet Explorer or Google Chrome!

Tags: , , ,
| April 26th, 2017 | Posted in Google, Internet Explorer |

 

Google G Suite Rollout

google teamI am currently working on a large project to transition from Microsoft Office to Google G Suite.  In the first phase we are rolling out Gmail, Calendar and Hangouts to replace Outlook and Lync.  This is happening across the two retail groups Red Energy and Lumo Energy and the project went live on 6th March.

Later in the year we will replace the rest of MS Office with the equivalent offerings from Google of Docs, Sheets and Slides.  While this is first and foremost a technology project, the change piece is huge and makes for a challenging and interesting project to be involved in.  I am blessed to work with a fantastic project team, headed by Mandy Bird and a couple of fantastic BAs along with two very strong L&D teams at both Red and Lumo.

Google team 2

 

Tags: ,
| March 16th, 2017 | Posted in Google |

 

Using Word to type anywhere on a page

Microsoft Word allows you to easily start typing anywhere on a page and I must admit it’s a simple tip I forget to use myself. Firstly be sure you are in Print Layout mode (click the View Menu and then click the Print Layout icon). The beauty of this function is that you don’t have to start at the top of the page or put in any blank lines if for example you want to start typing at the bottom of the page – instead Word will automatically fill in the space above the cursor with blank lines.

The key to getting it to work easily is to move your mouse to where you want to type, then holding the mouse still and ensuring you see the I-beam before you click the left mouse button. You can then easily start typing at the position where you have clicked.

Tags: ,
| June 8th, 2016 | Posted in Microsoft Office, Word |

 

Protecting your privacy on Facebook

privacy-card-3x2If your friends are using apps (for example games like Candy Crush) on Facebook, they could be giving information of yours way without realising it, as people who can see your information can bring it with them when they use apps. However there is a setting you can use change to control the categories of information others can bring with them when they use apps, games and websites while Facebooking.

  1. Go to Settings on Facebook.
  2. Click on Apps.
  3. Scroll down to the box marked Apps Others Use and click on Edit.
  1. A box pops own listing the types of information (of yours) that your friends may be able to share. Deselect each option you do not wish to share, if not all of them.

Note: If you want to go a step further and stop apps or sites accessing data such as your Friends list, gender to other public information, locate the Apps, Websites and plugins box that is also under Apps, click the Edit button and select Disable Platform.  Be aware that this will disable your ability to use apps and plugins that offer to allow you to log in with your Facebook identity as well as disabling your ability to play games.

I suggest that if you are unsure of this information it would be a good idea if you take the time to read the Facebook help pages as well as doing your own Google research before changing any of the settings.

Tags: , ,
| March 28th, 2016 | Posted in Facebook |

 

Windows Keyboard Shortcuts

Some oldies but goodies for any version of Windows are:

CTRL& Shift& Esc keys will open your Task Manager

Windows key & E opens the File Explorer

Windows key and M minimises all open windows.

Ctrl key and L locks Windows.

The windows key looks like this:windows key

Tags: ,
| January 22nd, 2016 | Posted in Microsoft Windows |