Excel 2010-2019
Excel 2007
Excel 2003
Tips & Tricks
Excel Forum
Course Index CIG Excel Book
Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon  
Excel 2007 Basic 1 Recorded
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   13 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
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
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
13 yearsSuitabilityRichard Rost
13 yearsSuitabilityRichard B. Jordan


Start a NEW Conversation
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

You may want to read these articles from the 599CD News:

7/26/2022Lottery Numbers 2
7/22/2022Lottery Numbers
6/30/2022Sales Chart
6/17/2022Fast AutoSum
2/22/2022ISO Date Format
1/27/2022Work Days
1/11/2022Excel Fast Tips
1/7/2022Count Cells by Color

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: excel 2007 basic level 1  PermaLink  Excel 2007 Basic 1 Recorded