Excel 2010-2019 Excel 2007 Excel 2003 Tips & Tricks Excel Forum Course Index CIG Excel Book

 Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum ------------ Excel Courses Excel Index ------------ Code Vault Testimonials

 Courses - Microsoft Excel 202 Teacher's Outline

Microsoft Excel 202 Tutorial Outline

0. INTRODUCTION
Objectives
Pre-Requisites

1. REVIEW AND SHEET SETUP
Short review of important concepts

2. NAMED CELLS
Defining a named range
Insert, Name, Define
Refers To Box
Using the Name Box
Jumping to a named cell
Using the named cell in functions
Collapse Dialog
Expand Dialog
Valid names for cells

3. NAMED RANGES, PART ONE
Defining a named range
Pasting a named cell or range
Insert, Name, Paste
Using named ranges in formulas
Jumping to named ranges
Range Intersections

4. NAMED RANGES, PART TWO
Deleting a named range or cell
Editing a named range or cell
Pasting a list of your named ranges
Paste List
Insert, Name, Create
Applying names to existing ranges
Insert, Name, Apply

5. NESTED IF FUNCTIONS
What is a Nested IF function
Using the COUNT function
Checking multiple conditions
Giving our students an Incomplete
Giving a letter grade using nested IFs

6. VLOOKUP, PART ONE
Creating a subtable (lookup table)
Using VLOOKUP to return the letter grade
Using VLOOKUP to return a commission rate

7. VLOOKUP, PART TWO
Expanding our lookup table to three columns
Using VLOOKUP to return multiple columns
Creating a basic invoice using Excel
Using HLOOKUP to calculate a discount
Using the Function Wizard for HLOOKUP

8. REVIEW
Review Topics

 You may want to read these articles from the 599CD News:
 6/30/2022 Sales Chart 6/17/2022 Fast AutoSum 2/22/2022 ISO Date Format 1/27/2022 Work Days 1/11/2022 Excel Fast Tips 1/7/2022 Count Cells by Color 1/7/2022 Excel VBA 1/7/2022 Excel Count by Color 12/26/2021 Conditional Formatting 12/9/2021 Excel 2003 Quick Start 1

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

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