Excel Advanced
THIS COURSE IS MEANT FOR
All people, in general from service or manufacturing companies.
DEVELOPING COMPETENCIES:
Performance orientation, continuous improvement, critical capacity.
OBJECTIVE
At the end of the course, the attendant will be able to apply correctly the skills in Excel program as dynamic tables, and use of Macros.
TOPICS
I. CONSOLIDATE INFORMATION
A. Multiple work
II. IMPORT DATA
A. From text
B. From Web
C. Access
D. ODBC
III. GET EXTERNAL DATA
A. Import data
B. New Web Query
C. New data base query
IV. ANALYSIS AND YES
A. Seeking a purpose
B. Scenarios
C. Solver
V. TABLES AND DYNAMIC GRAPHICS
A. Design area, line, column, page, and data
B. Create an Excel table
C. Format
D. Filters
E. Calculated fields
F. Create a Dynamic Graphic
VI. MACROS
A. What is a Macro?
B. Macro recorded
C. Different ways to execute a Macro
D. Create a personalized function
E. Automate a report
F. Create an application of Macros
BENEFITS
- At the beginning a diagnostic test shall be applied to know the audience levels
- A manual shall be delivered for each attendant
- The course includes practices for each topic
- At the end of the course shall be applied a test about the knowledge of the explained topics