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  
 
 
 
Courses - Microsoft Excel 101
Description: Introduction to Microsoft Excel
Running Time: 72 minutes
Pre-Requisites: Windows 101 recommended
Windows 102 or Windows 110 recommended
Word 101 helpful
Versions:
We use Excel XP in this course, but the lessons are valid for all versions of Excel from 95 to 2003. There are cosmetic changes in Excel 2007. Order before 3/31/2024 to get a FREE upgrade to our 2007 version when released!
 

 Click here for the Teacher's Outline
 
This is the perfect class for anyone who knows nothing about Excel, or has used Excel for a little while, but needs to learn how to do more. We will take you from knowing nothing to building a full fledged spreadsheet with functions in about an hour.

We will cover many topics including Excel basics, the parts of the screen, entering and editing data, formatting your sheet, working with math calculations, functions such as SUM and AVERAGE, cut, copy, and paste, AutoFill basics, saving and loading your sheets, and finally printing your sheet.


click to enlarge

First, we show you how to start Microsoft Excel, and go over the different parts of the screen: the title bar, the tool bars, the menu bar, the spreadsheet area, and so on. We'll also talk about the parts of a spreadsheet, such as columns, rows, cells, ranges, sheet tabs, etc.

(Note that these are screen shots from the actual course - and from the optional printable handbook that you can get to follow along with!)

Then, we'll teach you how to customize Excel to make it a little easier to use. We'll turn the task pane off, and fix your toolbars so they're easy to work with.

In lesson three, we'll show you how to enter data into a spreadsheet. This is covered in the demo lesson that's available to watch free here on the web site. We'll show you how to enter data into rows and columns.

Lesson four covers editing data with both the keyboard and mouse. We'll teach you how to edit data in place right on the spreadsheet and how to use the formula bar to edit data as well. We'll go over some shortcut keyboard tricks that will help you edit data in your sheets as well. We'll teach you how to delete data from cells, and then we'll show you how to undo mistakes, to get back that data!

In lesson five, we'll spend some time making our spreadsheet look professional. We'll go over fonts, font sizes, bold, italics, underlining, column alignment, foreground and background colors, and so on. We'll also show you a cool trick for making your columns automatically resize themselves to the exact width they need to be to fit the data in them.

Before we can learn advanced features like functions, we have to show you how to do basic math calculations. So, we'll show you the proper way to perform addition, subtraction, multiplication, division, and so on in your spreadsheets. We'll also go over the order of operations. Remember that from high school math?

In lesson seven, we'll show you your first function. We'll spend some time talking about exactly what functions are, and how they work.

Then, we'll teach you how to use the SUM function to add up whole columns of numbers in a snap. We'll also cover the AVERAGE function in detail. We'll show you some shortcut tricks for entering your functions without having to type in cell ranges. We'll also cover the functions MAX, MIN, and COUNT.

Our courses are very hands-on with real world examples. We'll take what we've learned about functions and sum up the sales for our sales rep sheet we started earlier.

We'll spend some time going over cut, copy, and paste in Excel. We'll show you also how to copy large amounts of data and automatically update your functions using a great feature called AutoFill. AutoFill will save you hours of time from copying and pasting similar data in your spreadsheets.

Next we'll show you how to properly save your workbook to disk, and then how to load it back up again. We'll also cover some options for printing your spreadsheets.

 

This is the perfect beginner lesson for anyone who needs to learn the basics of Excel. We'll get you up to speed with how Excel works, and you'll be creating your own spreadsheets, complete with functions and profession-looking formats, in about an hour.

 

 

 Click here for the Teacher's Outline
 


Try a FREE Demo Lesson

 
 
 

 

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/28/2024 6:16:04 AM. PLT: 0s