Microsoft Excel 2010

  • Link: Microsoft Excel 2010
  • Topic: Basic Computer Skills, Microsoft Office Tutorials
  • Type: Course
  • Format: GCFLearnFree
  • Related Resource:

Description:

Excel 2010 is a spreadsheet software in the new Microsoft 2010 Office Suite.

Excel allows you to store, manipulate and analyze data in organized workbooks for home and business tasks. New innovations in Excel 2010 include the enhanced data viewing features of Sparklines and Slicers.

Topics include:

Excel Basics

  • Getting Started with Excel
  • Cell Basics
  • Modifying Columns, Rows, and Cells
  • Formatting Cells
  • Saving
  • Creating Simple Formulas
  • Worksheet Basics
  • Printing

Common Tasks in Excel

  • Creating Complex Formulas
  • Working with Basic Functions
  • Sorting Data
  • Outlining Data
  • Filtering Data
  • Formatting Tables

Doing More with Excel

  • Reviewing and Sharing Workbooks
  • Using Templates
  • Working with Charts
  • Working with Sparklines
  • Using Conditional Formatting
  • Creating PivotTables
  • Using What-If Analysis