Duration
1 day
Schedule
9h to 16h
Regular fee
$250
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
To provide the knowledge and skills required to make effective use of the many functions available with Microsoft Excel.Targeted audience
Any audience.Prerequisite
Basic knowledge of Excel.Trainers
Course architecture
- Search functions: VLOOKUP, HLOOKUP, INDEX, MATCH
- Database functions: DSUM, DAVERAGE, DCOUNT, DMAX, DMIN
- Information functions: CELL, TYPE, ISERR, ISERROR
- Logical functions: IF, AND, OR and the nesting of functions
- Date/time functions: TODAY, NOW, DATE, YEAR, MONTH, DAY, NETWORKDAYS
- Statistical functions: COUNT, COUNTIF, COUNTIFS, COUNTBLANK, FREQUENCY
- Text functions: RIGHT, LEFT, LEN, MID, SEARCH, FIND, CLEAN, TEXT, CONCATENATE
- Using matrix functions
Notes
Note: Most of the functions presented are available in all Excel versions (2016, 2013, 2010, 2007 and 2003).
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
9h to 16h
Regular fee
$250
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