Microsoft® Excel Level I

Duration: 
1 days
Price: 
$255.00
Audience: 

This course is designed for students who desire to gain the necessary skills to create, edit, format, and print basic Microsoft Office Excel 2010 worksheets.

This course requires the following prerequisites:

  • Windows XP Professional : Level 1
  • Windows XP : Introduction
Overview: 

As a new user of Microsoft Excel, you have the need to learn the most basic functionality offered by the program. You will become familiar with the user interface, how to use the help feature, modify cells, create basic formulas and use functions to calculate cell values.

Participants will not only become familiar with the interface and the basic functionality of Microsoft Excel but will also learn to manipulate data, modify worksheet elements, apply number formatting, apply cell styles and learn how to manage their worksheets and workbooks.

Topics: 

Module 1: The Basics

  • Getting Started
  • Signing In
  • Creating a New Workbook
  • Parts of a Workbook
  • Saving a Workbook
  • Opening a Workbook
  • Review Questions

Module 2: Your First Workbook

  • Selecting Data
  • Entering and Deleting Data
  • Using Undo and Redo
  • Using Cut, Copy, and Paste
  • Review Questions

Module 3: Working with Data

  • Inserting Rows and Columns
  • Merging and Splitting Cells
  • Moving Cells
  • Using Paste Special
  • Using Find and Replace
  • Hiding and Unhiding Cells
  • Review Questions

Module 4: Using Basic Excel Tools

  • Understanding Cell References and Formulas
  • Using Basic Formulas
  • Using Basic Functions
  • Using Advanced Functions
  • Using Spell Check
  • Using Sort and Filter
  • Review Questions

Module 5: Using Timesaving Tools

  • Using AutoFill
  • Using Flash Fill
  • Using AutoSum
  • Using AutoComplete
  • Using AutoCalculate
  • Review Questions

Module 6: Formatting Text

  • Changing the Font Face, Size, and Color
  • Applying Text Effects
  • Applying Borders and Fill
  • Using the Font Tab of the Format Cells Dialog
  • Clearing Formatting
  • Review Questions

Module 7: Formatting Data

  • Wrapping Text
  • Changing the Size of Rows and Columns
  • Adjusting Cell Alignment
  • Changing Text Direction
  • Changing Number Format
  • Review Questions

Module 8: Formatting the Workbook

  • Using Cell Styles
  • Formatting Data as a Table
  • Changing the Theme
  • Inserting Page Breaks
  • Adding a Background
  • Review Questions

Module 9: Inserting Art and Objects

  • Inserting SmartArt
  • Inserting Text Boxes
  • Inserting Pictures
  • Inserting Equations
  • Drawing Shapes
  • Review Questions

Module 10: Charting Data

  • Creating Sparklines
  • Inserting Charts
  • Inserting PivotTables
  • Inserting PivotCharts
  • Using Slicers
  • Creating Timelines
  • Review Questions

Module 11: Viewing, Printing, and Sharing Your Workbook

  • Using Views
  • Saving a Workbook as PDF or XPS
  • Printing a Workbook
  • E-Mailing a Workbook
  • Sharing Your Workbook on OneDrive
  • Review Questions

Module 12: Customizing the Interface

  • Changing Ribbon Display Options
  • Customizing the Quick Access Toolbar
  • Hiding and Showing Ribbon Tabs
  • Creating Custom Ribbon Tabs
  • Resetting Interface Changes
  • Review Questions
Category: