Excel: Introduction (starters)

  • Course types: Calendar course / In company
  • Version: Office 2010/2013/2016
  • Takes place in: Antwerp, Brussels, Ghent
  • Duration: 1 day
  • Price: € 315 VAT excl. / Cheaper course?

Description

Let your PC do the thinking: follow our Excel training for beginners.

Do you have little experience with Excel, but does your job require you to use the software? Or do you already work with the software, without knowing everything you can do with it? Looking up everything yourself can take a lot of time. Fortunately, there are more efficient ways to go about it. In this beginner course, you’ll learn the basic principles of Microsoft Office’s most popular calculation software in one day, and you’ll see how you can use Excel to make your PC carry out calculations for you. ‘Excel: Introduction’ is the perfect basic training for simple tasks in Excel. It’s also a great introduction to our other Excel trainings.

Choose a date and location

Objectives

After this training, you’ll know how to:

  • use Excel’s basic functions
  • set up a simple spreadsheet with numbers, text and formulas
  • sort tables and filter data
  • create and format simple charts

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 Introduction

  • Screen layout
  • 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 address ($)

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

Choose a date and location

  • Dates
  • Days
  • Timing
  • Language
  • Location
  • Planning
  •  

Request an offer



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

Practical info

The practical info and applicable cancellation conditions related to this training course.

 

Choose a date and location

€ 315 VAT excl.
Cheaper course?

Requesting a quotation

Would you like to organize this training course for your employees? At your offices or at a Xylos training centre? We transform your requirements into the perfect solution.

Request

Discount

SEVERAL PARTICIPANTS
If you enrol several employees for the same course on the same date, you will get a discount:

  • 2 employees: 15% discount on the 2nd subscription
  • 3 or more employees: 15% discount on the 2nd subscription and 40% on further participants

Questions?

Contact Inès Vansteenkiste

+32 2 264 13 20
xylos@xylos.com