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

Suitability Upload Images   Link  
Richard Rost 
12 years ago
Richard, you are correct. If you've already taken my Basic and Intermediate Excel 2000/2003 courses, then you probably won't learn anything new in Excel 2007 Basic 1. It's for beginners.

If you want to get up to speed on the changes from 2003 to 2007, then pick up the Upgrading to Excel 2007 seminar which covers all of these differences. Read More...
Add a Reply
Suitability Upload Images   Link  
Richard B. Jordan 
12 years ago
Is it correct to say the EXCEL 2007 Basic 1 course and the following EXCEL 2007 Basic courses, while informative, are not necessary for the student who has taken all your EXCEL 100 & 200 courses for EXCEL 2000 and later editions?
Add a Reply

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

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

11/30/2021Import Multiline Cells
11/11/2021Link to Excel
11/11/2021Read Write Excel Data
11/10/2021Excel Moving Average
9/11/2021Circular References
8/25/2021Stock History
8/23/2021Concatenation
8/17/2021Flash Fill
8/5/2021Stock Portfolio
8/4/2021Stock Portfolio
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
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