Excel: Introduction (starters)

  • Duration: 1 day

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.

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

Request an offer



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

This training as in-company training?

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