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

 Check out these other pages that may be of interest to you:
 2/3/2023 TextSplit 1/27/2023 Math in Fields 12/12/2022 Tax Brackets 12/9/2022 Double Lookup 10/24/2022 Follow Hyperlink 9/17/2022 Very Hidden 8/11/2022 Crosstab 8/10/2022 Transpose 7/26/2022 Lottery Numbers 2 7/22/2022 Lottery Numbers