Microsoft Excel 101 Course Introduction (Beginners section)

Microsoft Excel Fundamentals

8 Parts

Launching Excel

2 min

Saving an excel document

3 min

Opening an existing excel document

1 min

Understanding the structure of an excel work book

4 min

5. Using the AutoSum Command

4 min

2 min

Introduction to the excel interface

5 min

Customizing the excel quick access toolbar

5 min

Entering and Editing Text and Formulas

5 Parts

1. Entering Text to Create Spreadsheet Titles

6 min

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

6 min

3. Creating Basic Formulas in Excel

5 min

4. Relative Versus Absolute Cell References in Formulas

8 min

5. Understanding the Order of Operation

2 min

Working with Basic Excel Functions

4 Parts

1. The structure of an Excel Function

3 min

2. Working with the SUM() Function

5 min

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

3 min

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

4 min

Modifying an Excel Worksheet

6 Parts

1. Moving and Copying Data in an Excel Worksheet

3 min

2 Inserting and Deleting Rows and Columns

6 min

3. Changing the Width and Height of Cells

3 min

4. Hiding and Unhiding Excel Rows and Columns

2 min

5. Deleting and Renemaing an Excel Worksheet

2 min

6. Moving and Copying and Excel Worksheet

3 min

Formatting Data in an Excel Worksheet

6 Parts

3. Adding Borders to Cells

2 min

4. Formatting Data as Currency Values and Percentage

4 min

5. Using Excel's Format Painter

2 min

6. Creating Styles to Format Data

5 min

2. Changing the Background Color of a Cell

3 min

1. Working with Font Formatting Commands

3 min

Inserting Images and Shapes into an Excel Worksheet

4 Parts

1. Inserting Images

3 min

2. Inserting Excel Shapes

2 min

3. Formatting Excel Shapes

3 min

4. Working with Excel SmartArt

3 min

Creating Basic Charts in Excel

6 Parts

4. Formatting an Excel Chart

4 min

1. Creating an Excel Column Chart

4 min

2. Working with the Excel Chart Ribbon

4 min

3. Adding and Modifying Data on an Excel Chart

3 min

5. Moving a Chart to another Worksheet

2 min

6. Working with Excel Pie Charts

3 min

Printing an Excel Worksheet

5 Parts

1. Viewing your Document in Print Preview

2 min

2. Changing the Margins, Scaling and Orientation

7 min

3. Working with Page Layout View

4 min

4. Adding Header and Footer Content

4 min

5. Printing a Specific Range of Cells

2 min

Working with Excel Templates

3 Parts

1. Intro to Excel Templates

2 min

2. Opening an Existing Template

4 min

3. Creating a Custom Template

5 min

Congratulations! You've Completed Beginners Section

1 Parts

Congratulations! You've Completed Beginners Section

1 min

Microsoft Excel 101 Course Introduction (Beginners section)

About Course

Share