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

01. 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

02. 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

03. 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

04. 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

05. 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

06. Printing

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

07. 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

08. Adjusting Worksheet Views

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

09. 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

10. 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

11. Security and Sharing

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

12. Database Features

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

13. PivotTables

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

14. Introduction to Macros

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

Skills Learned

After completing this online training course, students will be able to:

  • How to enter and work with data
  • Creating formulas, using SUM and AVERAGE
  • How to format font and utilize conditional formatting
  • Adding and subtracting columns and rows
  • Chart creation, formatting, and elements
  • How to adjust the view of the worksheet
  • How to use multiple worksheets
  • VLOOKUP and Power functions
  • How to protect worksheets and unlock cells
  • Create PivotTables
  • Manipulating PivotTable data
  • Creating and running a simple macro