Excel : Fundamentals + Advanced functions

world

Goals


- Discover the new features of Office

- Know the main features of Excel

- Be able to perform calculations and use functions

- Know how to handle graphics and pivot tables

Program

Presentation of Excel
Description of the ribbon
Workbooks and worksheets
Rename, insert, move, delete a worksheet
Move around in the workbook (using the keyboard, menus, mouse)

The different ways of selecting cells
Modifying the height and width of rows / columns
Inserting rows and columns
Formatting the content of the cell (font, colors, etc.)
Borders
Alignment in the cell
Merge cells
Apply a format cell

Creating tables
Automatic formatting
Creating a custom style

The formula bar
Addition, subtraction, multiplication, division
Use of parentheses
Percentage format
Copy calculations

Layout Page
breaks
The printing area
Printing and printing options

The different display modes
Show / hide information
Zoom
Freeze the panes

Duration

3 days

Price

£ 1125

Audience

Everyone

Prerequisites

Knowledge of the PC environment

Reference

BUR502-F

  

Using a referent cell ($)
Basic
formulas Conditional formulas
Date and time
functions Other functions
Formula audits

Sorting, sorting options
Automatic filters

Custom filters

Select data
Choose a chart type according to needs
Insert a title, legend, data labels
3D charts
Modify values
Modify chart type

Structure of a PivotTable
The PivotTable and PivotChart wizard
Edit a PivotTable
Format a PivotTable

Convert and consolidate
Data validation
Scenario analysis

Adding and modifying comments
Protect your workbook and sheets
Using the Microsoft OneDrive service

Objectives of a macro
Displaying the Developer tab in the ribbon
Recording a macro
Running a macro
Running a macro via shortcuts (in ribbon, button, etc.)
Managing macros
Viewing the code of a macro

Sessions

Contact us for more informations about session date

Good. Interesting course. Examples adapted to my professional demands. Trainer: Excellent, attentive. Enriching, very attentive trainer.
Daniel R.
Daniel R.
For my part, I prefer training outside the workplace (ie in the premises of the training organization). This allows you to be 100% focused on your own training and cut from your workplace where you may be called upon. For my part, the pace of the training is very (too?) Sustained and we have to go very quickly. Not always the time to take notes. Either we do not take notes or we lose track of what is shown on the video projector. Fortunately, the level of the group was quite homogeneous.
Sandrine B.
Sandrine B.
Exactly what I needed. Trainer: Very available to answer our questions.
Nadine M.
Nadine M.
Very good. Basic training but quite elaborate ... Trainer: S adapts to the intern.
Sylvie K.
Sylvie K.
Very interesting training, which corresponded to my expectations and above all very profitable since there were only 2 of us so we were able to progress well but remains to be practiced ...
Nadia D.
Nadia D.
Very complete course in relation to the choice of internship duration. Many questions were unanswered until now, but thank you Dawan, this is no longer the case! Trainer: Thank you to Kevin for his availability, listening and sympathy. Pleasant and fun training, it was very good!
Jennifer G.
Jennifer G.
The pace was very sustained but the trainer was able to take the time to come back to me personally to help me and give me more explanations. Trainer: very suitable and very understanding, very sympathetic, perfect!
Carole G.
Carole G.
Especially not to suppress the exercises because it is by practicing that one sees the most the comprehension. THANK YOU for this training !
Catherine B.
Catherine B.
Précédent
Suivant