Excel Introduction

What is Microsoft Excel?

Starting Excel

The Excel Screen

The Tab-and-Ribbon Interface

The Quick Access Toolbar

Keyboard Shortcuts

Using Help

 

Workbooks and Worksheets

The Structure of Excel Files

XLS and XML

Opening an Existing Workbook

Saving a Workbook

Starting a New Workbook

Navigating a Workbook

Managing Worksheets

 

Entering Information

Spreadsheet Information

Formatting Cells for Specific Contents

Entering Labels

Using Numbers as Labels

Using Spellcheck

Using AutoComplete

Entering Numbers

Using Currency and other formats

Date and Time

Using Percentages

Using Fractions

Selecting a Range

Using Autofill

 

Entering Formulas

Basic Formulas

Order of Operations (BODMAS)

Basic Mathematical Functions

Using SUM

Using AVERAGE

Using COUNT

Using MAX

Using MIN

Using AutoSum

Referencing Other Cells in Formulas

Multiple Worksheets and WorkBooks

Referencing Cells in Other WorkSheets

Referencing Cells in Other Workbooks

Opening Workbooks with External References

 

Formatting Workbooks

Editing Cell Contents

Selecting Cells

Copying and Moving Cells

The Clipboard

Inserting and Deleting Cells, Rows and Columns

Using Undo and Redo

Using Find and Replace

Cell Comments

Formatting Cell Content

Advanced Cell Formatting

AutoFormat

Using Format Painter

Row Height and Column Width

Cell Styles

Themes

 

Charts

Chart Types

Creating a Chart

Formatting and Editing Chart Objects

Changing the Source Data of a Chart

Charging a Charts Type

Annotating Charts

 

Sorting data

Sorting Data

Multilevel Sorting

Filtering a List With AutoFilter

 

Printing a Worksheet

Using Print Preview

Printing a Large WorkSheet

Printing a Chart

Additional Print Options