Excel Microsoft 365 Apps for Enterprise Introduction

Details

Goals

Being able to create tables and manage them; to format and manipulate data; to create and print charts from Excel data.

Prerequisite

Knowledge of the Windows work environment.

Contents

Excel environment

The Excel environment: Quick Access toolbar, ribbon and tabs
Customize Quick Access toolbar and the ribbon
Live Preview and Paste Preview

Manage spreadsheets

Add, rename, delete a worksheet
Move and copy a sheet
Define a tab color
Change the height or width of the formula bar

Manage Tables

Enter and validate data
Manage rows and columns: add, resize, delete, hide / show
Find / Replace data
Copy / paste data

Document Management

Create / open / save a document
Headers and footers
The « Page Layout » view

Calculate

Enter and copy formulas
Smart tags

Functions

Insert Function using the wizard
Insert function manually, semi-automatic formula input

Format table

Format cells
Using styles
Predefined conditional formats

Present data with a graph(Chart)

Create a chart
Change / format a Chart
Use the chart styles
Create and use a chart template
Sparklines

Analyze the data tables

Create a data table (Insert Table)
Sort and filter data tables
List filters with search box
Sort and filter by font or fill color
The Flash Fill

Next session(s)

Thu. 19 Jun. Fri. 20 Jun. 2025
*** SESSION COMPLETE ***

Mon. 21 Jul. Tue. 22 Jul. 2025
Tarif de 540€ suite à indexation du 01/05/2025 (effectif à partir du 1er juillet)

Mon. 28 Jul. Tue. 29 Jul. 2025
Price will be €540 according to indexation on 05/01/2025 (effective as from July 1st)

Thu. 07 Aug. Fri. 08 Aug. 2025
Preis beträgt 540 € nach Indexierung am 01.05.2025 (gültig ab 1. Juli)

Mon. 11 Aug. Tue. 12 Aug. 2025
Tarif de 540€ suite à indexation du 01/05/2025 (effectif à partir du 1er juillet)

Mon. 11 Aug. Tue. 12 Aug. 2025
Price will be €540 according to indexation on 05/01/2025 (effective as from July 1st)

Mon. 08 Sep. Tue. 09 Sep. 2025
Price will be €540 according to indexation on 05/01/2025 (effective as from July 1st)

Mon. 15 Sep. Tue. 16 Sep. 2025
Tarif de 540€ suite à indexation du 01/05/2025 (effectif à partir du 1er juillet)

Thu. 02 Oct. Fri. 03 Oct. 2025
Tarif de 540€ suite à indexation du 01/05/2025 (effectif à partir du 1er juillet)

Tue. 21 Oct. Wed. 22 Oct. 2025
Preis beträgt 540 € nach Indexierung am 01.05.2025 (gültig ab 1. Juli)

Thu. 06 Nov. Fri. 07 Nov. 2025
Tarif de 540€ suite à indexation du 01/05/2025 (effectif à partir du 1er juillet)

Mon. 17 Nov. Tue. 18 Nov. 2025
Price will be €540 according to indexation on 05/01/2025 (effective as from July 1st)

Thu. 04 Dec. Fri. 05 Dec. 2025
Tarif de 540€ suite à indexation du 01/05/2025 (effectif à partir du 1er juillet)

Terms and conditions

Need a custom training?

None of the trainings fit your requirements? You have specific needs? Key Job trainers are versatile and flexible. Contact us!

info@keyjob.lu

+352 49 06 09 1

Leave us a message