Microsoft Excel Logo

Goals


- Know how to create a table in Excel

- Be able to configure the printing of your table

Program

Presentation of Excel and the other tools of the Office suite
Examples of realization with Excel

Description of the interface (Ribbon, Quick Access Toolbar, etc.)
Structure of a file (workbooks, sheets and cells)
Create a workbook

Adding a sheet to the workbook
Rename a sheet
Move a sheet (on the same workbook or in another)
Identify a sheet using a tab color

The different ways to select cells
Insert rows and columns
Change the height and width of rows / columns

Format the content of a cell (font, colors …)
Apply borders
Manage alignment in a cell
Merge several cells
Apply a cell format

Workshop: Making a simple painting

Creating tables
Automatic formatting
Creating a custom style

Workshop: Creation of a personalized style and application on a board

Insert pictures (local or online)
Add and edit shapes
Insert organization chart

Define the application area
Use the predefined rules
Modify an existing rule
Create a new rule
Apply to an entire table

The formula bar
Addition, subtraction, multiplication, division
The value of parentheses
Applying a calculation to an entire column

Apply a sort on one or more columns
Modify sorting options
Apply filters on a table
Use advanced filters

Manage the page layout (margins, header and footer, etc.)
Scale your table
Manually manage page breaks
Define a print area
Define print options then print

Available display modes
Show / hide cells
Zoom
Freeze panes

Passing of the certification (if foreseen in the financing).

Duration

2 days

Price

£ 2495

Audience

All

Prerequisites

Knowledge of the PC environment

Reference

BUR1241-F

Sessions

Contact us for more informations about session date