Microsoft Excel Introduction Training

Course Duration: 1 Day

This Course Covers Version(s): Microsoft Excel versions 2013, 2016 and 2019. (Does not cover Excel for Mac OS)


Available Delivery Methods

In this Microsoft Excel Introduction Training course, students will learn how to create worksheets in Microsoft Excel, how to use formulas and perform calculations, how to format cells and worksheets, how to setup worksheets for printing and how to export data from Excel to various other formats, including PDF. This course assumes no prior experience with Excel and is a great starting point for those who are new to the program or for those who may have some familiarity but want to take their knowledge further.

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.

Live, Instructor-Led Online Class for INDIVIDUALS

$225.00


  • Open Enrollment Class for Individuals
  • Live Class with an Instructor
  • Six Months of Instructor Email Support
  • Hands-on Exercises and Student Labs
  • Classes Never Cancelled Due to Low Enrollment
  • Money-back Guarantee
  • Six Months Access to Recorded Course
Click here to load this Caspio Online Database.

Live, Instructor-Led Online or Onsite Class for GROUPS

Contact Us For Quote


  • For Private Groups as small as 2 people
  • Live, Instructor-led Online or Onsite Class for your group.
  • Hands-on Exercises and Student Labs
  • Customizable
  • Six Months of Email Support After Class
  • Money-back Guarantee
  • Six Months Access to Recorded Course
Click here to load this Caspio Online Database.