Skip to Main Content

Microsoft Excel 2013 Core Essentials  (MO13EX101)

Time: 9am - 4pm
Duration: 1 day

Compatible with 2013

Description:

In this course you will learn how to: use basic formulas and functions; use time-saving tools (like AutoFill, AutoComplete, AutoSum, and the new Flash Fill); use PivotTables and PivotCharts; format workbooks; insert objects (like SmartArt, charts, and text boxes); export a workbook as PDF or XPS; customize the interface.

Prerequisites:

None

Public Class Schedule

Location Language Date Price Register
Ottawa English April 12 $ 275.00
Web-based(Opens in new window) English April 12 $ 275.00

We're Here to Help

Don't see the dates you need? Call us at 888.484.2933 or Tell Us What You Need.

Course Outline

  • Module 1: The Basics
    • Getting Started
    • Signing In
    • Creating a New Workbook
    • Parts of a Workbook
    • Saving a Workbook
    • Opening a Workbook
  • Module 2: Your First Workbook
    • Selecting Data
    • Entering and Deleting Data
    • Using Undo and Redo
    • Using Cut, Copy, and Paste
  • 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
  • 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
  • Module 5: Using Timesaving Tools
    • Using AutoFill
    • Using Flash Fill
    • Using AutoSum
    • Using AutoComplete
    • Using AutoCalculate
  • 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
  • Module 7: Formatting Data
    • Wrapping Text
    • Changing the Size of Rows and Columns
    • Adjusting Cell Alignment
    • Changing Text Direction
    • Changing Number Format
  • Module 8: Formatting the Workbook
    • Using Cell Styles
    • Formatting Data as a Table
    • Changing the Theme
    • Inserting Page Breaks
    • Adding a Background
  • Module 9: Inserting Art and Objects
    • Inserting SmartArt
    • Inserting Text Boxes
    • Inserting Pictures
    • Inserting Equations
    • Drawing Shapes
  • Module 10: Charting Data
    • Creating Sparklines
    • Inserting Charts
    • Inserting PivotTables
    • Inserting PivotCharts
    • Using Slicers
    • Creating Timelines
  • 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
  • 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

Private training is available for this course.

Call us at 1-888-484-2933 to learn more about our flexible scheduling options or complete our Information Request Form.

© 2017 Eliquo, Inc. All rights reserved.

Back to Top