Quick Source Learning | Quick Source Learning | Excel 2013 Basic Course

Excel 2013 Basic Course

excel 2013

 

"


 

E13B

The Quick Source eLearning Series combines three levels of training: Learn It, Try It, and Evaluation. The Learn It section includes high quality video that shows you everything the instructor is teaching. The Try It section allows you to practice what you have learned right in our course. There is no need to switch between the course, and the software that you are learning. The Evaluation section gives you the ability to test your knowledge and receive immediate feedback.


Topics covered in this course:

Getting Started

  • Introduction
  • Starting and Exiting Microsoft Excel 2013
  • Identifying the Parts of the Excel 2013 Window
  • Accounts and Services
  • Using the Ribbon
  • Using the Backstage View
  • Creating a New Workbook
  • Opening a Workbook
  • Saving a Workbook

Workbooks and Worksheets

  • Introduction
  • Inserting a Worksheet
  • Renaming and Deleting a Worksheet
  • Moving or Copying a Worksheet
  • Color Coding Worksheet Tabs
  • Creating Headers and Footers
  • Viewing Multiple Workbooks or Worksheets
  • Comparing Workbooks or Worksheets Side by Side

Cells, Rows and Columns

  • Introduction
  • Selecting Cells, Rows, or Columns
  • Inserting Cells
  • Inserting a Row or Column
  • Adjusting Row Height or Column Width
  • Deleting a Cell, Row or Column
  • Merging Cells
  • Naming a Cell or Range of Cells

Data and Views

  • Introduction
  • Entering Data
  • Using AutoFill and FlashFill
  • Moving or Copying Data
  • Using Sparklines
  • Sorting and Filtering Data
  • Freezing a Row or Column
  • Splitting Worksheet Panes

Formatting Cells

  • Introduction
  • Specifying a Number Format for a Cell
  • Changing the Font, Font Size, and Color
  • Using the Mini Toolbar
  • Aligning Text
  • Formatting Cell Borders
  • Applying Shading to Cells
  • Clearing Cell Formats or Contents

Working with Formulas

  • Introduction
  • Creating and Editing a Formula
  • Inserting a Function
  • Using the Function Library
  • Using the Sum Button
  • Moving or Copying a Formula
  • Working with Formulas
  • Using the Watch Window

Illustrations and Charts

  • Introduction
  • Inserting a Picture
  • Inserting a Shape
  • Inserting a SmartArt Graphic
  • Inserting a Chart
  • Working with Chart Design Tools
  • Working with Chart Format Tools
  • Using Quick Analysis

Output and Getting Help

  • Introduction
  • Changing Page Setup
  • Setting Up the Print Area
  • Printing Gridlines and Headings
  • Previewing and Printing a Workbook
  • Exporting a Workbook as a Different File Type
  • Sharing a Workbook
  • Using Excel Help