Excel 2007 Basic 1 Recorded - Computer Learning Zone

Excel 2007 Basic 1 Recorded
By Richard Rost

17 years ago

I've finished recording the videos for Excel 2007 Basic Level 1. I'm working on Level 2 right now. I'm going to try to finish all of the Basic courses in one shot and then package them all up together. That should save me a bunch of time, rather than releasing them all separately.

Here's a list of what's covered in Excel 2007 Basic Level 1. It's your basic introductory-level Excel class for beginners.

UPDATE 11/20: Excel B1 is now online. You can order it, watch it in the Theater, and download it. I'm waiting until I have the next couple of Excel classes finished before I make the "official" release notice (hopefully this weekend) but for those of you die-hard Excel fans who can't wait to get a copy, you can now.

Excel 2007 Basic 1
Running Time 1 hr, 15 min (75:49)

00. Intro (9:25)

01. Excel Interface 1 (5:14)
Starting Excel
The Ribbon Changes with Window Size
Title Bar
Maximize, Minimize, Restore Down
Close Button
Office Button

02. Excel Interface 2 (6:09)
The Ribbon
Ribbon Tabs, Groups, Buttons
Help Popup Menus for Each Command
Command Buttons
Drop-Down Menus
Command Button Groups
Galleries
Dialog Box Launcher Buttons

03. Excel Interface 3 (4:31)
Quick Access Toolbar
Status Bar
Views Buttons
Zoom Controls
Scroll Bars

04. Excel Interface 4 (5:06)
Formula Bar
What is a Spreadsheet
Columns, Rows, Cells
Name Box
Mouse Pointer
Sheet Tabs

05. Entering Data (4:16)
Creating a sales summary sheet
Entering text in Excel
Typing data into a cell
Select a Cell with Mouse
Select a 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 for 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

07. 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

08. 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 with Double-Click
Resizing Rows
Background Color / Fill Color
Foreground Color / Font Color

09. Basic Math 1 (6:36)
Moving to a 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
Select to See 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

12. Review (4:08)

Comments for Excel 2007 Basic 1 Recorded

Age	Subject	From
17 years	Suitability	Richard Rost
17 years	Suitability	Richard B. Jordan

Subscribe to Excel 2007 Basic 1 Recorded
Get notifications when this page is updated