Microsoft Word has some nice shortcuts that are not well known. One of those is the Shift + F5 shortcut.
Use this to cycle between your most recent edits. With a large document, Shift+F5 is handy to see what you have edited most recently. And, you can use it when you first open a document to take you to your most recent edit.
If you are on a laptop, you may need to use your function key along with the F5 key.
Shift + Fn + F5
Charts help bridge the gap between our spreadsheet data and the real world. I don’t remember where I first read that, it was years ago. But it is something I always tell my students. It is so true. At a glance, which is easier to understand?
This spreadsheet data?
Or this chart?
A thermometer chart shows you how much of a goal has been achieved. Such as how much money has been raised for an event.
Creating a thermometer type chart is one of the best visuals to present your data in an understandable way.
This type of chart is for a single point target and it is easy to create.
Watch my YouTube video here: Charting Progress Towards Goal – Video
Download instructions here: Charting progress toward a goal
Have you ever created a table and you need to add numbering to the first column? Ever done it manually? Ouch. There is actually a way to do this quickly. Simply select the column and click on the Numbering button from the Home tab. I know!!
The same thing works if you select a row and want to have numbering across your columns
Watch the video on YouTube: Numbering the rows in your Word Tables
Did you know that PowerPoint has some pretty cool picture editing and effects tools?
Here a just a few basic examples: (Can you tell I like cycling?)
Want to learn how to do some awesome things with PowerPoint?
Then check out these two YouTube channels:
“You don’t understand, I haven’t used a computer before.”
“I’ve been a stay-at-home mom for the last 10 years.”
“My job didn’t require the use of a computer.”
“I didn’t grow up around computers.”
I teach a class, Intro to PC Applications, at a local community college. This class covers the Microsoft applications – Word, Excel, Access and PowerPoint – applications that are in great demand in today’s workforce. This is a required class for several of the degree paths and many of the certificates. There are no prerequisites for this course, so I get some incredibly full classes. My students ages range from 16 – 65+, I have high school students to adults in career transitions.
Every semester, I get at least a couple students who are brand new to using a computer. Some can barely use a mouse, others have only used a computer for email or just web browsing. Maybe they have used MS Word at its most basic level.
We start the semester learning MS Word. But not only are the students learning Word, but they must also learn to navigate the Learning Management System (LMS) and the separate online platform for many of their assignments. Additionally, they need to have some basic navigation skills on the computer.
The students new to computers? They struggle.
These students have to put forth a little more time and effort. I do my best to provide additional instruction before, after and during class. I provide video instructions and website resources. But being a part-time instructor, my time is limited.
It’s not long before I start hearing the excuses. I hear so many variations.
“This class is hard.”
“I don’t have time for the extra stuff.”
I get it. For most of these students with little or no past computer experience, this is also their first college course, or one of the first. There are a lot of new things going on at once. And in 15 weeks, for a total of 3 hours a week (class time), they are going at an unfamiliar pace.
I struggle with how to best meet the needs of these few students, when I have 20 others in the same class. The school does provide free tutoring and I encourage them to take advantage of the service.
I’m writing this post to let those students know that, while it can be a great struggle, there is hope.
Guess what? You can double-click anywhere in a Word document and start typing.
Just double-click in any position on the page where you want text and start typing.
Watch the video: Click and Type
In Excel, have you ever manually highlighted a row or rows based on a certain criteria? It’s a lot of work to do it that way, In this video I show you how to highlight rows based on a cell value using Conditional Formatting.
All you need to do is press Ctrl and the apostrophe. Release the key combination and type the letter to be accented, and there it is.
For example, if you want to type an é, press the Ctrl key and press the ’ (apostrophe) and then release the keys.
Type the letter e and it will show up with the dash above it.
Watch the video on my YouTube Channel – Word Accent Marks