Yawn-proof software training

The Basics...

This module begins by covering how to sign into an account. Also covered are the parts of a workbook along with how to create, open, and save workbooks.

  • Signing In
  • Creating a New Workbook
  • Parts of a Workbook
  • Saving a Workbook
  • Opening a Workbook

Your First Workbook

Next up is how to enter, select, and delete data. How to undo and redo is also covered, along with using cut, copy, and paste functions.

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

Working with Data

This module covers inserting rows and columns along with how to merge and split cells. Additional topics include using Paste Special, find and replace, and hiding and unhiding cells.

  • 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

Cell references and formulas are covered in this module. Also discussed is how to use basic formulas, using basic and advanced functions, and how to run spell checker. How to use the sort and filter tools to organize data is also covered.

  • Understanding Cell References and Formulas
  • Using Basic Formulas
  • Using Basic Functions
  • Using Advanced Functions
  • Using Spell Check
  • Using Sort and Filter

Using Timesaving Tools

Timesaving is the focus of this module. Participants will learn how to use AutoFill, Flash Fill, AutoSum, AutoComplete, and AutoCalculate.

  • Using AutoFill
  • Using Flash Fill
  • Using AutoSum
  • Using AutoComplete
  • Using AutoCalculate

Formatting Text

Various ways to format and work with text are the main points of this module. Ways to change font face, size, and color, apply text effects, and add borders and fill to cells are all covered. Other topics include using the Font tab of the Format Cells dialog and how to clear formatting from 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

There are many ways to format data in Excel 2013. This module looks at how to adjust text wrapping, change the size of rows and columns, adjust cell alignment, change text direction, and apply number formatting.

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

Formatting the Workbook

This module will teach how to use cell styles, format data as a table, and change the theme of a workbook. Also covered is inserting page breaks and adding a background image.

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

Inserting Art and Objects

Inserting SmartArt, text boxes, and equations into worksheets is covered in this module. Also touched upon is how to draw shapes on worksheets.

  • Inserting SmartArt
  • Inserting Text Boxes
  • Inserting Pictures
  • Inserting Equations
  • Drawing Shapes

Charting Data

Various methods to chart data in Excel 2013 are covered in this module. Topics include how to create Sparkline’s and timelines, plus how to insert PivotTables and PivotCharts, and use Slicers.

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

Viewing, Printing, and Sharing Your Workbook

Ways to view and distribute a workbook are covered in this module. Topics include using views, saving a workbook as PDF or XPS, printing and e-mailing a workbook, and sharing a workbook on SkyDrive.

  • Using Views
  • Saving a Workbook as PDF or XPS
  • Printing a Workbook
  • E-Mailing a Workbook
  • Sharing Your Workbook on SkyDrive

Customizing the Interface

The final module of this course focuses on ways to customize the interface. Topics for discussion include how to change ribbon display options and how to customize the Quick Access toolbar. Also covered is how to hide and show ribbon tabs and create custom ribbon tabs. How to reset the interface is covered as well.

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

Download Full Course Details as a PDF

Share this printable PDF with others in the office.

Download Now