Remote training Excel: Introduction

  • Course types: Custom webinar
  • Duration: Half a day

Description

In just one day, you’ll be able to learn the basic principles of the most popular spreadsheet application: Excel. Taking our Excel Introduction training course? Then you’ll have chosen the ultimate springboard into more complex functions, PivotTables, databases, graphs and more… All of which are on offer in subsequent training modules.

Objectives

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.

Prerequisites

Participants are familiar with the Windows environment.

Content

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

Requesting a quotation

Would you like to organize this webinar for your employees? We transform your requirements into the perfect solution.

Request

Questions?

Contact Inès Vansteenkiste

+32 2 264 13 20
xylos@xylos.com