EN
0
Basket

Your basket is empty

background section

Excel : basic

Microsoft Excel is the most widely used spreadsheet software in the world. Follow this course and you’ll master the basics of the programme. Put what you learn into use at work. Or use it as a springboard into more specialised knowledge. Either way, you’ll have a powerful skill that is sure to benefit you.
 

  • Training type

    Classical

  • Duration of training

    2 days

  • Available languages
    EN 
  • Training code

    1664EA1

What do you learn?


  • You fluently use basic Excel terms to make your Excel spreadsheets come to life;
  • You navigate through lists, print worksheets, apply formatting and use conditional formatting with nothing more than the push of a button;
  • You insert formulas in the blink of an eye.

You can find full details of the programme for all our Excel courses on our website.

Target group

You want the incredible benefits of Excel at your fingertips.

Required prior knowledge

You have basic computing skills.

Overview of the programme

1 GETTING ACQUAINTED WITH THE ENVIRONMENT

1.1 Introduction

1.2 A spreadsheet

1.3 Starting up Excel

1.4 The start screen

1.5 The interface

 

2 INTEGRATION WITH OFFICE 365

2.1 Linking your account

 

3 EDITING FILES

3.1 Saving a workbook

3.2 Cloud storage

3.3 Closing a workbook

3.4 Creating a new workbook

3.5 Opening a workbook

 

4 EDITING A WORKBOOK

4.1 Changing the content of a cell

4.2 Insert mode and overwrite mode

4.3 Navigating within a workbook

4.4 Views

4.5 Excel Options

 

5 A FIRST REAL WORKSHEET

5.1 Introduction

5.2 An example

5.3 Editing a cell

5.4 Entering numbers

5.5 Widening columns

5.6 Modifying the row height

5.7 Inserting a row or column

5.8 Deleting a row or column

5.9 Copying cells

5.10 Moving cells

5.11 Number formats

5.12 Alignment

5.13 Undo

5.14 Redo

5.15 The Escape key

5.16 Additional key combinations

5.17 Printing a worksheet

5.18 Opening multiple workbooks

 

6 FORMATTING, COPYING AND FILLING

6.1 Formatting a range of cells

6.2 Categories

6.3 Number formats in the group Number

6.4 Fonts

6.5 Font, font size, etc. in the ribbon

6.6 Merging and centring

6.7 Alignment

6.8 Borders

6.9 Fill

6.10 Hiding grid lines

6.11 Ranges of cells and formatting

6.12 Filling ranges of cells using the fill handle

 

7 FROM WORKSHEETS TO WORKBOOK

7.1 Introduction

7.2 Multiple worksheets in a workbook

7.3 Inserting and deleting a worksheet

7.4 Protecting the worksheet

7.5 Working on multiple tabs

7.6 Renaming tabs

7.7 Changing tab format

7.8 Copying, moving and deleting worksheets

7.9 Splitting a worksheet

7.10 Freezing panes

 

8 PRINTING A WORKSHEET

8.1 Page Setup

 

9 EXERCISES

10 INSERTING FORMULAS

10.1 Entering a formula

10.2 The AutoSum button

10.3 Functions

10.4 Formula palette

 

11 RELATIVE CELL REFERENCES

11.1 Introduction

11.2 Example: one formula to calculate every subtotal

 

12 ABSOLUTE CELL REFERENCES

12.1 Introduction

12.2 Example: conversion from € to $

 

13 MIXED CELL REFERENCES

13.1 Introduction

13.2 Example: one formula to calculate various scenarios

 

14 NAMING A CELL OR CELL RANGE

14.1 Introduction

14.2 Method

14.3 Using names in formulas

14.4 Modifying name references

 

15 OVERVIEW OF FUNCTIONS

15.1 Introduction

15.2 Insert function

 

16 MORE ABOUT DATES AND TIME

16.1 Principle

16.2 Adding a number of days to a date

16.3 Totalling times

16.4 The current date

16.5 The current time

 

17 USEFUL INFO IN THE STATUS BAR

18 ERRORS

18.1 #######

18.2 #NAME?

18.3 #VALUE?

18.4 #NUM!

18.5 #DIV/0!

 

19 EXERCISES

20 CONDITIONAL FORMATTING

20.1 Introduction

20.2 Conditionally formatting a selection using a fill colour

20.3 Conditional formatting for a top 10

20.4 Conditional formatting using data bars

20.5 Conditional formatting using colour scales

20.6 Conditional formatting using icon sets

20.7 Exercises

 

21 LISTS

21.1 Introduction

21.2 Flash Filling a whole column with data

21.3 Creating a list

21.4 Sorting a list

21.5 Applying a filter in a list

21.6 Advanced filter

 

22 FINDING RECORDS

22.1 Finding by colour

 

23 USEFUL NAVIGATION TECHNIQUES IN A LIST

23.1 Using the keys

23.2 Using the mouse pointer

 

24 OVERVIEWS

24.1 Introduction

24.2 Automatically creating an overview

24.3 Showing and hiding detail data

24.4 Deleting a level

24.5 Deleting an overview

24.6 Showing and hiding overview symbols

24.7 Defining a group

 

25 CUSTOM VIEWS

25.1 Introduction

25.2 Creating a custom view

25.3 Using a custom view

 

26 TABLES

26.1 Introduction

26.2 Creating a table from a list

26.3 Totalling

26.4 Number of rows that meet the filter criteria

26.5 Selecting from a table, row or column

26.6 Removing duplicates

26.7 Resizing the table

26.8 Converting to range

 

27 DATABASE FUNCTIONS

27.1 Introduction

27.2 Syntaxis

27.3 Applying a database function to a list

27.4 Applying a database function to a table

 

28 EXERCISES

29 CREATING A CHART ON THE BASIS OF A CROSSTAB

29.1 Creating a chart sheet

29.2 Inserting a chart into the source data worksheet

29.3 Deleting data from the chart

29.4 Adding new data to the chart

 

30 CHART COMPONENTS

30.1 Series

30.2 Categories

30.3 Axes

30.4 Getting to know the different components

 

31 MODIFYING A CHART

31.1 Activating a chart

31.2 Moving the chart on a worksheet

31.3 Placing a chart on a separate chart sheet

31.4 Resizing the chart

31.5 Changing the chart type

31.6 Moving a component

31.7 Editing a component

31.8 Cancelling a selection

31.9 Hiding or reactivating chart components

31.10 Chart style

31.11 Switching rows and columns

31.12 Deleting the chart