Excel

Training is available using Microsoft Office Suite for:  Access, Excel, PowerPoint,  and Word.

MS Excel Training

Getting Started

  • Spreadsheets
  • Microsoft Office Button
  • Ribbon
  • Quick Access Toolbar
  •  Mini Toolbar

 Customize Excel

  •  Popular Formulas
  • Proofing
  • Save
  •  Advanced Customize

Working with a Workbook

  • Create a Workbook
  • Save a Workbook
  • Open a Workbook
  • Enter Data

 Manipulating Data

  • Select Data
  • Copy and Paste
  • Cut 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

Design Charts

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

Format Worksheets

  • Convert Text to Columns
  • Modify Fonts
  • Format Cells Dialog Box

Leave a Reply

%d bloggers like this: