Excel 2013, 2016, Office 365 Introduction

440 €
at 1.1 KM
Keyjob
  • Training
  • Business
  • Strategy
  • Technology
  • Digital
  • IT
  • Productivity
  • Office
  • Performance

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



Organizer

Keyjob


Your lastname:

Your firstname * :

Your email * :

Phone :

Your message * :


Key Job

Where does it take place?

1611 Luxembourg 65, Avenue de la Gare Luxembourg

Key Job
65
Avenue de la Gare Luxembourg



SEE MAP

  • Favorites
CLOSE

Favorites

To check your Favorites, connect to your account!

CLOSE

Favorites

To check your Favorites, connect to your account!

CLOSE

Hey you! Interested in the Helloboss app?

CLOSE

Customize your results

Sign in to get access to your preferences!

CLOSE

Follow a theme

Sign in to follow this category!

CLOSE

Follow trainings

Sign in to follow this Good Address!

CLOSE

Follow a Business

Sign in to follow this business!

CLOSE

Yes I want to delete it

Yes No

tu n'as pas autorisé la localisation ?

CLOSE
CLOSE