Aprende con este curso a aumentar tu productividad descubriendo los conceptos básicos de las fórmulas y funciones, para llegar poco a poco hasta un listado de las 50 funciones más importantes
This product is no longer in stock
Learn with this course to increase your productivity by discovering the basic concepts of the formulas and functions, to arrive little by little until a list of the 50 most important functions, explained in detail and with a clear language available to all types of users. The usefulness of the formulas and functions in Excel is undeniable because with them we will be able to perform calculations and searches beyond what we had imagined. This course is designed to familiarize you with the functions, knowing the most important and seeing when and how to use them through practical examples carried out with Excel 2016. We invite you to discover the possibilities of formulas and functions and incorporate them into your work daily.
Setting the bases in Excel 2016In this chapter we are going to dedicate ourselves to an approach to the basic elements that make up Excel 2016, reviewing from the visualization of the workspace to the introduction of data and the management of the contents of the cells.
First contact with the Excel 2016 window 09:34
The cells in Excel 2016 02:15
Data formats present in Excel 2016 02:21
Selection and ranges of cells 04:29
Insert and remove cells, rows and columns in Excel 2016 03:23
Modification of the width and height of rows and columns 02:33
How to insert symbols in Excel 2016 03:24
Formula in Excel 2016
In this chapter we will focus on the element that makes Excel truly exclusive within Microsoft Office programs, which is nothing more than working with formulas: the possibility of performing mathematical operations, combining values, the inclusion of operators arithmetic, etcetera.
Functions in Excel 2016We will define what is meant by function within Excel and how they can perform tedious tasks for us in a very efficient way and streamline our work with calculations of any level.
Assimilating what a function is in Excel 02:41
The AUTOSUMA command in Excel 02:04
Logical functions present in Excel 2016The application of logical functions to our spreadsheets allows us to find out if any field of our interest is true or not between the data we handle, and combining several of them we will achieve great power.
The IF function 06:40
The functions Y, O 04:37
Text functions in Excel 2016In this chapter we will review the functions that help us control the texts and handle them at will, either for a more comfortable use of them, or to facilitate the reading processes.
Applications of the functions RIGHT, LEFT and EXTRA 03:15
Applications of the functions MAYUSC, MINUSC and NOMPROPIO 01:41
Applications of the functions SPACES and CLEAN 03:33
Applications of the DECIMAL, TEXT and CURRENCY functions 03:44
Mathematical functions in Excel 2016Let's learn to add ranges of cells whenever criteria are met, to make weighted averages, to take root and to manage the decimals of a value. Some of the functions we will learn, such as ADD, will be a surprise.
How to use the ROUND and ENTIRE functions and TRUNK 03:04
How to use the SUMIF and SUMIF functions.CONJUNTO 04:42
Performing weighted averages with the function SUMAPRODUCTO 01:46
How to use the ADD function for ranges with errors 03:48
Applying square roots with ROOT function 01:18
Statistical functions in Excel 2016
This chapter is dedicated to the functions that will allow us to make forecasts based on the data provided in the spreadsheet, and we will also review the advanced options of the COUNT and AVERAGE functions.
Search functions in Excel 2016
In this chapter we are going to devote to review the search functions, this is a set very used by the advanced users of Excel and who are responsible for returning data associated with the one we are looking for.
Jobs VLOOKUP function 07:03
How to use the HLOOKUP function 03:46
Applying the INDEX function 03:01
Using the COINCIDIR function 01:27
Applying the DESREF function 07:48
Error handling in Excel 2016
In this chapter we are going to carry out a study of a series of functions that allow us to unravel the mysteries of the error messages that are thrown at us by some cells and will no longer be a nuisance.
Financial functions in Excel 2016
This chapter focuses on the application of financial functions typical of the banking sector in our spreadsheets, for repayment of loans, or to help us calculate the interest that we will actually pay with a loan.
Totally free of viruses and malicious software, so do not wait any longer to download it now.
Do not forget to give us an opinion about the program, to improve the content.
NOTE: Do not forget to follow us on our facebook and twitter social networks so that you become part of our community and receive the notification every time we post something new, so you will not miss anything.
|OS||Windows XP o superior|
|Disk size required||295 MB|
NO registration required!
If the question you have has not yet been answered here, use the form below to ask something about this addon.