What are the 56 ColorIndex colors in Excel

Excels 56 ColorIndex Colors   Color Palette Excel’s Color Palette has an index of 56 colors which can be used throughout your spreadsheet. Each of these colors in the palette is associated with a unique value in the ColorIndex. For reasons unknown, aside from the index value, Excel also recognizes the names for Colors 1 through 8 (Black, White, Red, Green, Blue, Yellow, Magenta, and Cyan).   interior ColorIndex HTML […]

image-Tip of the Day-CtrlHome-CtrlEnd Featured Image

Navigate your worksheets with ease

Navigate your worksheets with ease   Learn to easily navigate your Excel worksheets with these straightforward keyboard shortcuts.     Move straight to the very top of your Excel worksheet by pressing Ctrl+Home. Similarly, you can move to the very last cell (that contains or did contain data – far bottom right) within your Excel worksheet by pressing Ctrl+End.   There will be times when you want to navigate to […]

Quick Tip – Undo / Redo

Do you often re-type over content in a cell in Excel then realise that you shouldn’t have just done that? Excel’s Undo (Ctrl + Z) feature provides you with a quick way to reverse (i.e. undo) any changes you have made to a worksheet such as accidentally deleting data, applying incorrect formats, or moving formulas. Similarly, if you have reversed back a change, but then realise that the change should […]

image-Tip of the Day-CtrlZ-CtrlY Featured Image

image-Tip of the Day-CtrlS-F12 Featured Image

Quick Tip – Save Regularly

Ever had one of those moments when you have been working hard all day on a spreadsheet and your boss/client needs it by close of business and just as you are tidying things up and just about to hit the save button and… whoosh – something totally unexpected happens and your computer loses power or shuts down or (insert multiple other scenarios here…) and “Arghhhhh!!!!” – you have lost all […]

Quick Tip – Copy and Paste

Needing to increase your productivity, don’t take your hands off of the keyboard when you need to copy and paste data within your spreadsheets, simply use Ctrl + C to copy the data in your selected cell(s) and Ctrl + V to paste it to the destination cell.   Continue the Discussion Continue the discussion and leave a comment below – Do you have a favourite productivity tip you would […]

image-Tip of the Day-CtrlC-CtrlV Featured Image

Back To The Future

Back to the Future.   Photo: © http://www.backtothefuture.com/   Wednesday, 21st October, marks the long-awaited day when Marty McFly and Doc Brown traveled to in Back to the Future Part II.   While the world may look a little different to that denoted in the 1989 film (why don’t we all have hover boards or cars that can fly??), what do you think the world will look like in another […]

Don’t Wait – The Time will Never be Right

Don’t Wait – The Time will Never be Right.   A great quote from Napolean Hill… With a little tweak by us at the end…   If you are waiting for that perfect moment, it will never happen and you’ll end up spending all your time waiting…   So take action. Don’t put it off any longer. Jump on in and start learning Excel today!!   Click here to start […]

image-Don't Wait. The Time will Never be Right - Featured Image