Skip to main content

Remote training Excel: Introduction

Version: Office 365
Duration: 1 day
Price incompany training: € 950 VAT excl. / Terms for incompany training.

Description

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.

Objectives

Do complex calculations feature in your daily tasks?

Once it’s finished, you’ll effortlessly be able to:

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

Target Group

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

Prerequisites

Participants are familiar with the Windows environment.

Content

Part 1 Working with workbooks and worksheets

  • What do the various extensions xlsx, xls, xlsm, xlsb, xltx, xltm mean?
  • Copying, adding, deleting, moving sheets
  • Making selections
  • Adding and Removing Rows/Columns

Part 2 Format

  • Basics of cell formatting (number format, font, alignment, background, and borders)
  • Basics of conditional formatting

Part 3 Tables

  • How do you make a table?
  • What are the advantages of a table?
  • Sorting
  • Filtering

Part 4 Calculations

  • Drafting Formulas
  • Copying formulas with the “Fill handle”
  • Absolute and Relative cell addressing ($)
  • Built-in basic functions (Sum, Min, Max, Average, Count, Counta)

Part 5 Charts

  • Creating a chart
  • The various parts of a chart
  • Adjusting a chart using the ribbon/side menu

Part 6 Printing

  • Printing a workbook or worksheet
  • Page Settings
  • Defining print areas
  • Setting headers and footers
  • Print Preview
  • Page layout
View all our trainings

Request a quote

"*" indicates required fields

Address*
Name*
In which language(s) do you wish to organise this training?
You apply for this course as:
Do you want the training online or on-site?