Excel: Introduction

Remote training

Version: Microsoft 365
Duration: 1 day (09:00-16:00)
Price training (excl. VAT) starting at: €1425
Number of people: 1-12p

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

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

Format

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

Tables

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

Calculations

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

Charts

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

Printing

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

Book this training

Let's start a conversation!

Team Xylos is ready to meet you