Skip to main content

Excel Basic E-Learning Course

This course provides training on Excel for beginner and intermediate levels

Learners will first become familiar with the structure of Excel, (i.e. workbooks, worksheets, tables, columns, rows and cells). They will see how to enter data into those elements and how to edit and format them. Formulas and functions will be covered to perform calculations in individual cells. Learners will also be shown how to visualize content using charts and will gain an understanding on how Excel supports them in performing quality checks and when printing tables.

Course Features
Content Version
Application Group
Level
Beginner / Intermediate
Learning Time
5 hours and 50 minutes
Number of Learning Videos
129
Languages Available
English
German
French
Spanish
Portuguese
Japanese
Chinese
Russian
Course Design
  • Videos with Audio Narration and Closed-Captions
  • Practice Interactive Exercises
  • Tips and Printable PDF's
  • Chapter Tests
  • Personalized Learning Recommendations
  • Comprehensive Final Test with Certificate
  • Compatible with Desktop and Mobile Devices
  • SCORM and xAPI Support for LMS Deployement
Course Topics

Creating and managing new workbooks

  • Creating a new workbook
  • Switching between workbooks
  • Protecting sheet
  • Unprotecting a sheet
  • Protecting a workbook
  • Sending a file as an email attachment

Creating and editing worksheets

  • Inserting a worksheet
  • Working with multiple worksheets
  • Copying and moving a worksheet
  • Renaming a worksheet
  • Showing and hiding worksheet
  • Deleting a worksheet

Edit cells

  • Entering text in cells
  • Inserting and deleting cells
  • Moving and copying cells

Editing columns and rows

  • Selecting rows and columns
  • Showing and hiding rows and columns
  • Freezing rows and columns
  • Freezing the top row or first column
  • Specifying the column width or row height
  • Changing the column width or row height with the mouse
  • Releasing locked cells in a protected worksheet
  • Merging cells

Above is a sample of learning videos included in this topic.
A detailed list of all learning videos included in this course is available upon request.

Creating tables

Working with tables

Sorting tables

Filter with slicers

Filtering tables

Styles and templates

Formatting numbers

Formatting cells

Conditional formatting

Formatting pages

Formula basics

External cell references

Simple formulas

Simple functions

Creating a chart

Editing a chart

Editing chart elements

Sparklines

Reviewing and corrections

Preparing for printing

Printing

This Course is Included in our Course Packages