Table of Contents

 Opening Excel .....................................................................................................................

Getting Started......................................................................................................................

The Excel Interface .......................................................................................................................

The Application Window ............................................................................................................... 

The Workbook Window................................................................................................................

Creating and Opening Workbooks....................................................................................................... .

Create a new blank workbook ..................................................................................................... .

Open an existing workbook ......................................................................................................... .

Compatibility mode..................................................................................................................... .

Saving and Sharing Workbooks ...........................................................................................................

Save and Save As..........................................................................................................................

   AutoRecover...............................................................................................................................

. Exporting workbooks................................................................................................................... .

Cell Basics ..................................................................................................................................................

. Understanding Cells..............................................................................................................................

Cell Content..........................................................................................................................................

Find and Replace ................................................................................................................................ .

Formatting Cells......................................................................................................................................... .

Font Formatting.................................................................................................................................. .

Text Alignment ................................................................................................................................... .

Cell borders and fill colors................................................................................................................... .

Cell styles ............................................................................................................................................

Formatting text and numbers ............................................................................................................. .

Modifying Columns, Rows and Cells............................................................................................................ .

Inserting, deleting, moving, and hiding rows and columns.....................................................................

Wrapping text and merging cells......................................................................................................... .

Formulas and Functions................................................................................................................................

Simple Formulas...................................................................................................................................

Complex Formulas.............................................................................................................................. .

Relative and Absolute Cell References......................................................................................... 

Relative cell references ............................................................................................................... .

 Absolute cell references.............................................................................................................. 

Excel Training - Level 1 .

Functions.........................................................................................................

Creating a function...................................................................................................................... .

The Function Library ....................................................................................................................

The Insert Function command.....................................................................................................

Working with Data...................................................................................................................................... 

Freezing Panes and View Options........................................................................................................

Sorting Data........................................................................................................................................

Filtering Data......................................................................................................................................

Working with Charts................................................................................................................................... 

Understanding charts ......................................................................................................................... 

Chart layout and style......................................................................................................................... .

Other chart options ..............................................................................................................................

Printing Workbooks....................................................................................................................................

Choosing a print area.......................................................................................................................... 

Fitting and scaling content..................................................................................................................