Remote training Excel: Introduction

  • Version: Office 2016/ Office 365
  • Duration: 1 day


Thanks to this training, you’ll be able to learn the basic principles of Excel. Taking our Excel Introduction training course? Then you’ll have chosen the ultimate springboard to the other training courses like Excel Databases and PivotTables and Excel Functions & Formulas.


Do complex calculations feature in your daily tasks? Then you’ll be able to work more quickly and efficiently after a course on Excel for beginners. Once it’s finished, you’ll effortlessly be able to:

  • Use the basic Excel functions
  • Set up a simple spreadsheet with numbers, text and formulas
  • Sort tables and filter data
  • Create and edit simple charts

Target Group

Everyone who needs to carry out calculations regularly and wants to leave this task to Excel.


Participants are familiar with the Windows environment.


Part 1 Introduction

  • Layout of the screen
  • Using the ribbon
  • Tabs and contextual tabs
  • The Quick Access toolbar
  • Dialog launchers
  • Galleries

Part 2 Working with Workbooks

  • How to open, close, save and create a workbook

Part 3 Working with Worksheets

  • How to add, remove, move and rename a worksheet
  • Selection methods: continuous and discontinuous selection
  • Enter and edit data: text, data, numbers
  • Add and delete rows and columns
  • Undo changes
  • Move or copy cells

Part 4 Formatting

  • Formatting with the ribbon
  • Formatting with format cells: numbers, alignment, font, borders, patterns
  • Table formatting
  • Conditional formatting with the ribbon: highlight double values, highlight cells with a value above or below a certain value

Part 5 Calculations

  • Create formulas
  • Use built-in basic functions: Sum, Min, Max, Average, Count, Counta
  • Copy formulas and functions with the 'fill handle'
  • Absolute and relative cell addressing ($)

Part 6 Charts

  • Create a chart
  • Components of a chart
  • Edit a chart with the ribbon/side menu

Part 7 Printing

  • Print a workbook or worksheet
  • Page settings
  • Define print areas
  • Set up headers and footers
  • Print preview
  • How to use Page Layout

Part 8 Tables

  • The difference between a normal range and a table
  • Define a table
  • Format a table
  • Sort a table
  • Filter a table

Request an offer

Share this course on Facebook, Twitter, LinkedIn or e-mail