Excel Basic E-Learning Course

Excel Basic E-Learning Course

Excel Basic

This E-Learning 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
Office Version
Microsoft Office 2016 / 2019
Application Group
Excel
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

Workbooks

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

Conditional formatting

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 Content Bundles
Elearning training Course Content Bundle "New Generation Workplace" for Microsoft 365

New Generation Workplace | E-Learning Content Bundle

Our full course library for Microsoft 365 and Microsoft Office.

Includes E-Learning training courses for the following applications: Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams, SharePoint, Planner, Power BI, Power Automate, Power Apps, Delve, Forms, Lists, To-Do, Whiteboard, Windows, Edge, Viva Engage, Visio and more...

Our New Generation Workplace content package is our full E-Learning course library for Microsoft 365.

This course package addresses core end-user training for Office and Windows at the Beginner, Intermediate and Advanced levels and also provides training on how to use Microsoft 365 collaboration tools to easily communicate and work in project teams.

During your subscription to this course package, you will receive our content updates to the package, including new courses we release into the package.

Elearning Training Course Content Bundle "Desktop" for Microsoft 365

Desktop | E-learning Content Bundle

Learn and improve basic skills on using the classic Office desktop apps and more.

Includes E-Learning training courses for the following applications: Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Windows, Edge, To-Do and more...

Our Desktop E-Learning content package for Microsoft 365 addresses core end-user training for Office and Windows at the Beginner, Intermediate and Advanced levels.

During your subscription to this course package, you will receive our content updates to the package, including new courses we release into the package.

Contact info

We are the leaders in the building industries and factories. We're word wide. We never give up on the challenges.