Excel 2016 Basic

What does this course offer you?

In this training course, you will learn Excel 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.


What does this course include?

25
SECTIONS
129
NUMBER OF NUGGETS
425
LEARNING MINUTES
 


Course Topics

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

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

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

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

  • Create a chart
  • Editing a chart
  • Editing chart elements
  • Sparklines

  • Reviewing and corrections
  • Preparing for printing
  • Printing

Technical Specifications

Desktop

Windows 7 or higher

  • Microsoft Internet Explorer 9+
  • Microsoft Edge
  • Google Chrome 47+
  • Mozilla Firefox 40+

Mac OS X Yosemite or higher

  • Safari 8.0.4+
  • Mozilla Firefox 40.0.1+

Tablet and Mobile Devices

Tablet

  • iOS: optimized for Apple iPad Air 2 with iOS 8
  • Android: optimized for Samsung Galaxy Tab S2 with Android 4.2.2 or Firefox 34.0.1

Mobile

  • Apple iPhone with iOS Version 7 or higher
  • Smartphones with Android Version 4 or higher


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.

 

GET IN TOUCH