Microsoft Excel Introduction
1 Day
Versions 2007 and 2010 (View Version 2003 Agenda)
This instructor-led course, through lecture and hands-on exploration, will show students the basic skills needed to enter and edit information, write formulas, format cells, and print spreadsheets in Microsoft Excel. This course is geared to new users who have little or no experience using Microsoft Excel or another spreadsheet application. In order to successfully complete this course, you should feel comfortable using a mouse and have a working knowledge of the Windows environment.
Building Simple Workbooks
Understanding Excel Terminology
Examining Important Screen Elements
Opening Workbooks
Reviewing Workbook Data
Navigating Worksheets
Entering General Text
Entering Numbers
Entering Dates
Editing Cells
Deleting Cell Contents
Understanding Mouse Pointer Shapes
Selecting Cells, Rows, and Columns
Moving Data by Drag-and-Drop
Copying Data with the Fill Handle
Reversing Mistakes with Undo and Redo
Checking for Spelling Errors
Saving Workbooks
Closing Workbooks
Using the Help Command
Managing Worksheets
Renaming Worksheets
Adding Color to Worksheet Tabs
Moving Worksheets
Inserting Worksheets Deleting Worksheets
Writing and Copying Basic Formulas
Understanding Formulas Elements and Syntax
Understanding Excel's Order of Precedence
Creating Basic Formulas
Using Functions in Formulas
Using the Sum Button
|
Writing and Copying Basic Formulas (cont.)
Copying Formulas
Using the Insert Function Tool
Using the TODAY Function to Insert the Current Date
Using Dates in Formulas
Using AutoCalculate
Formatting Worksheets
Changing Column Widths
Applying Fonts, Bold, Underline, and Italics
Copying Formatting from One Cell to Another
Aligning Data in Cells
Centering Data Across Columns
Wrapping Text within Coumns
Formatting Numbers and Formulas
Applying Borders
Applying Fill Color
Inserting and Deleting Columns or Rows
Inserting Pictures or Clip Art
Moving and Resizing Pictures
Deleting Pictures
Working with Larger Workbooks
Keeping Headings on the Screen as You Work
Previewing Before Printing
Printing Row and Column Headings
Hiding and Unhiding Columns
Sorting Lists of Information
Creating Custom Sorts
Printing Worksheets
|
Related Courses
Excel - Introduction Agenda
Excel - Intermediate Agenda
Excel - Advanced Agenda
Excel - Macro Recording and Programming
Not Sure What Level to Take?
Before taking the Intermediate or Advanced level class for this application, we ask that you take our free assessment to determine whether you are comfortable with the topics covered in the Introductory level class. Or, feel free to contact our office at (202) 747-5000 to speak with a representative to discuss the prerequisites.
|