Basic MS. Excel 2016

Course Content

Lesson 1: Creating a Basic Worksheet
Explore the User Interface and the Ribbon • Navigate and Select in Excel • Obtain Help • Enter Data and Save a Workbook • Customize the Quick Access Toolbar

Lesson 1: Creating a Basic Worksheet
Lesson 1

Lesson 2: Performing Calculations
• Create Basic Formulas • Calculate with Functions • Copy Formulas and Functions

Lesson 3: Modifying a Worksheet
• Manipulate Data • Insert and Delete Cells, Columns, and Rows • Search for Data in a Worksheet • Spell Check a Worksheet

Lesson 4: Formatting a Worksheet
• Modify Fonts • Add Borders and Color to Cells • Change Column Width and Row Height • Apply Number Formats • Position Cell Contents • Apply Cell Styles

Lesson 5: Printing Workbook Contents
• Print Workbook Contents Using Default Print Options • Set Print Options • Set Page Breaks

Lesson 6: Managing Large Workbooks
• Format Worksheet Tabs • Manage Worksheets in a Workbook • Manage the View of Large Worksheets

Lesson 7: Inserting Graphic Objects
• Insert and Modify Pictures and ClipArt • Draw and Modify Shapes • Illustrate Workflow Using SmartArt Graphics • Layer and Group Graphic Objects

Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.

Student Ratings & Reviews

No Review Yet

What Will You Learn?

Course Content

Lesson 1: Creating a Basic Worksheet
Explore the User Interface and the Ribbon • Navigate and Select in Excel • Obtain Help • Enter Data and Save a Workbook • Customize the Quick Access Toolbar

Lesson 1: Creating a Basic Worksheet

Lesson 1

Lesson 2: Performing Calculations
• Create Basic Formulas • Calculate with Functions • Copy Formulas and Functions

Lesson 2: Performing Calculations

Lesson 2

Lesson 3: Modifying a Worksheet
• Manipulate Data • Insert and Delete Cells, Columns, and Rows • Search for Data in a Worksheet • Spell Check a Worksheet

Lesson 3: Modifying a Worksheet

Lesson 3: Modifying a Worksheet

Lesson 4: Formatting a Worksheet
• Modify Fonts • Add Borders and Color to Cells • Change Column Width and Row Height • Apply Number Formats • Position Cell Contents • Apply Cell Styles

Lesson 4: Formatting a Worksheet

Lesson 5: Printing Workbook Contents
• Print Workbook Contents Using Default Print Options • Set Print Options • Set Page Breaks

Lesson 5: Printing Workbook Contents

Lesson 6: Managing Large Workbooks
• Format Worksheet Tabs • Manage Worksheets in a Workbook • Manage the View of Large Worksheets

Lesson 6: Managing Large Workbooks

Lesson 7: Inserting Graphic Objects
• Insert and Modify Pictures and ClipArt • Draw and Modify Shapes • Illustrate Workflow Using SmartArt Graphics • Layer and Group Graphic Objects

Lesson 7: Inserting Graphic Objects

Earn a certificate

What Will You Learn?

Course Content

Lesson 1: Creating a Basic Worksheet Explore the User Interface and the Ribbon • Navigate and Select in Excel • Obtain Help • Enter Data and Save a Workbook • Customize the Quick Access Toolbar

Lesson 1: Creating a Basic Worksheet

Lesson 1

Lesson 2: Performing Calculations • Create Basic Formulas • Calculate with Functions • Copy Formulas and Functions

Lesson 2: Performing Calculations

Lesson 2

Lesson 3: Modifying a Worksheet • Manipulate Data • Insert and Delete Cells, Columns, and Rows • Search for Data in a Worksheet • Spell Check a Worksheet

Lesson 3: Modifying a Worksheet

Lesson 3: Modifying a Worksheet

Lesson 4: Formatting a Worksheet • Modify Fonts • Add Borders and Color to Cells • Change Column Width and Row Height • Apply Number Formats • Position Cell Contents • Apply Cell Styles

Lesson 4: Formatting a Worksheet

Lesson 5: Printing Workbook Contents • Print Workbook Contents Using Default Print Options • Set Print Options • Set Page Breaks

Lesson 5: Printing Workbook Contents

Lesson 6: Managing Large Workbooks • Format Worksheet Tabs • Manage Worksheets in a Workbook • Manage the View of Large Worksheets

Lesson 6: Managing Large Workbooks

Lesson 7: Inserting Graphic Objects • Insert and Modify Pictures and ClipArt • Draw and Modify Shapes • Illustrate Workflow Using SmartArt Graphics • Layer and Group Graphic Objects

Lesson 7: Inserting Graphic Objects

Earn a certificate

Student Ratings & Reviews

Lesson 1: Creating a Basic Worksheet
Explore the User Interface and the Ribbon • Navigate and Select in Excel • Obtain Help • Enter Data and Save a Workbook • Customize the Quick Access Toolbar

Lesson 2: Performing Calculations
• Create Basic Formulas • Calculate with Functions • Copy Formulas and Functions

Lesson 3: Modifying a Worksheet
• Manipulate Data • Insert and Delete Cells, Columns, and Rows • Search for Data in a Worksheet • Spell Check a Worksheet

Lesson 4: Formatting a Worksheet
• Modify Fonts • Add Borders and Color to Cells • Change Column Width and Row Height • Apply Number Formats • Position Cell Contents • Apply Cell Styles

Lesson 5: Printing Workbook Contents
• Print Workbook Contents Using Default Print Options • Set Print Options • Set Page Breaks

Lesson 6: Managing Large Workbooks
• Format Worksheet Tabs • Manage Worksheets in a Workbook • Manage the View of Large Worksheets

Lesson 7: Inserting Graphic Objects
• Insert and Modify Pictures and ClipArt • Draw and Modify Shapes • Illustrate Workflow Using SmartArt Graphics • Layer and Group Graphic Objects