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  
 
 
 
Courses - Microsoft Excel 201

Teacher's Outline

 

Microsoft Excel 201 Tutorial Outline

0. INTRODUCTION
Objectives
Pre-Requisites

1. REVIEW AND SHEET SETUP
Setting up a student gradebook

2. THE IF FUNCTION, PART ONE
How the IF function works
Learning about logical tests
Specifying true and false values for IF
Using text values with IF

3. THE IF FUNCTION, PART TWO
Setting up a sales tax sheet for IF
Logical test with text values
Charging tax only to customers from NY

4. RELATIVE V. ABSOLUTE REFERENCES, PART ONE
Marking a student "pass" or "fail"
Move passing grade outside formulas
Making a cell reference absolute
absolute references v. relative references
AutoFill with absolute references
Move sales tax outside formulas

5. RELATIVE V. ABSOLUTE REFERENCES, PART TWO
Making passing grade based on class average
Grading on a "curve"
Creating a new quarterly sales summary sheet
Showing percent of sales for each quarter
Divide by Zero Error (#DIV/0!)

6. VALUES FROM OTHER SHEETS
Moving all of our external data to a new sheet
Refering to a cell on a different sheet
Cutting and pasting a link to a cell
Right click, paste special
Paste Special dialog box
Pasting the value of a cell (Paste Values)
#NAME? error
Referring to sheet names with spaces in them

7. COPYING DATA TO MICROSOFT WORD
Copying Excel sheet data into Word
Pasting Excel Data as a Word Table
Edit, Paste Special
Microsoft Excel Worksheet Object
Paste Link
Linking v. Embedding
Linking data back to the original Word document

8. TIPS AND TRICKS
Insert Cut Cells
Moving a whole row
Shift cells right
Shift cells down
Copying a sheet with the CTRL-drag trick
Manually drawing borders
View, Toolbars, Borders
Borders Toolbar
Pencil tool
Eraser tool
Insert Comments
Show Comments
Hide Comments

9. REVIEW
Review topics

 

 

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

 

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
 

What's New  |  Home  |  Courses  |  Demo  |  Learn More  |  Contact  |  Order