Course Program

Introducing Excel

Workbooks and Worksheets. The Ribbon. Shortcut menus and Quick Access Toolbar. Some introductory activities in Excel.

Worksheet Operations

Cells. Formatting. Working with Rows and Columns. Working with Cells and Ranges.

Tables

Creating and working with tables.

Formatting

Main methods for worksheet formatting. Adjusting page settings. Printing.

Formulas and Functions

Formulas. Operators. Functions. Cell References. Formulas for text manipulation, for dates and times, for mathematical operations. Looking up values using formulas.

Charts

Creating and customizing charts. Working with charts.

Working with Data

Importing textual data. The Goal Seek tool.

Pivot Tables

Creating and working with pivot tables.