course is for the
user who has little or no experience with
Microsoft Excel except for my
Basic Level 1,
4 courses. Today's course covers a wide variety of topics
that didn't fit into any other lesson, but are important to learn.
We'll start by learning how to insert
hyperlinks, text boxes, WordArt, signature lines, and
other objects into our sheets.
Next, we'll learn how to insert
symbols and other special characters into our sheets -
including foreign language letters.
You will learn how to work with
Headers & Footers. You'll see how to manually create a header,
enter in your own text, and use special codes to represent the page
number, total number of pages, date & time, and more. You'll also see
how to use the built-in Header & Footer templates.
Next we'll learn how to work with large
spreadsheets. You'll learn how to freeze panes (the top
row or the left column) so you can scroll around and still see the
headers in your sheet. You'll learn how to split your sheet
into two so you can work on two sections at once.
You'll learn how to work with
borders and gridlines. You'll learn how to change the visible
borders in your spreadsheets, and choose whether or not to print
You'll learn how to merge cells
(merge and center, merge across, unmerge), change cell orientation,
rotate text, and use the Format Painter to quickly copy
We'll learn how to put comments
in our cells so you can store additional information in your
spreadsheets. We'll see how to edit, delete, and permanently show or
hide the comments.
You'll learn how to use Excel's
research tools to spell check your sheet, use the thesaurus,
translate words, and even download real-time stock quotes
from the web and insert them into your sheets.
Finally, you'll learn how to download
spreadsheet template from Microsoft Office Online.
We'll download a calendar template, an invoice template, and a mortgage
calculator template. There are thousands of templates online that you
can choose from.
Again, this is the perfect class for
anyone who is new to Microsoft Excel 2007 and has finished
Basic Level 1,
4 courses. If you have little or no experience
with spreadsheets, or you just want to get familiar with how Excel 2007
works, this class is for you.
course, if you have any questions about whether or not this class is
for you, please contact me.
Complete Outline - Excel 2007
1. Insert Text 1 (7:47)
Insert > Text Group
Web Page Hyperlinks
Insert Text Box
Insert Signature Line
2. Insert Text 2 (3:54)
3. Header & Footer (7:59)
Insert Header & Footer
Header & Footer Elements
Entering Text in Header
&[Page] Code for Page Number
Header & Footer Templates
Go To Footer, Header
4. View Window (6:43)
Working with Large Sheets
Create a Large Sheet of Data
Freeze Top Row
Freeze First column
Split the Window
5. Borders (4:26)
Top, Left, Right,
Inside, Outside Borders
6. Misc Format Tricks (5:28)
Merge and Center
7. Comments (3:42)
Previous, Next Comment
8. Research (5:20)
Getting Stock Quotes
9. Online Templates (5:03)
How to Download Templates
Home Mortgage Template
Excel 2007 Basic 5
Richard on 1/1/2009:
This is the fifth and final beginner class for the Microsoft Excel novice. You will learn: Insert Text, Hyperlinks, WordArt, Text Boxes, Symbols, Objects, Headers & Footers, Freeze Panes, Split Sheet, Borders & Gridlines, Merge & Center, Format Painter, Comments, Research, Stock Quotes, Office Online Templates|
MUHAMMAD FAHAD RAZA on 1/6/2010: Dear Sir,|
sir I want to thank because you realiy helped those poeple who has got lots of problems in office for work.
again thanks from my side.
Pauline on 3/5/2010: Hi Richard,|
The research section in the lesson is very interesting. It helped me to understand how to connect to the Web for a specific item.
Lynn Robbins on 10/7/2010: I found the Excel 2007 Basic courses through 5|
to be well done and useful!
Lynn Robbins on 10/12/2010: Looking forward to more|
new Excel and Access; the original videos are very good;Just looking for the new look of Office.
WHAT program did you use to make
Reply from Richard Rost:
The Handbooks were written in Microsoft Word. I used HyperSnap for the screen shots.
brent on 9/15/2012: You suggest at times to create your own work sheet of the example you have created. Do I have to use a separte computer while taking this course to create my own worksheet of the lesson, or is there a method to crete my own worksheet for the lesson on the same computer at the same time as the lesson.|
Reply from Richard Rost:
Well, one of the reasons why I keep my videos small (640x360) is so that you could place them on one side of your screen while still working with Excel on the other side. If you have a modern monitor (19" or larger) you shouldn't have any problems doing both at the same time. No?
jenny fernandez on 2/10/2013: In Lesson 2, in Object, I can't get the small icon. It comes in large, and i cant make it small. Any ideas? Thnaks|