Administrative Excel - Level II: new online course

New course: ADMINISTRATIVE EXCEL LEVEL II

Start: June 27, 2023.
Hours: Tuesday and Thursday from 8 a.m. to 10 a.m. (12 classes)

Modality: online (Videoconference)

Contents:

MODULE 1: Dynamic Tables
Characteristics of dynamic tables. Create, filter, edit and format pivot tables. Filter, show and hide data in a pivot table. Modify the summary function of a pivot table. Generate three-dimensional references to values ​​that are contained in dynamic tables. Create fields and calculated elements. Apply conditional formats to the data contained in a dynamic table. Data segmentation. Use slicer to filter data from dynamic tablesmicas. Create a slicer on an existing pivot table. Format a slicer.
Dynamic graphics. Create pivot charts using pivot tables. Create pivot charts and pivot tables in parallel. Customize the appearance of dynamic charts.

MODULE 2: Sparklines
Create sparklines. Add text to a sparkline. Customize sparklines. Control the value points displayed on a sparkline. Format a sparkline.

MODULE 3: Macros
Introduction to macros. Create a macro. Delete a macro.
Run a macro. Run a macro using the menu. Run a macro from the keyboard. Run a macro from the quick access toolbar. Run a macro automatically when opening a workbook. Assign a macro to an object. Macro security. Create buttons to run macros.

Inquiries and registrations: 

WhatsApp +54 341 670-2765

info@tallerjc.org.ar