Course – Advanced Excel 

Excel Avanzado_Mesa de trabajo 1
  • 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.
Llama-PNG2

Request information

Error: Contact form not found.

slot gacor slot gacor