Objectives of the training
To provide the knowledge and skills required to make use of the key features of Excel in order to increase daily productivity and autonomy.Targeted audience
All public.Prerequisite
Basic knowledge of Excel.Course architecture
-
Presentation and optimization of the user interface
-
Presentation of the 3 sliders
-
Customization of the user interface and options
-
The importance of data consistency and how to ensure it
- Creating custom lists
- Creating and using sample workbooks- Creating reference sheets
- Creating drop-down lists of choices
- Creating cells and reference ranges
-
Naming cells and data ranges
-
Using the name manager
-
Conditional formatting to present our data well
-
Manipulating our data in tables
-
Analyzing tables of data
-
Formatting cells in a table
-
Creating custom cell formats
-
Using tables to create pivot tables
-
Creating formulas
-
Using the function argument box to learn about functions
- Creating a searchv and a searchx
- The range of Si
-
The best tricks
- Keyboard shortcuts to know
- Centering on multiple cells instead of merging and centering
- The best printing tips
- Using the tool in a formula to choose the right cell range when creating a formula
- Use the Name Zone to navigate
- Open several files at the same time
- Adding and/or deleting multiple rows in one manipulation
- Hide the content of a cell with a custom format
- Create automatic corrections to speed up data entry
-
Instantaneous filling
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quotePrivate or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quote