Office 365: Excel 2013 Essentials

Course Overview

Microsoft Office 365 gives you the familiarity and power of Office with the flexibility of the cloud. With Office in the cloud, your applications and files are with you wherever you go, whether you’re working offline at your desktop, online, or on one of your devices.

Course Outline

Getting Started with Excel 2013

  • Using the menu system
  • The Quick Access Toolbar
  • The structure of a worksheet or workbook
  • Using the Formula bar
  • Using the Status bar
  • Navigation and mouse pointers
  • Shortcut menus and the Mini toolbar
  • Using the built-in help
  • Creating new files

Entering Data

  • Exploring data entry and editing techniques
  • Entering data with AutoFill
  • Working with dates and times
  • Using Undo and Redo
  • Adding comments
  • Using Save or Save As

Creating Formulas and Functions

  • Creating simple formulas: Totals and averages
  • Copying a formula for adjacent cells
  • Calculating year-to-date profits
  • Creating a percentage-increase formula
  • Working with relative, absolute, and mixed references
  • Using SUM and AVERAGE
  • Using other common functions

Formatting

  • Exploring font styles and effects
  • Adjusting row heights and column widths
  • Working with alignment and Wrap Text
  • Designing borders
  • Exploring numeric and special formatting
  • Formatting numbers and dates
  • Conditional formatting
  • Creating and using tables
  • Inserting shapes, arrows, and other visual features

Adjusting Worksheet Layout and Data

  • Inserting and deleting rows and columns
  • Hiding and unhiding rows and columns
  • Moving, copying, and inserting data
  • Finding and replacing data

Printing

  • Exploring the Page Layout tab and view
  • Previewing page breaks
  • Working with Page Setup and printing controls

Introduction to Charting

  • Creating charts
  • Exploring chart types
  • Formatting charts
  • Working with axes, labels, gridlines, and other chart elements
  • Creating in-cell charts and sparklines

Adjusting Worksheet Views

  • Freezing and unfreezing panes
  • Splitting screens horizontally and vertically
  • Showing necessary information with the Outlining feature

Multiple Worksheets and Workbooks

  • Displaying multiple worksheets and workbooks
  • Renaming, inserting, and deleting sheets
  • Moving, copying, and grouping sheets
  • Using formulas to link worksheets and workbooks
  • Locating and maintaining links

IF, VLOOKUP, and Power Functions

  • Using IF functions and relational operators
  • Getting approximate table data with the V LOOKUP function
  • Getting exact table data with the V LOOKUP function
  • Using the COUNTIF family of functions

Security and Sharing

  • Unlocking cells and protecting worksheets
  • Protecting workbooks
  • Assigning passwords to workbooks
  • Sharing workbooks
  • Tracking changes

Database Features

  • Sorting data
  • Inserting subtotals in a sorted list
  • Using filters
  • Splitting data into multiple columns
  • Removing duplicate records

PivotTables

  • Creating PivotTables
  • Manipulating PivotTable data
  • Grouping by data, time, and other factors
  • Using slicers to clarify and manipulate fields
  • Using PivotCharts

Introduction to Macros

  • Definition and examples
  • Creating a simple macro
  • Running a macro