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