skip navigation

Florida Gulf Coast University

Website Directory  

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.