Introduction

Help Center → Introduction

Microsoft Excel is a spreadsheet program. It provides you with the tools you need to organize, analyze and display data in a professional way.

Spreadsheet Basics
  • The Excel interface
  • Office Button & Ribbon
  • Shortcut Menu
  • Spreadsheet basics
  • Adding and renaming worksheets
Modifying A Worksheet
  • Moving through cells
  • Adding rows and columns
  • Resizing rows and columns
  • Selecting cells
  • Cutting, copying, and pasting cells
  • Freeze panes
Formatting Cells
  • Formatting individual cells
  • Dates and times
  • Styles
  • Creating a new style
  • Format Painter


Formulas and Functions
  • Formulas
  • Linking worksheets
  • Relative, absolute, and mixed referencing
  • Basic functions
  • Function Wizard
  • Autosum
Sorting and Filling
  • Basic ascending and descending sorts
  • Complex sorts
  • Autofill
  • Autofilling functions
Charts
  • Chart Wizard
  • Resizing and moving charts
  • Chart formatting toolbar
  • Copying a chart to Microsoft Word
Quick Access Toolbar
  • Creating a Quick Access Toolbar
Keyboard Shortcuts
  • Shortcut references
  • Finding shortcuts