The Excel course will provide the essentials of what there is to know about the program, what it is for and what it is used for, in addition to providing essential tricks and formulas for the daily use of Excel at work.
Knowing the functionalities and potentialities of the program is essential to be competitive in job searches and to be able to develop professionally.
Planted objectives:
- Learn about one of the most well-known and used programs in the labor market, in addition to the use of the resources that it possesses. Incorporate new knowledge that can be addressed in the course with different routines, "work practices", allowing to exploit its functionalities and ways of working.
- Analyze the operation of tools in Excel on data analysis and automation of the same, including the creation and manipulation of reports, both static and dynamic data tables and their use in our favor.
Upon completion of this course, you will know:
1. How to understand the screens and bars in Excel
2. How to use spreadsheets and workbooks
3. How to select cells in Excel and how to edit them
4. How to Submit an Excel File: Submission Format
5. How to use addresses
6. How to use formulas in Excel
7. How to Create Charts in Excel
8. How to Link Data
9. How to create pivot tables and charts
Introduction: screen and bars.
The initial screen, concept of columns, rows and cells.
Bars. Differences and similarities with the office package programs.
Book concept, spreadsheet. Movement and displacement within the leaves. Data types, introduction. Modify data. Save a workbook. Open a workbook
Worksheet management
Cell selection.
Add a selection.
Copy, Cut data using clipboard.
Basic Paste and Special Paste. Differences.
Delete cells - Delete cells. differences
presentation format
Source
Alignment
borders
plots, numbers
Insertion of images: alignment and properties of the image.
Header and footer
addresses
Relative
Absolute
Mixed
Formulas
formula concept
Enter formulas:
DATE
DATEDIF
MONTH
DAY
YEAR
MAX
MIN
AVERAGE
SUM
TELL
WILL COUNT
COUNTBLANK
COUNT YES
AND
OR
YES
Function nesting
Copy formulas from neighboring and distant cells
Formulas and functions. Concept and differences.
General formulas and functions. Practical examples of all the functions given.
Enter functions with the wizard.
data series
Conditional Yes nested.
styles
Conditional format
Data
Cell Validation
Filters
Order
Graphics
Graphics
Create charts from the wizard.
Modify the formatting properties.
Print. Preview. Set page.
Smart Art
Formulas and Functions
if nested
If nested with nested logical functions
Data base funtions
Search functions
Nesting VLOOKUP and HLOOKUP Functions
Examples of Function Nesting (Several examples are made nesting any function of the Basic and Advanced course)
data binding
Keep an Excel table linked in a Word file
Pivot tables and pivot charts.
Concept
Create a pivot table
Filters. Apply filters to a pivot table
Get averages in a pivot table
Pivot Table Charts
Data
Subtotals
Consolidate data
Advanced filters
Data Tools
Find target
scenarios
remove duplicates
Data table
Knowing the functionalities and potentialities of the program is essential to be competitive in job searches and to be able to develop professionally.
Planted objectives:
- Learn about one of the most well-known and used programs in the labor market, in addition to the use of the resources that it possesses. Incorporate new knowledge that can be addressed in the course with different routines, "work practices", allowing to exploit its functionalities and ways of working.
- Analyze the operation of tools in Excel on data analysis and automation of the same, including the creation and manipulation of reports, both static and dynamic data tables and their use in our favor.
Upon completion of this course, you will know:
1. How to understand the screens and bars in Excel
2. How to use spreadsheets and workbooks
3. How to select cells in Excel and how to edit them
4. How to Submit an Excel File: Submission Format
5. How to use addresses
6. How to use formulas in Excel
7. How to Create Charts in Excel
8. How to Link Data
9. How to create pivot tables and charts
Introduction: screen and bars.
The initial screen, concept of columns, rows and cells.
Bars. Differences and similarities with the office package programs.
Book concept, spreadsheet. Movement and displacement within the leaves. Data types, introduction. Modify data. Save a workbook. Open a workbook
Worksheet management
Cell selection.
Add a selection.
Copy, Cut data using clipboard.
Basic Paste and Special Paste. Differences.
Delete cells - Delete cells. differences
presentation format
Source
Alignment
borders
plots, numbers
Insertion of images: alignment and properties of the image.
Header and footer
addresses
Relative
Absolute
Mixed
Formulas
formula concept
Enter formulas:
DATE
DATEDIF
MONTH
DAY
YEAR
MAX
MIN
AVERAGE
SUM
TELL
WILL COUNT
COUNTBLANK
COUNT YES
AND
OR
YES
Function nesting
Copy formulas from neighboring and distant cells
Formulas and functions. Concept and differences.
General formulas and functions. Practical examples of all the functions given.
Enter functions with the wizard.
data series
Conditional Yes nested.
styles
Conditional format
Data
Cell Validation
Filters
Order
Graphics
Graphics
Create charts from the wizard.
Modify the formatting properties.
Print. Preview. Set page.
Smart Art
Formulas and Functions
if nested
If nested with nested logical functions
Data base funtions
Search functions
Nesting VLOOKUP and HLOOKUP Functions
Examples of Function Nesting (Several examples are made nesting any function of the Basic and Advanced course)
data binding
Keep an Excel table linked in a Word file
Pivot tables and pivot charts.
Concept
Create a pivot table
Filters. Apply filters to a pivot table
Get averages in a pivot table
Pivot Table Charts
Data
Subtotals
Consolidate data
Advanced filters
Data Tools
Find target
scenarios
remove duplicates
Data table
Show More
