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