Excel 2013 Core Essentials Course Outline

Excel 2013 Core Essentials

Module 1: The Basics

Getting Started

Signing In

Creating a New Workbook

Parts of a Workbook

Saving a Workbook

Opening a Workbook

Review Questions

Module 2: Your First Workbook

Selecting Data

Entering and Deleting Data

Using Undo and Redo

Using Cut, Copy, and Paste

Review Questions

Module 3: Working with Data

Inserting Rows and Columns

Merging and Splitting Cells

Moving Cells

Using Paste Special

Using Find and Replace

Hiding and Unhiding Cells

Review Questions

Module 4: Using Basic Excel Tools

Understanding Cell References and Formulas

Using Basic Formulas

Using Basic Functions

Using Advanced Functions

Using Spell Check

Using Sort and Filter

Review Questions

Module 5: Using Timesaving Tools

Using AutoFill

Using Flash Fill

Using AutoSum

Using AutoComplete

Using AutoCalculate

Review Questions

Module 6: Formatting Text

Changing the Font Face, Size, and Color

Applying Text Effects

Applying Borders and Fill

Using the Font Tab of the Format Cells Dialog

Clearing Formatting

Review Questions

Module 7: Formatting Data

Wrapping Text

Changing the Size of Rows and Columns

Adjusting Cell Alignment

Changing Text Direction

Changing Number Format

Review Questions

Module 8: Formatting the Workbook

Using Cell Styles

Formatting Data as a Table

Changing the Theme

Inserting Page Breaks

Adding a Background

Review Questions

Module 9: Inserting Art and Objects

Inserting SmartArt

Inserting Text Boxes

Inserting Pictures

Inserting Equations

Drawing Shapes

Review Questions

Module 10: Charting Data

Creating Sparklines

Inserting Charts

Inserting PivotTables

Inserting PivotCharts

Using Slicers

Creating Timelines

Review Questions

Module 11: Viewing, Printing, and Sharing Your Workbook

Using Views

Saving a Workbook as PDF or XPS

Printing a Workbook

E-Mailing a Workbook

Sharing Your Workbook on SkyDrive

Review Questions

Module 12: Customizing the Interface

Changing Ribbon Display Options

Customizing the Quick Access Toolbar

Hiding and Showing Ribbon Tabs

Creating Custom Ribbon Tabs

Resetting Interface Changes

Review Questions