All people working in service or manufacturing companies.

Orientation to results, continuous improvement, critical capacity.

1. CUSTOM FORMAT
2. CELL FILL

1. With numbers.

1. CONDITIONAL FORMAT
2. With text.
3. With dates.

1. Creating validations.
2. Adding Informative Messages to the Capture.
3. Adding Custom Messages of Capture error.

1. FORMULAS AND FUNCTIONS

1. Difference between Formula and Function.
2. Applying Functions.
3. If Logical Functions.
4. If Nested.
5. Lookup Functions.

1. CONVERTING A TEXT INTO COLUMNS

1. Text Separation.
2. Date Conversion.

1. ORGANIZING INFORMATION

1. Organizing Ascending and Descending Information.
2. Alphabetic type.
3. Numerical type.

1. FILTERING INFORMATION

1. Auto Filter.
2. Advanced Filters.

1. CREATING AND REMOVING SUBTOTALS

1. GRAPHICS
2. Most commonly used Graphics.
3. Bar Graphs.
4. Secondary Axis.
5. Graphics Tool Menu.
6. Optional graphics.
7. Coropletic Maps.
8. 3D Maps.

1. TABLES

1. Properties of a Table.
2. Table design.
3. Table Menu.

1. SECURITY

1. Protecting Files and Workbooks.
2. Hiding and Showing Workbooks.
3. Protecting and Unprotecting Spreadsheets.
4. Hiding and Showing Spreadsheets.
5. Blocking and Unblocking Graphic Objects.
6. Spreadsheet Level Security.
7. Unblocking Cell ranges.
8. Hiding and Showing Formulas.

1. LISTS

1. Creating a List.
2. Removing a List.
3. Vinculating Function Lists.
4. Applying totals to a list.

1. HYPERLINKS

1. Creating Hyperlinks.
2. Creating Hyperlinks from a Text.
3. Creating Hyperlinks from Images.
4. Eliminating Hyperlinks.
5. Using Hyperlinks.

1. CONSOLIDATING INFORMATION

1. Working with Multiple Books.

1. OBTAINING EXTERNAL DATA

1. From Text.
2. From Web.
5. From the Web.
6. Combining Consults.

1. ANALYSIS

1. Search Objective.

1. DYNAMIC TABLES AND GRAPHICS

1. Design area, row, column, page, and data.
2. Creating a Dynamic Table.
5. Calculated Fields.
6. Calculated Elements.
7. Creating a Dynamic Graph.
8. Calculated Elements Fields.
11. Moving a dynamic table.
12. Obtain dynamic data Function.

1. POWER PIVOT

1. Adding a Power Pivot tab.
2. Power Pivot window.
3. Immporting an Access database.
4. Diagram View.
5. Linking Data.
6. Creating a Dynamic Table.
7. Calculateds fields.

1. MACROS

1. What is a Macro?
2. Macros Recorder.
3. Ways of Executing a Macro.
4. Introduction to Excel VB.
5. Creating a Custom Function.
6. Automating a report.
7. Displaying external images.
8. Creating an application using Macros.
9. Creating Power Point slides from an Excel database.

• A diagnose exam will be applied before starting the course to learn the audience levels.
• Every assistant will receive a manual.
• The course includes practice exercises for each subject.
• There will be a knowledge test based on the learned topics at the end of the course.

Registration in STPS (WCC1008026U2-0013)