The beauty and strength of Excel lies in the functions available. This Excel training course will help you take better advantage of the data you have, by processing it intelligently with the right function(s).
Duration
1 day
Schedule
See training dates for details
Regular fee
$260
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.
$235
Objectives of the training
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.
Course architecture
MS Excel is a powerful spreadsheet program, among other things, because of its many functions. The functions in Excel allow you to process data according to your needs and thus to draw insights that will help you make decisions or simply understand. Several key functions will be covered during this training.
How to use the search functions
Search functions are used to find the value of a cell in a range of data (rows, columns, a combination of both, in a sheet or even a workbook).
You will see the characteristics of VLOOKUP, HLOOKUP, INDEX, MATCH
Search functions are used to find the value of a cell in a range of data (rows, columns, a combination of both, in a sheet or even a workbook).
You will see the characteristics of VLOOKUP, HLOOKUP, INDEX, MATCH
How to use the database functions
These functions all start with BD and allow you to perform calculations in a database, according to the criteria you define. The database functions are useful to find cells, apply a formula to the cell value and display the result.
For this you will see : DSUM, DAVERAGE, DCOUNT, DMAX, DMIN
These functions all start with BD and allow you to perform calculations in a database, according to the criteria you define. The database functions are useful to find cells, apply a formula to the cell value and display the result.
For this you will see : DSUM, DAVERAGE, DCOUNT, DMAX, DMIN
How to use the information functions
The information functions allow you to retrieve data about the nature of the targeted cell.
You will see: CELL, TYPE, ISERR, ISERROR
The information functions allow you to retrieve data about the nature of the targeted cell.
You will see: CELL, TYPE, ISERR, ISERROR
How to use the logical functions
These functions return a value according to the logical test performed, i.e. according to whether the chosen criteria are true or false.
You will see : IF, AND, OR and the nesting of functions
These functions return a value according to the logical test performed, i.e. according to whether the chosen criteria are true or false.
You will see : IF, AND, OR and the nesting of functions
How to use the financial functions
Excel allows you to use functions dedicated to financial calculations.
You will see: PMT, FV, NPER, RATE
Excel allows you to use functions dedicated to financial calculations.
You will see: PMT, FV, NPER, RATE
How to use the date and time functions
You will see : TODAY, NOW, DATE, YEAR, MONTH, DAY, NETWORKDAYS
You will see : TODAY, NOW, DATE, YEAR, MONTH, DAY, NETWORKDAYS
How to use the statistical functions
You will see : COUNT, COUNTIF, COUNTIFS, COUNTBLANK, FREQUENCY
You will see : COUNT, COUNTIF, COUNTIFS, COUNTBLANK, FREQUENCY
How to use the text functions
You will see : RIGHT, LEFT, LEN, MID, SEARCH, FIND, CLEAN, TEXT, CONCATENATE
You will see : RIGHT, LEFT, LEN, MID, SEARCH, FIND, CLEAN, TEXT, CONCATENATE
How to use matrix functions
In this chapter you will learn how to set up a matrix formula or use a function in its matrix form to perform calculations on ranges of juxtaposed cells.
In this chapter you will learn how to set up a matrix formula or use a function in its matrix form to perform calculations on ranges of juxtaposed cells.
Training 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
See training dates for details
Regular fee
$260
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.
$235
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