OBJECTIVES

Master the most professional tools and data management, learning functions of Microsoft Excel as important as: Matrices, graphics, advanced formulas, advanced formats, templates, work with external data ... In this way the student will be able to create Excels completely to suit him and take advantage of most of the potential that this program offers, reaching the Macros, PivotTables or professional forms.

DURATION

25 hours

TIMETABLE

1. Primer Sign

a. Days: Wednesday and Friday from 16:00 to 18:30

b. Start date: 19-2-24

c. Application Deadline: 20-3-24

d. Class days

1) February/23: 19th,21th,26th,28th

2) March/23: 4,6,11,13,18,20

2. Second round

a. Days: Monday and Tuesday of 18: 30 TO 21: 00

b. Hours: 18: 00 to 21: 00

c. Start date: 2-9-24

d. Application Deadline: 8-10-24

e. Class days

1) September/24: 2,3,9,10,16,17,30

2) October/24: 1,7,8

CONTENT

1. Environment Review of basic concepts.

2. Advanced features.

3. Cell formats and conditional formats.

4. Advanced graphics.

5. Lists.

6. Pivot tables and pivot charts.

7. Find goal.

8. Scenarios.

9. Matrix formulas.

10. Data import and export.

11. Introduction to macros.

 

PRICE

475,00 euros