Course – Advanced Excel

- Develop skills in the processing of information in an efficient and timely manner, in such a way that the participant can organize, manipulate, process, present data and contents in a totalized way through the use of Excel tools (tables, formulas, graphs
- Quickly carry out both simple and larger operations, with statistical, financial and accounting formulas, as well as create tables and din graphs that will give the works a better appearance.
Excel is a Spreadsheet-type program that allows you to perform operations with numbers organized in a grid. It is useful to perform from simple sums to mortgage loan calculations. If you have never worked with Excel on this basic topic, you can see in more detail what a Basic spreadsheet is and what it is for.
Now we are going to see what are the basic elements of Excel 2016, the screen, the bars, etc., to know how to differentiate between each one of them. You will learn what they are called, where they are and what they are for. Also how to get help, in case at some point you don't know how to continue working. When you know all this you will be ready to start creating spreadsheets in the next topic.
We must develop the potential of the tools and functions found in excel, which allow the generation of a number of applications at the service of automation and analysis of processes within the labor and academic field, achieving capacities in the participant to be able to organize , manipulate, process and present data and content in an effective way, managing to add value to the different processes to which they are applied, whether academic or work. It has been possible to propose an intermediate training level in which the participant will be able to identify and apply the different formulas and functions, with which he will achieve great information management.
The Advanced Excel Course Is Aimed At:
- Students, Teachers and Administrative
The curriculum of the Advanced Excel Course was developed by highly trained professionals with extensive experience in pedagogical training.
This program includes 10 modules in which each participant can study at their own pace and from anywhere, obtaining results that will increase their professional opportunities.
MODULES (THEME) |
---|
1. Introduction to Excel- |
Toolbars. |
Add and remove toolbars. |
Formatting: bold, italic, underline, color, font Insert and delete rows, columns, and cells. |
Data types: Text, number, formulas and functions. SUM, MAX, MIN, AVERAGE, COUNT, COUNTA. Simple mathematical operations. |
2. |
Creation of spreadsheets. |
calculations. Percentages. |
Types of errors in formulas. |
Format: Autoformat. Conditional format. |
Drag cells. |
Relative, absolute, mixed references. |
Sort data. |
3. |
Graphics. |
Creation of graphs based on a spreadsheet. |
Chart types. Setting. Personalize. |
Graphics tools. |
Color, lines, 3D, shading, textures, etc. |
Modification of data of a graph. |
Create Speedometer Charts |
4. |
Database. |
Creation of a database in Excel. |
Data. Filter, Autofilter. |
Sort data. |
Freeze panels. |
Subtotals. Validation. Forms. |
5. |
Basic functions. |
Text functions. |
Date functions. |
Counting functions. |
Financial functions. |
Logical functions. |
Functions of searching and referencing |
Combination of formulas and functions |
matrix functions |
advanced formulas. |
Statistical functions |
financial functions |
COUNT.IF, ADD.IF, IF, SEARCH, VLOOKUP, HLOOKUP. |
Creation and editing of complex spreadsheets combining formulas |
6. |
Formula Audits. |
Handle errors in functions. |
Error checking. |
Trace preceding cells that generate a formula. |
Trace dependent cells of a formula. |
Show formulas. |
Evaluate formula. |
Watch Window |
7. |
Data Protection |
Book level protection. |
Blade level protection. |
Cell level protection |
Databases. |
Data Import. From text, web, Access, Query |
Data validation. |
Dynamic tables. |
Dynamic Graphics. |
Segmentation |
Solve |
dashboard |
8. Excel Formulas for Accountants |
SEARCHV SEARCHH MATCH |
BDCOUNT BDEXTRACT BDMAX |
BDPRODUCT BDAVERAGE BDSUM |
ENTIRE RANDOM ABS |
SUMPRODUCT COUNT STATISTICS |
BONUS: PIVOT TABLES |
9. Macros. |
Macro recorder. |
References in macros |
Introduction to VBA. |
10. Identify the factors that facilitate the organization of data, developing exercises related to the reality of work. |

Request information
Error: Contact form not found.