Introduction

Launching Excel

Introduction to the excel interface

Customizing the excel quick access toolbar

Saving an excel document

Opening an existing excel document

Understanding the structure of an excel work book

5. Using the AutoSum Command

1. Entering Text to Create Spreadsheet Titles

2. Working with Numeric Data and Entering Date Values in Excel

3. Creating Basic Formulas in Excel

4. Relative Versus Absolute Cell References in Formulas

5. Understanding the Order of Operation

1. The structure of an Excel Function

2. Working with the SUM() Function

3. Working with the MIN() and MAX() Functions

4. Working with the AVERAGE() and COUNT() Functions

1. Moving and Copying Data in an Excel Worksheet

2 Inserting and Deleting Rows and Columns

3. Changing the Width and Height of Cells

4. Hiding and Unhiding Excel Rows and Columns

5. Deleting and Renemaing an Excel Worksheet

6. Moving and Copying and Excel Worksheet

1. Working with Font Formatting Commands

2. Changing the Background Color of a Cell

3. Adding Borders to Cells

4. Formatting Data as Currency Values and Percentage

5. Using Excel's Format Painter

6. Creating Styles to Format Data

1. Inserting Images

2. Inserting Excel Shapes

3. Formatting Excel Shapes

4. Working with Excel SmartArt

1. Creating an Excel Column Chart

2. Working with the Excel Chart Ribbon

3. Adding and Modifying Data on an Excel Chart

4. Formatting an Excel Chart

5. Moving a Chart to another Worksheet

6. Working with Excel Pie Charts

1. Viewing your Document in Print Preview

2. Changing the Margins, Scaling and Orientation

3. Working with Page Layout View

4. Adding Header and Footer Content

5. Printing a Specific Range of Cells

1. Intro to Excel Templates

2. Opening an Existing Template

3. Creating a Custom Template

Congratulations! You've Completed Beginners Section