Excel 2010/2013 Excel 2007 Excel 2003 Tips & Tricks Excel Forum Course Index CIG Excel Book

 Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us More... What's New? Tips & Tricks Access Index Access Tips Excel Index Excel Tips Waiting List

 Courses - Microsoft Excel 201 Teacher's Outline

Microsoft Excel 201 Tutorial Outline

0. INTRODUCTION
Objectives
Pre-Requisites

1. REVIEW AND SHEET SETUP

2. THE IF FUNCTION, PART ONE
How the IF function works
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"
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
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
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

9. REVIEW
Review topics

 You may want to read these articles from the 599CD News:
 5/4/2014 Microsoft Access Expert 20 3/5/2013 Excel Tip: Price Markups 2/3/2013 Signed Copies of my Excel Book 9/27/2012 Excel Expert 10 Handbook Ready 9/18/2012 Two New Excel Tips: Date/Time Differences 6/20/2012 Excel Tip: Sum Cells Between Two Values 6/16/2012 New Excel Tip: Paste Link 3/26/2012 Excel Tip: 2D Matrix Lookups 11/18/2011 Dashboards in Excel 10/6/2011 Excel Expert 11 On Hold

Learn

 Access index Excel index Word index Windows index PowerPoint index Photoshop index Visual Basic index ASP index Seminars More...
Customers

Online Theater
Insider Circle
Student Databases
Change Email
Info

Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Help

Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services

Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order

Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact

Live Chat
General Info
Support Policy
Contact Form
Email Us