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 More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum ------------ Excel Courses Excel Index ------------ Code Vault Testimonials

 Courses - Microsoft Excel 101 Teacher's Outline

Microsoft Excel 101 Tutorial Outline

1. INTRODUCTION
Objectives
Pre-Requisites
Important concepts

2. PARTS OF THE EXCEL SCREEN
Starting Excel
Parts of the screen
Title Bar
Workbook name
Maximize
Minimize
Close
Two sets of max/min/close buttons
Toolbars
Standard toolbar
Formatting toolbar
Formula Bar
Columns v. Rows
Names of Columns and Rows
Cells
Names of Cells
The Cell Name Box
The Mouse Pointer in Excel
Scroll Bars and their use in Excel
Sheet Tabs
Status Bar
Moving Toolbars Around
Floating v. Docked Toolbars

3. ENTERING DATA
Creating a sales summary sheet
Entering text in Excel
Typing data into a cell
Entering a full column of data
Pressing ENTER, TAB, or ARROW KEYS
Using the Mouse to move around
Using the keyboard to move around

4. EDITING DATA
Editing data in a cell
Editing data using the Formula Bar
Editing a cell by double-clicking
Deleting data in a cell
Using UNDO in Excel
Using REDO in Excel

5. FORMATTING OUR SHEET
A Cell Range defined
Cell Range Notation (A1:B5)
Highlighting (selecting) ranges of cells
Horizontal cell alignment
Align Right, Left, Center
Bold, Italics, Underline
Changing Fonts, Font Size
Resizing Columns
Changing Column Width
Resizing Rows
Resizing Columns Automatically with Double-Click
Background Color / Fill Color
Foreground Color / Font Color

6. BASIC MATH
Moving to a different sheet tab
Using a "scratch" sheet
Basic math operators
Demonstrate auto-recalculation
Result on sheet, formula in formula bar
Subtraction
Multiplication
Division
Exponentiation
Clearing a range of cells
Taking the average of a range of cells
Order of Operations
Using parentheses in math operations

7. FUNCTIONS, PART ONE
Functions defined
What is a function
The SUM function
The AVERAGE function
Using the mouse with functions
Selecting function ranges with the mouse
The MAX, MIN, and COUNT functions

8. FUNCTIONS, PART TWO
Adding functions to our sales summary sheet
Totalling each month's sales
Totalling each sales rep's sales
Calculating a grand total
Calculating sums for columns and rows
Practical application for our student gradebook

9. CUT, COPY, PASTE, AUTOFILL
Copying and pasting a formula
Using AutoFill to copy a formula
The AutoFill Handle
Common mistakes while trying to AutoFill
Moving cells by click and drag
AutoFill Series: Months

Saving with the floppy disk (save) button
Saving to your "My Documents" folder
Entering a filename
Closing Excel
Using the Windows Documents options
File, Print
Print Options

11. REVIEW
Review topics

 You may want to read these articles from the 599CD News:
 9/11/2021 Circular References 8/25/2021 Stock History 8/23/2021 Concatenation 8/17/2021 Flash Fill 8/5/2021 Stock Portfolio 8/4/2021 Stock Portfolio 6/23/2021 Import Data 5/14/2021 Quick Queries #4 4/4/2021 Text to Columns 3/15/2021 VLOOKUP in Access

 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

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