Training adobe photoshop in Brussel Antwerpen Gent Hasselt Belgium

Excel 2013: Introduction (starters) 1 day

Description

Let your computer do the calculations. Take our Excel Introduction training course.

Maybe you’ve heard your colleagues talking about Excel, but you haven’t yet dived into it yourself. Perhaps you have used it, but haven’t really understood it. It’s a good thing Xylos has the perfect course for you: Excel Introduction! In just one day, you’ll be able to learn the basic principles of the most popular Office programme. And experience first-hand how Excel facilitates and optimises your numerical materials. 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.

pixystree-your-Business-solution-in-training-brussels

Objectives

What will you learn in our Excel Introduction training course?

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
  • draft a simple spreadsheet with numbers, text and formulas
  • sort tables and filter data
  • make and edit simple graphs

Target group

Anyone who regularly performs calculations and would like to move their numbers over to Excel.

Prerequisites

Participants are expected to be familiar with the Windows environment.

Content

Introduction
  • Layout of the screen
  • Working with the ribbon
  • Tabs and contextual tabs
  • The Quick Access toolbar
  • Dialogue Launchers
  • Galleries
Working with Workbooks
  • Adding, deleting, moving and renaming a worksheet
  • Selection techniques: Continue Selection and Discontinue Selection
  • Entering and changing data: text, data, numbers
  • Inserting and deleting rows and columns
  • Undoing alterations
  • Moving and copying cells
Formatting
  • Formatting via the ribbon
  • Using Format cells: numbers, outlining, fonts, borders, patterns
  • Making tables
  • Conditional Formatting via the ribbon: designating double values, designating cells with a value under or above a certain value
Calculations
  • Developing formulas
  • Use of in-built base functions: Min, Max, Average, Count, Counta
  • Copying Formulas and functions with the ‘Fill Handle’
  • Absolute and Relative cell addressing ($).
Graphs
  • Making a graph
  • The different components of a graph
  • Adjusting a graph with help from the ribbon/the vertical menu bar
Printing
  • Printing a workbook/worksheet
  • Page settings with help from the ribbon
  • Defining print areas
  • Installing header and footer texts
  • Print Preview
  • Pagebreak Preview.
Tables
  • The difference between a normal range and a table
  • Defining a table
  • Making a table
  • Sorting a table
  • Filtering a table

Duration

1 day(s)

Nous travaillons avec plus de 100 formateurs freelance certifiés et ayant actuellement une expérience dans le secteur. Ces formateurs sont sélectionnés par nos soins par des examens pédagogiques et de compétences.

Centre de formation PIXYSTREE

Rue Beeckmans, 53
1180 Bruxelles

02/412.04.10
0477/789.445
http://www.pixystree.com

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s