About Excel Courses

Excel courses are designed to help you with your daily work-related tasks. Redeem your coupon to browse the courses and enjoy the learning experience. If you have already redeemed your coupon, log in to go through the different courses.

Getting Started With Excel 2013

This course introduces Excel 2013 and describes the components in the Excel 2013 interface. It also demonstrates the procedures to perform basic workbook and data management tasks.

At the end of this course, you will be able to:

  • Describe the various components of the Excel 2013 interface
  • Customize the Excel 2013 interface
  • Describe various options in the File menu
  • Create, save, open, and navigate an Excel workbook.
  • Enter, edit, and select data in a worksheet
  • Change the data format
  • Enter data in a series using the fill handle
  • Copy, paste, and move data
  • Undo and redo changes
  • Split text across multiple cells
  • Search and replace data
  • Insert and delete cells, rows, and columns
  • Hide and unhide data

Building Workbooks

This course focuses on tasks related to managing workbooks and worksheets. It also covers various aspects of printing worksheets.

At the end of this course, you will be able to:

  • Format worksheet tabs
  • Move worksheets within and between workbooks
  • Copy worksheets within and between workbooks
  • Insert and delete worksheets from a workbook
  • Hide and unhide worksheets
  • View multiple workbooks
  • Set up page margins and orientation
  • Set up print area and print titles
  • Insert a header and footer
  • Print gridlines and column and row headers
  • Use the Page Layout view
  • Preview and print worksheets

Using Media Elements

This course focuses on inserting different types of media elements in Excel worksheets and arranging and formatting the media elements.

At the end of this course, you will be able to:

  • Insert clip art
  • Insert various shapes
  • Insert SmartArt graphics
  • Insert pictures, background images, and screenshots
  • Format art and graphics using Picture Tools
  • Apply various picture styles to art and graphics
  • Arrange graphic objects in an Excel worksheet
  • Adjust the size of graphic objects
  • Display the result of a formula in a graphic object

Formatting Workbooks

This course covers basic and advanced formatting of workbooks.

At the end of this course, you will be able to:

  • Format font face, size, and color
  • Merge cells
  • Format numbers
  • Align data in various formats
  • Change orientation of text
  • Format cells and change text direction
  • Add borders to cells and data ranges
  • Apply various date formats to cells
  • Apply formatting using the Format Painter
  • Apply themes and customize settings
  • Add, edit, and delete comments
  • Create a custom Auto Fill list
  • Format data as a table
  • Clear cell contents and formatting

Performing Calculations

This course focuses on various ways to perform calculations in Excel by using formulas and functions.

At the end of this course, you will be able to:

  • Add numbers using the plus sign and the SUM formula
  • Subtract numbers
  • Multiply numbers
  • Divide numbers
  • Perform calculations using basic formulas
  • Perform calculations using exponents
  • Explain the order of operations in Excel
  • Copy formulas and functions
  • Display formulas and functions in an Excel worksheet
  • Count cells using the Count() function
  • Calculate averages using the Average () function
  • Find the highest and lowest values in a range
  • Perform calculations using absolute and 3D referencing
  • Perform calculations across worksheets
Skip Login