×
×

Excel Basic - Office 365

What does this course offer you?

In this training course, you will learn Excel for Office 365 from the ground up. You will first become familiar with the structure of Excel, in other words workbooks (i.e. files), worksheets, tables, columns, rows and cells. You will see how to fill these elements with data and how to edit and format them. Next, you will learn about formulas and functions that you can use to perform calculations in individual cells and about charts with which you can visualize your content. Finally, you will learn how Excel supports you in performing quality checks and when printing your tables.

The primary subject matter of this course:

Pretest

Workbooks

  • Creating and managing new workbooks
  • Creating and editing worksheets
  • Edit cells
  • Editing columns and rows
  • Chapter test

Tables

  • Creating tables
  • Working with tables
  • Sorting tables
  • Filtering tables 1
  • Filtering tables 2
  • Chapter test

Formatting

  • Styles and templates
  • Formatting numbers
  • Formatting cells
  • Conditional formatting
  • Formatting pages
  • Chapter test

Formulas and functions

  • Formula basics 1
  • Formula basics 2
  • Simple formulas
  • Simple functions
  • Chapter test

Charts

  • Create a chart
  • Editing a chart
  • Editing chart elements
  • Sparklines
  • Chapter test

Finishing touches

  • Reviewing and corrections
  • Preparing for printing
  • Printing
  • Chapter test

Final Test

  • 30 Questions
Office 365 E-Learning Course Features:
  • for beginners and experienced users
  • structured video tutorials
  • audio narration with closed-captioning
  • practice interactive exercises
  • tips and printable PDF's
  • pretest with personalized learning path
  • chapter tests
  • comprehensive final test with certificate
  • SCORM package delivery for LMS hosting
  • accessible online
  • Tin Can/xAPI compatible
  • available in different languages
Excel Basic - Office 365 Course Includes:

Sections: 25
Number of Nuggets: 129
Learning Time: 425 Minutes