2 days ago: New Feature: you can now upload your Profile Picture to the site. Check it out!  Dismiss
 
Excel 2010-2019
Excel 2007
Excel 2003
Tips & Tricks
Excel Forum
Course Index CIG Excel Book
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
 
 

Excel 2007 Basic Level 1
Beginner Microsoft Excel Tutorial - 75 Minutes

 
 
Are you new to Microsoft Excel 2007? This video tutorial will teach you all of the basics of how to use Excel. 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

Order Now

If you would like a preview of what's covered in this class,
click here to watch the first lesson of this course (free of charge), or scroll down for more information.




 

Excel 2007 Basic Level 1
Description: Excel 2007 Basic Level 1
Versions: Microsoft Office Excel 2007
Pre-Requisites: Windows Vista 101 strongly recommended
Word 2007 Basic 1 recommended
Running Time: 75 Minutes
Cost: $1


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

 


 
 
 

 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
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
PCResale.NET
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
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 3/19/2024 4:41:35 AM. PLT: 0s