Goal

Enable the trainee to create spreadsheets from the simplest to the most complex, pivot tables, tables with mathematical functions, financial calculations, date and time functions, search functions, references such as Procv.

In this course we will also work with chained functions, dynamic tables and graphs, as well as graphs and macros.

Program

1. Advanced spreadsheet formatting

2. Formulas and Functions

3. Data series

4. Data management

5. Simulation techniques

6. Creating graphs

7. Create and use macros

8. The Forms

9. Review Tools

10. Excel's connections with other applications

11. Integrating Excel with the Internet Transforming Excel documents into HTML format