Microsoft Excel 2010
To schedule a computer training course contact Client Computing at: email@example.com or firstname.lastname@example.org.
Note: Please include your name, contact information and training request with your message.
- Program Fundamentals
- Learn about the main
parts of the program screen, how to give commands, use help, and about new features
in Excel 2010.
- Getting Started with Worksheets
- Will show you the
most basic tasks in Excel: entering labels and numbers, and entering formulas.
- Editing a Worksheet
- 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.
- Formatting a Worksheet
- Explains how to format
a worksheet to make it more visually attractive and easier to read.
- Creating and Working with Charts
- Learn how to create,
edit and format dynamic looking charts.
- Managing Workbooks
- Look at ways to make
viewing and working with data easier.
- More Functions and Formulas
- Learn about more
complex formula writing, how to insert and edit functions, how to define names,
and how to trace formulas and diagnose errors.
- Working with Data Ranges
- Learn how to sort and
filter data in data ranges in several different ways.
- Working with Tables
- 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
- Working with Pivot Tables
- Explains how to
create PivotTables, modify their structure, and create PivotCharts that
graphically illustrate PivotTables.
- Analyzing Data
- 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.
- Working with the Web and External Data
- 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.
- Working with Macros
- Learn how to
record and play a macro and how to write and edit
macros using the Visual Basic programming language.
- Customizing Excel
- 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.