This website is best viewed in a browser that supports web standards.

Skip to content or, if you would rather, Skip to navigation.

Northwest Missouri State University


Microsoft Excel 2010

To schedule a computer training course contact Client Computing at: tab@nwmissouri.edu or kdt@nwmissouri.edu.

Note: Please include your name, contact information and training request with your message.

  1. Program Fundamentals
    1. Learn about the main parts of the program screen, how to give commands, use help, and about new features in Excel 2010.
  2. Getting Started with Worksheets
    1. Will show you the most basic tasks in Excel: entering labels and numbers, and entering formulas.
  3. Editing a Worksheet
    1. Learn how to edit cell contents; cut, copy and paste information; insert and delete columns and rows; undo any mistakes you might make; and even correct your spelling errors.
  4. Formatting a Worksheet
    1. Explains how to format a worksheet to make it more visually attractive and easier to read.
  5. Creating and Working with Charts
    1. Learn how to create, edit and format dynamic looking charts.
  6. Managing Workbooks
    1. Look at ways to make viewing and working with data easier.
  7. More Functions and Formulas
    1. Learn about more complex formula writing, how to insert and edit functions, how to define names, and how to trace formulas and diagnose errors.
  8. Working with Data Ranges
    1. Learn how to sort and filter data in data ranges in several different ways.
  9. Working with Tables
    1. Work with the table data independently from the rest of the worksheet. Quickly sort and filter the table columns, add total rows, and apply table formatting to an Excel table.
  10. Working with Pivot Tables
    1. Explains how to create PivotTables, modify their structure, and create PivotCharts that graphically illustrate PivotTables.
  11. Analyzing Data
    1. Learn about Excel’s tools for analyzing and organizing. These include tools for creating multiple worksheet scenarios, using Goal Seek and Solver tools to perform what-if analysis, and organizing your data by subtotaling, outlining, or consolidating.
  12. Working with the Web and External Data
    1. Learn how to add hyperlinks to your workbooks to link them to another workbook, a file created in another program, or even a Web page.
  13. Working with Macros
    1. Learn how to record and play a macro and how to write and edit macros using the Visual Basic programming language.
  14. Customizing Excel
    1. Focuses on how to customize the Ribbon, the Quick Access Toolbar, and AutoCorrect.  Discusses how to access and review the default options for a program.