You already use Excel, but not necessarily to its full capacity. But this spreadsheet can make your life easier. With this Excel training, you will be able to use the spreadsheet more efficiently and you will gain in efficiency: how to use certain functions (Rounding, If...), to choose the right addressing mode, to organize data adequately, to manage multiple sheets and workbooks, to take advantage of the flexibility of the pivot tables, to create graphs... You will bring your data back to life and you will be able to extract actionable information
Duration
1 day
Schedule
See training dates for details
Regular fee
$375
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$225
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.Trainers
Course architecture
- Essential keyboard shortcuts
- Organizing data in order to work efficiently with Excel
- Setting up pages efficiently: using the fill handle, and special cut and paste techniques
- The various addressing modes: A1, $A$1, $A1 and A$1
- Essential features
- Automating layout: custom formats and conditional formatting
- Cross-sheet and cross-file formulas
- Creating graphics
- Updating multiple tabs simultaneously
- Choosing a good analysis tool: pivot tables, filters and subtotals
- Using scenarios
- Input control: protection and validation of information
Training Notes
Note: The course is given using Excel 2019 and 2016, but the features described are available in Excel 2007–2013 as well. The version of the course given with Excel 2003 is available upon request.
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 quoteDuration
1 day
Schedule
See training dates for details
Regular fee
$375
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$225
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 quote