Excel 2013 Core Essentials

Course Description

This one-level course covers all the essentials of Microsoft Excel 2013. Topics covered include the new Flash Fill feature, using formulas and functions, inserting PivotTables and PivotCharts, and customizing the interface. Material is also included on how to format text, data, and workbooks; insert art and objects; and chart data.
1 Day
Contact us for pricing
Contact us for dates
Contact us for dates

Prerequisites

Participants are expected to be IT literate. This is not an introduction to computers course.

The Basics

Getting Started
Signing In
Creating a New Workbook
Parts of a Workbook
Saving a Workbook
Opening a Workbook

Your First Workbook

Selecting Data
Entering and Deleting Data
Using Undo and Redo
Using Cut, Copy, and Paste

Working with Data

Inserting Rows and Columns
Merging and Splitting Cells
Moving Cells
Using Paste Special
Using Find and Replace
Hiding and Unhiding Cells

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

Using Timesaving Tools

Using AutoFill
Using Flash Fill
Using AutoSum
Using AutoComplete
Using AutoCalculate

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

Formatting Data

Wrapping Text
Changing the Size of Rows and Columns
Adjusting Cell Alignment
Changing Text Direction
Changing Number Format

Formatting the Workbook

Using Cell Styles
Formatting Data as a Table
Changing the Theme
Inserting Page Breaks
Adding a Background

Inserting Art and Objects

Inserting SmartArt
Inserting Text Boxes
Inserting Pictures
Inserting Equations
Drawing Shapes

Charting Data

Creating Sparklines
Inserting Charts
Inserting PivotTables
Inserting PivotCharts
Using Slicers
Creating Timelines

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

Customizing the Interface

Changing Ribbon Display Options
Customizing the Quick Access Toolbar
Hiding and Showing Ribbon Tabs
Creating Custom Ribbon Tabs
Resetting Interface Changes

ExcelExcel 2013Microsoft ExcelMIcrosoft Excel 2013MS Excel