course is for the
user who has little or no experience with
Microsoft Excel except for my
Basic Level 1 and
Level 2 courses. We will begin by learning about Functions,
what they are, and how to use them in Excel.
learn about the SUM function and how to use it to add
up a whole column of cells.
You will learn several other
popular functions as well, including Average, Count, Max, and
Min. You'll also learn how to move a whole block of cells.
You will get lots of practice using these
different functions, and learning lots of tips, tricks, and
shortcuts for working with functions in Excel.
Next we'll learn about Styles &
Themes and how we can use them to make our Excel spreadsheets
look professional and uniform.
You'll learn about Page Layout
in Excel, including page layout view, margins, orientation, page size,
print area, page breaks, background images, gridlines, and headings.
We'll see how to insert
Illustrations into our spreadsheets. We'll start learning how
to insert a picture or a piece of clip art. We'll learn how to format
that image, change brightness and contrast, and more.
Then we'll learn how to insert
shapes, format those shapes, add text to those shapes, draw
lines with arrowheads, and then work with WordArt styles.
Finally, we'll learn all about
SmartArt which is a great new feature in Office 2007 which lets
you create cool, artistic diagrams and flowcharts.
Again, this is the perfect class for
anyone who is new to Microsoft Excel 2007 and has finished my
Basic Level 1
Level 2 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. Functions 1 (6:39)
What is a Function
The SUM Function
Benefits of Functions
2. Functions 2 (4:36)
Move a Block of Cells
3. Functions 3 (6:56)
Practice with Functions
The Key Cell Format Trick
Insert New Month of Sales
AutoFill Multiple Cells
4. Styles & Themes (7:53)
Selecting Cell Styles
What's a #DIV/0! Error
Using Styles to Format
5. Page Layout (7:37)
View, Page Layout
Set Print Area
Clear Print Area
Gridlines: View, Print
Headings: View, Print
6. Illustrations 1 (9:07)
Insert a Picture
Move and Resize a Picture
Picture Tools, Format Tab
Delete a Picture
7. Illustrations 2 (7:37)
Drawing Tools, Format Tab
Themes Effect Shape Styles
Quick Mini Toolbar Popup
Inserting an Arrow
8. Illustrations 3 (5:50)
Format SmartArt Options
Excel 2007 Basic 3
Richard on 1/1/2009:
This is the third beginner class for the Microsoft Excel novice. You will learn: What are Functions, How to Use Functions, Sum, Average, Count, Max, Min, Styles & Themes, Page Layout, Insert Illustrations|
Tommie Burns on 7/29/2010: it seems to me that there should be a pause button on the lessons so we could then go to Excel on the computer and do the lesson real time.|
Reply from Richard Rost:
There is a pause button, both in the Theater and my Video Player software.
Suzanne Reichenberg on 11/17/2010: I have a question re: auto fill with function formulas. Sometimes, when I've added a column and inserted a formula, when I try to use the auto fill, the answer I receive is the same as the original cell for all other cells. I check the formula and it changed to pick up the new range of cells but it gives me a wrong answer. If I click on the cell look at the formula and click again it will then show me the correct answer. Can you tell me why this happens and how do I correct my problem? It is very time consuming and makes me question the accuracy of the function/formulas. Thank you|
Reply from Richard Rost:
I'm not sure WHY this is happening. Do you have the latest service pack installed for Office? I'd have to see your spreadsheet to tell you exactly what's going on. This is one of the most compelling reasons to use TABLES in Excel though. If all of your data and formulas are uniform, a table will force the formulas in every column to be exactly the same for every row. I cover them in Excel Basic 4, lesson 6 (next class, which I see you've already ordered.)
Alex Hedley on 11/17/2010: I think this might have something to do with the calculations.|
If you press F9 it will re-calculate for you or you can change this in options,
Older versions of Excel:-
Tools | Options | (Can't remember which tab)
File | Options | Formulas
Clicking out of the cell and clicking back into will re-calculate this is why you see it change.
Suzanne on 11/20/2010: The problem is I'm working on spreadsheets that I didn't orginate. I'm being asked to add additional input so I have not control of it. I'll try the F9 next time I run into it, thanks Alex.|