course is for the
user who has little or no experience with
Microsoft Excel. We will begin by learning about the parts of the Excel
interface, including the Title Bar, window control buttons,
Office button, and more.
You will learn about the new
Ribbon, the different tabs, groups, command, and dialog menus.
Next you will learn about the
Quick Access Toolbar, the status bar, zoom controls, and scroll
We will next learn about the
Formula Bar, the different parts of a spreadsheet including
rows, columns, and cells. You'll learn how to use the mouse pointer with
respect to Excel, and learn about the different Sheet Tabs.
You'll learn how to properly
input data into an Excel spreadsheet. We'll create a sales
summary sheet in class with different sales reps and their sales figures
by month. You'll see how to work with both the mouse and keyboard.
We'll learn how to edit data
in our sheet. You'll learn how to replace data in the cells, edit data
using the Formula Bar, and use Edit Mode directly in a cell. You'll also
learn about Undo and Redo.
You will learn how to format your
spreadsheet to make it look more professional. You'll learn
about cell alignment, ranges, bold, italics, underline, and more.
Next we'll learn more formatting
techniques. You'll change the font and font size. You'll learn
how to resize columns and rows, change color, and more.
You will learn how to perform
basic math calculations in Excel, and how formulas work. You'll
learn about the basic math operators (add, subtract, multiply, divide,
exponent) and how to use constants in your formulas.
We'll learn how to add multiple cells,
use the mouse to build our formulas, work with the status bar, calculate
an average, and we'll learn about the all-important Order of
Finally, you'll learn how to
save, load, and print your worksheets. You'll also learn about
pinning your files to the Recent Documents menu, and previewing your
sheet before you print it.
Again, this is the perfect class for
anyone who is new to Microsoft Excel 2007. 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. You should have some
basic knowledge of Windows beforehand, and a little bit of Microsoft
Word helps (so you're familiar with formatting text), but we'll teach you everything
you need to know to use Excel to make simple spreadsheets.
course, if you have any questions about whether or not this class is
for you, please contact me.
Complete Outline - Excel 2007
1. Excel Interface 1 (5:14)
Ribbon Changes with Window Size
2. Excel Interface 2 (6:09)
Help Popup Menus for Each Command
Command Button Groups
Dialog Box Launcher Buttons
3. Excel Interface 3
Quick Access Toolbar
Interface 4 (5:06)
What is a Spreadsheet
Columns, Rows, Cells
5. Entering Data (4:16)
Sales summary sheet
Entering text in Excel
Typing data into a cell
Select Cell with Keyboard
Move with ENTER, TAB
Move with Arrow Keys
06. Editing Data
Editing data in a cell
Four methods editing
Overtyping your data
Replacing data in your cells
Editing data using the Formula Bar
Editing a cell by
Edit Mode with F2
Deleting data in a cell
Using UNDO in Excel
Using REDO in Excel
7. Formatting 1 (5:10)
Horizontal cell alignment
Align Right, Left,
A Cell Range defined
Cell Range Notation (A1:B5)
Selecting cell rangess
Bold, Italics, Underline
Formatting 2 (6:49)
Changing the Font
Change Font Size Dropdown
Type in a Font Size Manually
Increase Font Size
Decrease Font Size
Changing Column Width
Resize Column w DoubleClick
Background Color, Fill Color
Foreground Color, Font
9. Basic Math 1 (6:36)
different sheet tab
Using a "scratch" sheet
How Formula Work in Excel
Recalculation of Formula
See Formula in Formula Bar
Result on the Sheet
Basic math operators
Clearing a range of cells
10. Basic Math 2 (4:38)
Summary in Status Bar
Click to Add Cell to
Order of Operations
Using parentheses in math
Average a Group of Cells
11. Save, Load,
Saving Your Workbook File
Save As a
Open Recent Documents
Open Any Document
Pinning Documents to the List
Create a New Blank Workbook
Print Your Spreadsheet
Excel 2007 Basic 1
Richard on 1/1/2009:
This is the first beginner class for the Microsoft Excel novice. You will learn: The Excel 2007 Interface & The Ribbon, Entering & Editing Data, The Formula Bar, Rows, Columns, Cells, Ranges, Worksheets & Workbooks, Formatting Data & Cells, Basic Math Calculations & Formulas, Saving, Loading, Printing Sheets|
Jackson Kanampiu on 10/24/2010: This a great class am that am to learn.My problem is that am a slow learner. Thank to the instructor cause he we sit back and relux. Acourse can be confusing to a first time listener.|
Edwin Ford on 10/24/2010: Richard: I have Microsoft Excel 2010. I have to make some sign-in sheets with some vertical lines to put other information--How do I make a VERTICAL column or line on Excel?|
I'll be glad when your 2010 stuff starts coming out; meantime I've bought all the 2007 Classes. Your Classes are excellent and are just what I need.
Andrea Wells on 1/9/2011: Some how I was working on the prgram in sheet 1 and at the end of the lesson i was on sheet 5 and all my infomation was on 5 not 1 why what did i do wrong|
Reply from Richard Rost:
I really couldn't tell you. Perhaps you clicked on Sheet5 without realizing it?
Mnac on 7/27/2012: This is very good!|
Lee Shenk on 9/29/2014: How do you change the default settings for letter size?|
Reply from Richard Rost:
You have to use a custom template for new Excel documents. I'll cover this in a future class. If you need instructions now, contact my TechHelp team.
Kathryn Cooney on 10/24/2016: Hi. I would like to see just the lesson on half my screen (eliminating the lesson numbers and settings), as I would like to open my own version of Excel and have it on the screen at the same time. However, I am only able to reduce the size so the lesson screen gets smaller and the settings, etc. stay the same. Thx.|
Reply from Alex Hedley:
I'm in the middle of creating an iOS app so you could use that instead.
You could right click on the video and open frame in new tab but then you lose all the controls and auto advance etc.
This was the original idea for the AVP (Amicron Video Player) but that was discontinued, I nice little app.
PATRICK D. WEEDOR on 12/13/2016: I AM A LIBERIAN.I AM ALSO RESIDING IN THE SAME LIBERIA. I AM VERY,VERY HAPPY THAT THIS PARTICULAR FORM IS A FOR FORM FOR DISCUSSION ABOUT THE EXCEL LESSON.|
PATRICK D. WEEDOR
Reply from Alex Hedley:
This is the place if you want to discuss.