Microsoft Excel Introduction Training

This course is designed for students with little to no experience in using spreadsheet applications.

Upon successful completion of this course, students will be able to:

• Identify the elements of the Excel interface, create a basic worksheet, and use the help system.
• Create formulas in a worksheet, insert functions in a worksheet, and reuse formulas.
• Manipulate data, as well as insert, manipulate, and delete cells, columns, and rows.
• Search for and replace data and spell check a worksheet.
• Modify fonts, add borders and colors to cells, apply number formats, align cell contents, and apply cell styles.
• Define the basic page layout for a workbook, refine the page layout, and apply print options.
• Format worksheet tabs, manage worksheets, and manage the view of worksheets and workbooks.

1. Introduction to Microsoft Excel
   • What is a Spreadsheet?
   • Opening Excel, Reviewing the Parts
   • Navigating in an Excel Workbook
   • Using the Help Feature in Excel
   • Seting Basic Program Options and Saving Files
   • How to Modify the Quick Access Toolbar
2. Entering Data and Performing Calculations
   • Entering Text and Numbers in Cells
   • Editing, Deleting and Moving Data in Cells
   • Writing a Basic Formula
   • Using Functions for Faster Formulas
   • Function Basics
   • Using the Insert Function Box
   • Writing Function Formulas by Hand
   • Formula Tips and Tricks
   • Using Auto-Fill
   • Setting an Absolute Reference
3. Formatting
   • Formatting Text
   • Basic Text Formatting
   • The Format Cells Dialog Box
   • Number Formatting
   • Basic Number Formatting
   • Adding Colors and Borders to Cells
   • Adding a Border Around Cells
   • Adding a Fill Color in Cells
   • Removing Borders and Color from Cells
   • Conditional Formatting
   • Basic Conditional Formattting
   • Rule-Based Conditional Formatting
   • Using Styles and Themes
   • Applying Styles
   • Working with Themes
4. Organizing Your Worksheet
   • Adjusting the Worksheet Layout
   • Changing the Row and Column Layout
   • Removing Rows and Columns
   • Working with Individual Cells
   • Merging and Centering Cells
   • Adding and Rearranging Worksheets
   • Adding, Removing, and Renaming Worksheets
   • Moving and Copying Worksheets
   • Using Find and Replace
   • Spell Checking
5. Printing and Exporting
   • Setting Up the Page Layout
   • Setting Page Margins
   • Scaling the Printout
   • Adding Headers and Footers
   • Printing a Worksheet
   • Using Print Preview
   • Using the Print Titles Feature
   • Creating a PDF (or XPS) File

Students attending this course should have experience using a PC and navigating the Windows environment.