This
course is for the
novice
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
bars.

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
Operations.
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.
Of
course, if you have any questions about whether or not this class is
for you, please contact me.

Complete Outline - Excel 2007
Basic 1
1. Excel Interface 1 (5:14) Starting Excel The
Ribbon Changes with Window Size Title Bar Maximize,
Minimize Restore Down Close Button Office Button
2. Excel Interface 2 (6:09) The Ribbon Tabs,
Groups, Buttons Help Popup Menus for Each Command Command
Buttons Drop-Down Menus Command Button Groups Galleries
Dialog Box Launcher Buttons
3. Excel Interface 3
(4:31) Quick Access Toolbar Status Bar Views
Buttons Zoom Controls Scroll Bars
4. Excel
Interface 4 (5:06) Formula Bar What is a Spreadsheet
Columns, Rows, Cells Name Box Mouse Pointer Sheet Tabs
5. Entering Data (4:16) Sales summary sheet
Entering text in Excel Typing data into a cell Select Cell
with Mouse Select Cell with Keyboard Move with ENTER, TAB
Move with Arrow Keys Entering Data
06. Editing Data
(5:04) Editing data in a cell Four methods editing
data Overtyping your data Replacing data in your cells
Editing data using the Formula Bar Editing a cell by
double-clicking Edit Mode with F2 Deleting data in a cell
Using UNDO in Excel Using REDO in Excel |
7. Formatting 1 (5:10) Home, Alignment Formatting
your text Horizontal cell alignment Align Right, Left,
Center A Cell Range defined Cell Range Notation (A1:B5)
Selecting cell rangess Bold, Italics, Underline
8.
Formatting 2 (6:49) Changing the Font Live Preview
Change Font Size Dropdown Type in a Font Size Manually
Increase Font Size Decrease Font Size Resizing Columns
Changing Column Width Resize Column w DoubleClick Resizing
Rows Background Color, Fill Color Foreground Color, Font
Color
9. Basic Math 1 (6:36) Moving to
different sheet tab Using a "scratch" sheet Adding two
cells together How Formula Work in Excel Auto
Recalculation of Formula See Formula in Formula Bar See
Result on the Sheet Basic math operators Addition
Subtraction Multiplication Division Exponentiation
Using Constants Clearing a range of cells Selecting an
Entire Column
10. Basic Math 2 (4:38) Adding
Multiple Cells Summary in Status Bar Click to Add Cell to
Formula Order of Operations Using parentheses in math
operations Average a Group of Cells
11. Save, Load,
Print (8:43) Saving Your Workbook File Save As a
Different File Open Recent Documents Open Any Document
Pinning Documents to the List Create a New Blank Workbook
Print Preview Print Your Spreadsheet |

|