Unconscious to Conscious: The Learning Cycle

There is a great model first developed by Noel Burch which is called The Learning Cycle. This model describes four states which we move through as we learn.

The Learning Cycle - and how to adapt your management style to it
The Learning Cycle – how to adapt your management style to the states that your team will move through

Being aware of this model is important as a manager; if you’re expecting your team to learn something new then expect them to move through these states. Your management style may need to adapt depending on which state your team member is in.

I will talk through each section of the model using learning to drive a car as the example.

Unconscious Incompetence

When a child observes his/her parents driving a car, the skill seems easy. You move a steering wheel and gear stick around – how hard can that be? The child is unaware that driving a car is a very complex task that will take many months to master.

As a manager you will encounter this state whenever you have a new member of your team. They will observe their new responsibilities from a this-must-be-easy angle, and may attempt to over-simplify. Your management style should be hands on, getting involved in the process and reviewing stuff at a granular level. You also need to make sure your team member knows what your expectations are – which will help when they first attempt the task.

Conscious Incompetence

Conscious incompetence arrives when you first try to perform the activity. You are sitting in front of a steering wheel with no idea how to make the car move forward. You are still incompetent, it’s just that now you know it.

As a manager this state will present itself when your new team member is attempting the tricky activity for the first time. They will have under-estimated the requirements and may well miss targets or deadlines. Your management style should be supportive, helping them to understand what went wrong and what they could do better next time. You need to help your team member believe that they can master the skill, and that failure is part of learning. Failing is never a problem as long as you learn from it.

“Just because you fail once doesn’t mean you’re gonna fail at everything.” Marilyn Monroe

Conscious Competence

Once you have mastered the task you enter the conscious competence state. Do you remember your driving test? You are hyper-aware of every aspect of driving and every action you take is conscious. You are now competent, but you are working really hard to be so. This state is tiring.

As a manager you need to use an encouraging management style, reinforcing their performance with positive feedback. As they are hyper-aware of the task, they are also hyper-aware (and perhaps hyper-sensitive) of what you think. A little acknowledgment and feedback goes a long way in this state.

Unconscious Competence

Once you have been doing a task for a while it will become unconscious. Think how you drive a car now. Do you actively think through each action as you do it? No, your hands and feet do their work almost automatically.

As a manager you will find it rewarding when your team members enter this state. For me, it’s one of the features of a high performing team. However great leaders don’t just stop here and put their feet up. Their management style will be challenging, or even demanding. By further pushing/encouraging your team members to improve performance on the task you will start to embed a continuous improvement culture, which will make your team (and you) stand out from the crowd.

Not all learning cycles are the same length; it might be that you only spend hours or minutes moving between each state…

Summary

The Learning Cycle is a great tool to help you understand what steps your team are going to move through when learning new things. The key success factor of great managers is the ability to adjust and adapt your management style to the situation; you need to be flexible as you manage your team to their next great success.

How to be Rubbish at Presentations

The time has come: You’ve been asked to give a presentation at the next team meeting and you are dreading it. As part of the How to be Rubbish at Everything series, this article will help you understand what NOT to do.

Knowing how poor presentations come together will hopefully help you to avoid these common pitfalls. How many of these anti-tips are you currently guilty of?

Don’t plan

When you are creating a presentation, is your first action to fire up PowerPoint and start creating files? The problem with this approach is that you are not thinking about the bigger picture of your presentation. This means your focus is on the individual slides, and not the whole presentation – leading to a disjointed slideshow which does not deliver a cohesive message.

Think about why you’re giving this presentation; what outcome do you want to achieve? What are the ‘take home messages’ you want your audience to go away with? Now grab a pen and a notepad and start brainstorming slides. Think about the logical flow of the presentation and to to build this around your key messages.

This approach will ensure you get a presentation that flows well, stands up on its own and tells a story.

I’m a bit obsessed with telling stories; probably due to all the reporting I’ve done as a finance professional. I would recommend investing time in the stories that you tell in your life – make sure you define what people to think about you! My guide to How to be Rubbish at Interviews also talks about stories…

Don’t practise

Probably the second biggest reason why people give bad presentations is a lack of practice. EVERYBODY needs to practise presentations. Attempting to give the presentation without having rehearsed your story will make you sound like someone that doesn’t know what’s happening in the slides.

People are generally on your side when you stand up to present. However people switch off and get annoyed fairly quickly if you look unprepared and under-rehearsed. Perhaps another guide to “How to annoy people while giving presentations” would be good here (not really)…

Don’t spell and grammar check

Madness. Not spell checking and reading through for grammar? Madness. Most office packages out there do a pretty good job of finding the stinkers, but you’ve still got to engage your brain and make sure you haven’t used the wrong version of there/their/they’re. Don’t forget the title too! Our brains are good at overlooking stuff, and slide headings are a prime example of this.

Get someone else to read through the slides who wasn’t involved in producing them, they will spot little typos and errors fairly quickly. If you’re blessed with a team then great, delegate, otherwise work on your team-mates or colleagues (get your influencing skills up to speed right?)

Include more (or less) than one slide per minute

How long do you have to talk for? 30 minutes? Rule of thumb – one slide per minute, so 30 slides. This is a guide, your particular industry or specialty may call for more or less, but use this as a starting point and scale from there.

Turning up with more slides means you won’t talk about everything that you’ve planned, and turning up with less will mean you don’t fill the time.

Use lots of flashy graphics

When I created my first Powerpoint presentation I was really excited by all the shiny buttons and flashy graphics. I feel sorry for all those people that had to sit through my presentations (if you saw me present anything from 1999 to 2002 this applies). Correctly used graphics can have a great impact, incorrectly used they can ruin your flow. Have you ever seen someone click through 20 bullet points on a slide? Aside from the repetitive strain injury and the fact that they have too much on the slide, this just looks lame.

Rule of thumb? Probably look to use graphics once or twice in your presentation – certainly no more than five. Think about what the impact is you wish to achieve – a revealed question answer or the punchline to a joke – and then have fun making this stand out. Don’t just whack animations on every slide.

I once saw someone present who had got the graphics totally wrong. The answers to the questions (which he wanted to reveal at the push of a button) were the only items on the screen at the beginning, totally ruining his presentation (and reputation as a speaker).

Turn up without a backup

Uh oh, you feel hot under the collar and have started to sweat. The email you sent to the PA with the presentation has been lost and you have no presentation to give! What are you going to do?

Unfortunately without a backup, there is nothing you can do (unless you turned up with handouts – see below – and will at least be able to talk through something).

Always take a backup on a USB stick. These things are ridiculously cheap these days so there’s no excuse not to have one.

Turn up without handouts

Turning up without handouts has 2 major drawbacks:

  1. If your laptop fails you’ve got nothing to talk through
  2. People like having something to make notes on and will be more engaged

Powerpoint makes it really easy to create handout notes from the print preview screen, so make sure that you use it!

If you are running a quiz at some point which has the answers on the slides, you’ll need to make a second presentation with the answers deleted out for the handouts. This does add time to your preparation, but will make you come across a lot more credible.

Don’t introduce yourself and your topic

The first one minute of any presentation is key – it is then that first impressions are made. Your audience will be drawing conclusions about your presentation skills and deciding whether or not to be engaged in your content. So launching into the first slide at 100 miles-per-hour will seriously dent your chances of appearing like a great presenter.

In your preparation, spend some time on your introduction. Make sure you say:

  • Who you are
  • What you’re talking about (briefly)
  • Why you’re qualified to speak about this (don’t brag though)

Even if most people know who you are, this will help set the mood and expectations of the audience. Plus you’ve ‘broken the ice’ if you’re nervous and hopefully have built up some momentum.

Let nerves get the better of you

Talking of nerves, this is one area that can seem hard to overcome. If you find presenting about as appealing as a dentist appointment then there really is only one way to overcome this: Do more presentations.

Ask your boss for help with this, he/she should be able to find some low-key, low-risk opportunities for you to present. By doing a few of these presentations you can get a feel for presenting and start to deal with your nerves. I would never recommend drinking alcohol as a way to cover up nerves. This is a short-term fix that may make you feel better, but will seriously impact your ability to deliver.

Before I started working in finance I worked as a professional musician. I played a few instruments but also sang lead vocals. The very first time I was being paid to sing at a function I was very nervous; thankfully I had prepared well and once I had nailed a few tracks things got easier. 50 gigs later and the prospect of singing was no longer a problem for me.

Read the slide out word for word

You’ve seen people do this before I assume? A slide comes up with loads of text and they start to read every line out, word-for-word. Somewhere deep within you a yawn begins that it impossible to keep from spilling up out of your mouth!

Just don’t do this – each slide has it’s own story and you need to make sure you know what this is…

Do not engage the audience

Audience engagement is a key factor in the success of your presentation. Rubbish presentations are those that go on-and-on about boring topics with no chance to ask questions or interact with the speaker. There are a couple of ways to engage your audience that are worth mentioning.

Allowing interaction with your content is the best way to ensure engagement. Asking questions, mini-quizzes, straw-poll hand raises, getting people to stand up – all these are great ways to keep people’s attention and engagement.

Use eye contact – attempt to look your audience in-the-eye as you progress through and they will feel like you are speaking directly to them. Sometimes people don’t want to return your gaze, but keep tracking through the crowd as you speak and looking directly at people.

It is important to face the audience, even if the room is not set up well (sometimes the laptop stand is facing sideways, or you have to stand to the side of the audience.)

Summary

I hope you now know what it takes to be truly rubbish at presentations. Make sure you plan, practice and deliver great presentations in the future by NOT following any of these tips…

If you’ve enjoyed this article, why not have a look at some of the other “How to be Rubbish at Everything” articles here.

I have pulled together a simple checklist that you can use to see which of these tips you are following – just click the image link below to bring up a printable PDF.

How to be rubbish at presentations check list

SMART objectives

Most people who work have some form of official objectives that they sign up to. These will be used to measure their performance, and there may be performance bonuses which are linked to these.

A well known model to help you to create better objectives is the SMART framework, which stands for Specific, Measurable, Achievable, Relevant and Time bound.

Objectives created under this framework are good because they remove ambiguity from the objective, while allowing a measurement framework to be developed for the objective.

SMART Objectives - how to design better objectives

Specific

Specific objectives will say exactly what you need to deliver in the appropriate level of detail.

Measurable

Good objectives are measurable and allow allow a qualitative or quantitative performance measurement to be made.

Achievable

Stretching yourself to achieve great things is wonderful, but make sure you the objective is bound by reality. Unrealistic objectives will make you fail.

Relevant

Objectives need to deliver outcomes that mean something. Achievement of your objective should go some way toward delivering your companies (or your own) priorities.

Time Bound

Finally, a great objective will have a timeframe; when will you complete this task.

Competency based interview: The STARE framework

Competency based interview questions are the hardest type to answer because you need to provide specific examples of behaviours or skills. Luckily there is a great tool you can use to frame answers that will massively help you to succeed at these. This tool is the STAR framework, however I’m going to add an ‘E’ at the end and call it the STARE framework from here.

The way to use this framework is to talk through your answer in this order – i.e. discuss the situation, then your required task, then describe your actions, then explain the result, then evaluate how you performed. It’s a tough skill, but one that can improve greatly with even the smallest amount of practice.

You are telling a story when answering competency based questions in interviews – make sure your examples are engaging and flow nicely. Even if the interviewer does not recognise that you are using the framework they will appreciate the structured answer.

Don’t overtly use this framework – i.e. don’t say “using the STAR framework I’d like to answer…” or start every sentence with “Situation” or “Task”. Just let your answer flow in the order below.

STARE Framework - how to succeed at competency based interviews

S – Situation

This is the scene setting part of your story – e.g. “my boss asked me to review the last 12 months of activity our PR company has organised – important because we were feeling that we weren’t getting value for money”.

Two tips – context and conciseness. Make sure your situation is given a little context – i.e. the bigger picture. This helps your interviewers get their heads around why this situation is relevant. Also make sure you are concise – keep the situation to one or two sentences otherwise you’ll never get to what you did (the point of competency based questions).

T – Task

Task is the activity that you needed to perform – this sometimes rolls up nicely with Situation. You can see from my PR example above this is what I’ve done (boss asking me to review PR activity).

A- Action

What did you do? Not us, not we, but YOU! You need to have “I” and “me” peppered throughout your answer. What steps did you take? What language did you use?

To continue the PR example above – “so I called the PR company and said that I was worried that we weren’t getting value for money – could they provide me with a list of their activities over the last year”. From this example it’s clear what you did.

R – Result

What was the specific outcome of your action? This result needs to be a worthwhile outcome when taking context into account. Continuing the PR example above – “the PR company were really shocked that I was suggesting a lack of value, immediately called my boss and complained about me. They then sent the required list through to me and my boss and offered us a 10% reduction in next years fee”.

This is now the end of the classic STAR framework – so how can you stand out from the crowd? Use my “E” – evaluate to really impress the interviewing panel.

E – Evaluate

Lots of people use STAR. To stand out from the crowd add a little evaluation to the mix – i.e. what did you learn, or what would you do differently next time? This is a really nice touch that shows your interviewer that you are always looking to improve your behaviours and skills and will leave them impressed.

I might say “The PR company weren’t very happy with me and asked my boss if they could deal directly with him next time – I’ve learnt that being pushy and direct can sometimes have some downsides. I arranged a meeting with them and smoothed it over by explaining WHY we thought there was a lack of value for money – after that they were happy to work with me”

Summary

Use the STARE framework in your next interview and it should really help you land your dream job! There’s a great book by Ceri Roderick called You’re Hired! Interview Answers: Brilliant Answers to Tough Interview Questions which you can buy from Amazon by clicking the link. It will give you some great answers that should really help in your preparation…

 

How to be Rubbish at Job Interviews

Job interviews are stressful events in your life that can make a big difference to your future. As part of the How to be Rubbish series this article is designed to help you avoid some of the common mistakes that many people make…

Don’t prepare

If you really want to fail at a job interview, the best thing you can do is turn up completely unprepared. It’s easy to spot the unprepared candidates out there (trust me!), and really sends a strong message to the interviewer about what sort of person you are.

Preparing for a job interview means researching the company, the role, and the industry, and making sure you have a coherent story about your past to talk through (see below).

Prepared candidates appear calm and credible, unprepared candidates appear flushed and flappy – which kind do you want to be?

Don’t create a story

Interviewers want to know about what you’ve been doing previously, and the best way to make your history sound crap is to make it up as you go along (AKA ad libbing – see below). Thinking carefully about turning your career and life history into a story will make you sound credible, authoritative and in control. Prepare 2 versions:

  • The elevator pitch – 30 seconds
  • The 5-minute resume/CV walkthrough

You’re trying to show interviewers that your life has not just been a series of random events that have led you to turning up at this interview. You also need to practice walking through your CV a few times which will make your story flow better when you tell it.

Don’t practice for the interview

Interviews have many different formats, but there are some key things that you can practice if you want to avoid looking like an idiot.

Practice answering questions is the most obvious form of practice – the internet is full of articles listing ‘the most common interview questions’ – look at a few of these and make sure you have practiced answering these. In my opinion it is almost criminal to not have an answer to “What is your greatest achievement?”, “Where do you want to be in 5 years time?” and “What are your strengths and weaknesses?”

These days the HR people tell us to use competency based questions, so you’d be stupid not to practice some of these. These questions require you to provide specific example of performance. Frame your answer around the STAR acronym – Situation Task Action Result and you will sound in control. The most important thing about competency based questions is that you make it clear what YOU did – so use “I” and “me”, rather than “us” and “we”.

 

Don’t dress smartly

Once I had someone turn up to an interview with me who was really trying to be rubbish. He didn’t wear a tie, turned up in jeans and looked really scruffy. My first thought was “this person must have poor levels of attention to detail” (important in finance) and set the guy up to fail. An interview is a time in your life when you need to look as good as you can – so dress to impress.

Don’t be punctual

Being punctual means arriving at the right time. For most people this means don’t be late – even 5 minutes can wreck your interview. Also don’t fall into the trap of turning up too early. I once had someone arrive one hour before scheduled and tried to move the interview forward (he didn’t get the job BTW). This crazy trick doesn’t give a good impression – it just makes you look like you don’t own a watch! I aim to arrive in the area one hour early, and then hole up in a coffee bar until 5 minutes before the interview starts – then I arrive unflustered and in control.

Create a terrible first impression

The first time someone sees you they are forming opinions about whether you would be good in their role. Give a firm (but not too firm) handshake, meet their eyes and say hello. Answer any questions they have about your journey in a polite manner, and perhaps throw in a few questions about the office you’ve just walked into (how many people work here”, etc etc). You can’t win them over in the first two minutes – so don’t try; you’ll come across as pushy and annoying. However you definitely CAN lose them in the first two minutes; make sure that your first impression is good.

Don’t look them in the eye

Eye contact is a great way to increase trust and credibility within an interview – you look far more truthful if you look someone in the eye as you talk to them. So if you want to completely screw up the opportunity, just make sure you keep your eyes downward as you talk to the interviewer. It can be quite intimidating to hold someone else’s gaze – especially if they are not smiling at you – but it’s definitely worth doing.

Slouch in your chair and have rubbish body language

Body language is key in an interview – some great tricks to do this badly include:

  • Slouch in your chair (you look lazy)
  • Fiddle with something (annoying)
  • Fold your arms in a defensive way (what is he hiding?)

Plan how you want to sit, be self-aware of what you are doing with your hands and feet – it really makes a difference.

Be overly familiar

You want the interviewer to like you right? WRONG! You want the interviewer to think that you are a good fit, and that you have the experience commensurate with the position. The interviewer is not looking for new friends. Do not shorten the interviewers name – call them exactly what they introduced themselves as. I always introduce myself as Oliver – and plenty of people I’ve interviewed call me Oli – it doesn’t leave a good impression.

You need to react to the tone of the interview by picking up cues from the interviewer. If they crack a joke early on then you can also follow suit – but if you’re not sure – tend towards being at the more formal end of the spectrum.

Swear

A great way to fail in an interview is to use ANY swear word. If I hear one in my interview it is an automatic NO decision.

Tell lies

Telling lies in an interview may feel like a good solution if you have something you want to hide – but it never is. Once you’ve laid your lie it is hard to maintain it if the interviewer starts digging around with further questions. The interview switches in your head from I need to nail this interview, to I need to back up this lie and you start to lose the interviewer.

If you do get a job by telling lies you are setting yourself up to fail. At some point in your future you will let your guard down and uncover the truth – is this how you want your boss to view you? I don’t trust liars.

Ad lib

Clearly if you haven’t prepared for the interview (see above) then most of your interview will be ad libbing. But if you have prepared some really nice sound bites and stories to share during the interview try to stick to them. If you start to ad lib around stories you will find it harder to stay on track, you’ll probably start to gabber/mutter and your interviewer will probably get bored. You’re also quite likely to offer some extra information you didn’t want them to know!

Be emotional or beg

Being emotional has its place – but that place is never a formal job interview. Crying or getting angry about your previous place of work will make the interviewer feel uncomfortable and want to exit the meeting ASAP. Maintain a healthy and professional calm throughout the interview.

Begging is also a bad idea – think of the job interview as the first part of a negotiation. If the interviewer thinks you’re desperate you might get a rubbish salary, or no job offer at all.

Be modest

An interview is a time to be proud of yourself; you have some great examples to share from your history, so tell it loud and proud. Being modest about your achievements makes it sound like someone else has done them and will quickly make your interviewer discount your answer. However being a show-off will also make your interviewer switch off – so aim to strike a balance between sharing your successes and not being too ‘up-yourself’.

Switch off once the official interview is over

That’s it – you’ve answered the last question and are walking down to reception with one of the interviewers – in the bag? NOT YET! You are still being evaluated. Stick to subjects such as your journey home or your next few weeks at work and you will not go far wrong. One candidate once tried to tell me on the way back to reception how great it was that she has bought a house at 21 – that’s really young isn’t it? The information was pointless and annoying and didn’t help her case at all…

Summary

See – it’s easy to completely screw up a job interview isn’t it? Why not download my free check-list so you can tick off the areas you are currently being rubbish in and work to eradicate them?

How to be Rubbish at Interviews Checklist

 

My Top Ten Tips for Excel 2010

Excel 2010 is a great spreadsheet program – and here are my ten tips

1. Hide the ribbon

I hate the ribbon. If you need to do anything in Excel that requires clicking through the ribbon, you’ll end up wasting loads of time clicking with your mouse (see #3 for why, and #2 for what to do instead).

2. Fill the Quick Access Toolbar with all your favourite commands

The quick access toolbar is the answer to the ribbon! All your favourite commands in one place – no matter which ribbon tab you’re on!

Follow this link for a detailed blog on how to set this up.

3. Learn the Alt Keystrokes for your Quick Access Toolbar

Replace lengthy mouse sweeps and clicks with speedy key commands! All your items on the quick access toolbar are available as key commands; just press and release the alt key and the numbers appear next to the command.

Also don’t forget the classics: control S = save, F12 = save as – and so on. If there is a key command available – then you should use it where possible.

4. Remove Duplicates

My favourite function. If you have a set of data where one or more rows repeats itself, and you want only unique rows, then this function quickly does this for you.

5. Clear all filters

Don’t you hate going through your filtered table, trying to find the columns which are filtered? There is now a function that will clear all filters for you instead!

6. Conditional formatting

Conditional formatting got good in 2010. A quick trick, try hovering over the various options with your mouse and your data previews the changes live.

7. SUMIFS

SUMIFS is like SUMIF on acid. You can choose more than one criteria to sum on. Did you know that you can also use logical operators such as * and <> (“all” and “not equal to” respectively).

8. Sparklines

Mini graphs that fit inside a cell. This a really quick way to add instant graphical context to your data.

9. Intellisense (formula autocomplete)

When you start writing out a formula, have you noticed that auto complete options come up? If you press Alt then this option gets selected. Try it now – type “=VL” and then press the alt key. Voila! VLOOKUP formula!

10. Filter by colour

Certainly one of the most popular amongst my finance colleagues. You can filter data by cell colour AND text colour!

Summary

I hope you enjoyed my top ten tips for Excel 2010. Most of the above tips will help your speed and effectiveness in using this spreadsheet tool.

The Quick Access Toolbar

Excel 2010 shipped with loads of great new features, however the one I use most is actually from their 2007 update: The Quick Access Toolbar.

In a nutshell this is a horizontal tab that runs above or below the ribbon (I prefer below) and allows the user to add common commands to the strip.

Oli's Quick Access Toolbar Setup
This is my setup for the Quick Access Toolbar. You can see that I’ve chosen to located the bar beneath the ribbon. This works for me – but you may prefer to have yours above the ribbon.

From this there are some key advantages:

  1. You can keep all your favourite commands visible – no matter what ribbon page you’re on,
  2. You can access your favourite commands as keyboard shortcuts,
  3. You can add macros to this list

This is a fantastic way to tailor Excel to your way of working. At the bottom of this post I have listed out my Quick Access Toolbar setup.

Beat the ribbon

Lots of people dislike the way Excel organises the commands using the ribbon. This means you need to click on each ribbon menu when you want to access the commands on that strip.

By ensuring all your commands are on the Quick Access Toolbar you are in control of what commands you see, and they’re present no matter what ribbon strip you’re on.

Keyboard Shortcuts

Anybody that has worked with me knows how much I love keyboard shortcuts. They allow you to minimise your mouse clicks and maximise your productivity.

The Quick Access Toolbar allocates a keyboard shortcut to each command on it. Just press and release the alt key and you’ll see a prompt which tells you what the keyboard shortcut is.

Oli's Quick Access Toolbar Keyboard Shortcuts
This is how my Quick Access Toolbar looks after I have pressed and released the Alt button. If I then press (for example) 1, I will get the command ‘Paste Values’. The macros show up as a small box surrounded by three boxes.

So this opens all excel commands to be set up as keyboard shortcuts! Neat huh?

Oli note: I wouldn’t use the Quick Access Toolbar to hold commands that already have a keyboard shortcut (e.g. Control-O is “Open”). I think that is a massive waste of space on the Quick Access Toolbar. The default commands on the Quick Access are things like ‘save’, ‘print’ and ‘undo’ – all of which are classic keyboard shortcuts (control – S, P and Z respectively). I’d lose these if I were you!

Macros and the Quick Access Toolbar

Excel unfortunately does not offer all the commands that I require as keyboard shortcuts (e.g. removing gridlines from the sheet) – so the Quick Access Toolbar can offer a solution. By adding macros to the Quick Access Toolbar you are able to fully flex Excel to meet your needs.

In order to achieve this, I have a ‘startup’ file, which opens whenever I start excel. Within this are some common macros that are accessible by all open workbooks, and are available to be stored on the Quick Access Toolbar.

Summary

For me, the Quick Access Toolbar has been a game changer. I hope you found this useful, and give the Quick Access Toolbar a try.

I’m a big fan of the ‘For Dummies’ series of books, and Excel 2010 for Dummies (available from Amazon) is no exception.

There are some other good links that are worth a look. The Microsoft Office site is always a good place for hints and tips. For an alternative view, check out Windows Secrets, which comes from a Microsoft Word perspective.

Oli’s Quick Access Toolbar Setup

Alt 1 – Paste Values
Alt 2 – Paste Formulae
Alt 3 – Macro – Format as Currency
Alt 4 – Wrap Text
Alt 5 – Fill Colour
Alt 6 – Font Colour
Alt 7 – Set Print Area
Alt 8 – Format Painter
Alt 9 – Increase Decimal
Alt 09 – Decrease Decimal
Alt 08 – Crop
Alt 07 – Autoshapes
Alt 06 – Remove Duplicates
Alt 05 – Data Validation
Alt 04 – Freeze Panes
Alt 03 – Clear Filters
Alt 02 – MacroColour Cell
Blue
Alt 01 to Alt 0H- Macros to colour cells specific colours that fit my corporate reporting needs
Alt 0I – Macro Hide Gridlines
Alt 0J – Macro Turn Off Auto Calculate
Alt 0K – Macro Turn On Auto Calculate
Alt 0L – Borders (external and internal)