Training You to Excel
Here are the steps to follow for this lesson:
Here are the steps to follow in this lesson:
Here are the steps to follow in this lesson:
Here are the steps to follow in this lesson:
Here are the steps to follow in this lesson:
Here are the steps to follow in this lesson:
Our normal rate of speech – the number of words per minute (wpm) that we use – is between 120 and 150 wpm. When we are nervous or excited, we speak faster and our wpm count increases. The converse applies when we are tired or when we speak more deliberately – we use fewer wpm.
My normal wpm count is between 135 and 160. What is yours? If you don’t know, how can you find out? And why does it matter? Here’s why:
Speaking -live – is much more difficult than writing, in my opinion. In order to be an effective speaker you must be aware of how fast or how slow you speak. It is your responsibility to make sure that your audience understands what you are saying. Your audience must grasp your ideas as you present them – in real time. The first time!
When you write, you can go back and edit your thoughts. Rewrite your sentences before you publish your article. When you speak, you do not have that luxury. You can not re-do your spoken remarks when they are delivered live.
And when you speak, your voice must come alive. You voice must grab and keep your audiences attention. You need good vocal energy. You need to project authority and authenticity if you want your audience to stay tuned-in to your presentation. And this usually increases your wpm count. So you must guard against racing through your presentation.
Recording these video tutorials has been very instructive – to me! I get a chance to hear myself speak. I get a chance to see how long it takes me to present an idea. And… I have asked a few colleagues to critique these early recordings. As a result, I have received some excellent feedback. And I am making some changes.
Ideally, I want to keep the length of these video lessons short. Three minutes is ideal. Five minutes is too long. I want my audience to stay tuned-in. I don’t want them to tune-out before I make my point. When speaking, I must get to the point quickly without speaking too quickly. I must be aware of how many words per minute I use. And not waste time – nitehr my time nor my audience’s.
In preparing for today’s video lesson on my MS Excel blog, I wrote out my script. I read the script aloud several times and revised it. I timed myself as I spoke the script. I did a word count. And at 702 words divided by my 135 wpm speaking rate, this talk was coming in at 5 minutes and 20 seconds.
Too long! Too much content! What could I trim? What should I eliminate? I need to cut out at least 1 minute of talking in order to keep my audience tuned-in.
After several revisions I was ready to “go live” and record this lesson. I did not want to read my script. And I did not have too. I had rehearsed it sufficiently. I felt comfortable and confident.
The result – a 4 minute and 10 second video. I was happy. And I think that my audience will find this video informative and engaging.
Now mind you, I know this topic – in Excel – very well. I have taught it many times in individual and classroom settings. But this was the first time I was recording the lesson.
The lesson for me – I can always improve. So can you. But it requires practice – before you speak!
In this lesson you will learn how to use Excel’s AutoFilter to reveal select data records that match your filter criteria.
Here are the steps to follow in this lesson:
1) Organize your list into Columns / Fields that contain a single type of data e.g. Territory
2) Apply a different format to identify the Top Row of your list as the Column Headers
3) Select one cell in the list then choose DATA – FILTER – AUTOFILTER
4) Use the “drop-down” arrow for a field to select your filter
5) The Top 10 Filter is a generic term. e.g. You can filter to Bottom 15items / percent
6) Custom filters allow you to see records that are <, <=, etc.
Here are the take-aways for this lesson:
1) Create slides that reinforce your message; your slides should not repeat your message
2) The “Four-by-four” Rule: No more than 4 bullet points; nor more than 4 words per bullet point
3) Ctrl+D is the shortcut for Duplicating a slide
