Section 508 Website Accessibility

Certain documents on this site are available as a Portable Document Format (PDF) file. PDF content requires Adobe's Acrobat Reader and can be downloaded by visiting https://get.adobe.com/reader.

The University encourages anyone needing assistance in accessing content found on the University's website to contact the FGCU office or department that maintains the webpage. For an accessible version of PDF material, please contact FGCU Adaptive Services at adaptive@fgcu.edu or by calling 239 590-7956.

Skip to site navigation Skip to main content
Skip to main content
Technology Skills Orientation

Technology Skills Orientation

Excel 2013 Tutorial

 
 

Getting Started

  • Spreadsheets
  • The File Menu Tab
  • Ribbon
  • Quick Access Toolbar
  • Mini Toolbar

Customize Excel

  • General
  • Formulas
  • Proofing
  • Save
  • Advanced
  • Customize

Working with a Workbook

  • Create a Workbook
  • Save a Workbook
  • Open a Workbook
  • Entering Data

Manipulating Data

  • Select Data
  • Select a Row or Column
  • Copy and Paste
  • Undo and Redo
  • Auto Fill

Modifying a Worksheet

  • Insert Cells, Rows and Columns
  • Delete Cells, Rows and Columns
  • Find and Replace
  • Go To Command
  • Spell Check

Performing Calculations

  • Excel Formulas
  • Calculate with Functions
  • Function Library
  • Relative, Absolute, & Mixed Functions
  • Linking Worksheets

Macros

  • Recording a Marco
  • Running a Macro

 

Sort and Filter

  • Basic Sorts
  • Custom Sorts
  • Filter

Graphics

  • Adding a Picture
  • Adding Clip Art
  • Editing Pictures and Clip Art
  • Adding Shapes
  • Adding SmartArt

Charts

  • Create a Chart
  • Modify a Chart
  • Chart Tools
  • Copy a Chart to Word

Formatting a Worksheet

  • Convert Text to Columns
  • Modify Fonts
  • Format Cells Dialog Box
  • Add Borders and Colors to Cells
  • Change Column Width and Row Height
  • Hide or Unhide Rows and Columns
  • Merge Cells
  • Align Cell Contents

Developing a Workbook

  • Format Worksheet Tabs
  • Reposition Worksheets in a Workbook
  • Insert and Delete Worksheets
  • Copy and Paste Worksheets

Page Properties and Printing

  • Set Print Titles
  • Create a Header and a Footer
  • Set Page Margins
  • Change Page Orientation
  • Set Page Breaks
  • Print a Range

Customize the Layout

  • Split a Worksheet
  • Freeze and Unfreeze Rows & Columns
  • Hide and Unhide Worksheets
 

Office 2013 Tutorials · Word · Excel · PowerPoint · Access

FGCU only provides support for Office 2013 to FGCU students, faculty, and staff.