Excel 2013 Basic

What does this course offer you?

This elearning course teaches the basics of working with Microsoft Excel 2013. You will get to know the interface of Excel, and create workbooks and worksheets. You will enter text and numbers in the cells and learn general information on formatting and designing tables and content. In addition, you will use common formulas and functions and create charts.

What does this course include?

In addition to the instructional content, practice exercises and test questions are also included.


Course Topics

  • Entering data
  • Changing and deleting cell content
  • Good practice: Creating lists
  • Selecting cells
  • Undoing work
  • Finding and replacing specific cell content
  • Sorting sheets
  • Filtering sheets
  • Copying and moving using drag & drop
  • Using the Auto Fill function
  • Copying and moving using the Clipboard

  • Creating contents tables
  • Formatting a table of contents
  • Using sections
  • Working with columns

  • Selecting rows and columns
  • Inserting or deleting cells
  • Changing column width or row height
  • Freezing rows and columns
  • Worksheets: order and navigation
  • Inserting and deleting worksheets
  • Good practice: Naming worksheets
  • Working with workbooks

  • Good practice: Creating formulas
  • Composing and entering formulas
  • Relative references
  • Absolute references
  • Composition and entering functions
  • Structure of the IF function
  • Using the IF function
  • Finding errors in formulas

  • Formatting numbers
  • Formatting text
  • Assigning background color
  • Copying formats
  • Automatic and manual line break
  • Merging cells
  • Aligning cell content
  • Assigning borders and lines

  • Creating charts
  • Selecting different chart types
  • Changing chart types
  • Editing charts
  • Editing chart titles
  • Editing chart elements
  • Editing more chart elements
  • Sparklines

  • Working with different views
  • Defining print options
  • Using headers and footers
  • Checking content
  • Specifying additional printing options
  • Specifying column and line headings
  • Printing

Technical Specifications


  • Windows XP / Vista / 7 / 8
  • Internet Explorer 7 / 8 / 9* / 10* /11*
  • Firefox 10 or higher
  • “Script ActiveX controls marked safe for scripting” must be enabled

* In Internet Explorer 8 and higher, the Internet Explorer 7 "Compatibility Mode" is used to guarantee the optimal display of course content.

Office E-Learning Course Features:

  • Designed for Beginners, Experienced Users and Upgraders
  • Structured Video Tutorials
  • Audio Narrated Videos with Closed-Captioning
  • Practice Interactive Exercises
  • Topics Include Tips and Printable PDF's
  • Pretest with Personalized Learning Path
  • Chapter Tests
  • Comprehensive Final Test with Certificate
  • Deliverable as a SCORM package to host on your own LMS
  • Accessible online though our Course Platform service
  • Tin Can/xAPI Compatible
  • Available in Different Languages
  • Flexible Pricing Options


Interested in Pricing?

To receive pricing information for our MS Office and Windows E-Learning courses, please send us a Quotation Request and we will be touch with you shortly.

Receive a Quote ›



About Us

EXPAND Global provides learning technologies and content for the next generation workplace. We are experts in innovative learning tools, eLearning content development, off-the-shelf eLearning for Microsoft Office, microlearning, mobile learning, gamification and performance support.