MS EXCEL

• TED


  Table of Contents
• OW

  Excel interface elements:

  • File Tab
  • Quick Access Toolbar
  • Ribbon
  • Title Bar
  • Help
  • Zoom Control
  • View Buttons
  • Sheet Area
  • Row Bar
  • Column Bar
  • Status Bar
  • Dialog Box Launcher
• EXCEL

  Workbook information:

  • Sheet Information
  • Sheet Properties
  • Exit Backstage View
• UES

  Navigating in Excel:

  • Moving with Mouse
  • Moving with Scroll Bars
  • Moving with Keyboard
  • Moving with Go To Command
• K

  Saving:

  • Saving New Sheet
  • Saving New Changes
• HEET

  Managing Worksheets:

  • Creating New Worksheet
  • Copy Worksheet
  • Hiding Worksheet
  • Unhiding Worksheet
  • Delete Worksheet
• ET


  Closing Workbook
• K

  Entering Data:

  • Inserting Data
  • Inserting Formula
  • Modifying Cell Content
• Select


  Selecting Cells:

  • Select with Mouse
  • Select with Special
• Delete

  Deleting Cells:

  • Delete with Mouse
  • Delete with Delete Key
  • Selective Delete for Rows
• UMNS

  Rows and Columns:

  • Row and Column Basics
  • Navigation with Rows and Columns
  • Cell Introduction
• TE


  Copying and Pasting:

  • Copy Paste
  • Copy Paste using Office Clipboard
  • Copy Paste in Special way
• LACE

  Find and Replace:

  • Find and Replace Dialogue
  • Exploring Options
• Spell Check


  Spell Checking:

  • Spell Check Basis
  • Exploring Options
• Zoom


  Zooming:

  • Zoom Slider
  • Zoom In
  • Zoom Out
• OLS


  Inserting Symbols and Special Characters:

  • Using Symbols
  • Using Special Characters
• NTS

  Cell Comments:

  • Adding Comment to Cell
  • Modifying Comment
  • Formatting Comment
• Text Boxes

  Adding and Formatting Text Boxes
• Undo and Redo

  Undoing and Redoing Changes
• FORMATTING CELL

  Cell Formatting:

  • Formatting Cell
  • Various Cell Formats
• Font

  Formatting Font:

  • Setting Font from Home
  • Setting Font from Format Cell Dialogue
• Text-Decoration


  Formatting Text Decoration:

  • Text-Decoration
  • More Text-Decoration Options
• Rotate


  Rotating Cell Content:

  • Rotating Cell from Home Tab
  • Rotating Cell from Formatting Cell
• Colors


  Changing Cell Colors:

  • Changing Background Color
  • Changing Foreground Color
• Alignment

  Changing Cell Alignment:

  • Change Alignment from Home Tab
  • Change Alignment from Format Cells
  • Exploring Alignment Options
• Merge


  Merging Cells:

  • Merge Cells
  • Additional Options
  • Wrap Text and Shrink to Fit
• Borders and Shading

  Applying Borders and Shading:

  • Apply Borders
  • Apply Shading
• Formatting


  Advanced Cell Formatting:

  • Formatting Cells
  • Alternative to Placing Background
• Sheet Options


  Customizing Worksheet Options:

  • Sheet Options
  • Options in Sheet Options Dialogue
• Page Setup


  Page Layout Options:

  • Margins
  • Center on Page
• Page Orientation

  Changing Page Orientation:

  • Page Orientation
  • Types of Page Orientation
  • Changing Page Orientation
• Header and Footer


  Adding and Customizing Header and Footer:

  • Header and Footer
  • Adding Header and Footer
  • Other Header and Footer Options
• Page Orientation


  The direction in which a page is displayed
• Types of Page Orientation

  • Not provided
• Changing Page Orientation

  Not provided
• Header and Footer


  Text that appears at the top (header) or bottom (footer) of every page
• Adding Header and Footer

  Not provided
• Other Header and Footer Options

  • Not provided
• Page Breaks


  Marks the end of one page and the beginning of the next
• Inserting Page Breaks


  Not provided