Microsoft Excel Training: Intermediate Level Workshop

Inicia: 20-09-2019
Lugar: Nogales, Arizona.

Solicitar programa Inscríbete

Microsoft Excel Training: Intermediate Level Workshop

Objetivo General

By the end of this course the participants will be able to create charts, work effectively with multiple sheets in workbooks, use basic functions effectively, use productivity tools and work with the Excel list/database features.

Contenido Temático

Functions

 

  • Functions types
  • How to use the most frequent functions
  • Relative Cells and Absolute Cells
  • Reference to Absolute Cells

Most Frequent Functions

  • Understanding functions
  • Summing non-contiguous ranges
  • Calculating an average
  • Maximum and minimum functions
  • Common error messages

Chart

  • Understanding The Charting Process
  • Choosing The Chart Type
  • Creating A New Chart
  • Working With An Embedded Chart
  • Resizing The Chart
  • Dragging A Chart
  • Printing An Embedded Chart
  • Creating A Chart Sheet
  • Changing The Chart Type
  • Changing the Chart Layout
  • Changing The Chart Style
  • Printing A Chart Sheet
  • Embedding A Chart Into A Worksheet
  • Deleting A Chart
  • Understanding chart layout elements
  • Adding a chart title
  • Adding axes titles
  • Positioning the legend
  • Showing data labels
  • Showing a data table
  • Modifying the axes
  • Showing gridlines
  • Formatting the plot area
  • Showing the plot area
  • Adding a trendline
  • Adding error bars
  • Adding a text box to a chart
  • Drawing shapes in a chart

Working with Tables & Data Tables

  • Creating a table
  • Inserting or deleting table records
  • Removing duplicates
  • Modifying a table
  • Sorting data in a table
  • Filtering data in a table
  • Adding and removing table columns
  • Naming tables
  • Resizing tables
  • Playing with table styles
  • Converting a table to a range
  • Deleting a table

Data

  • Understanding filtering
  • Applying and using a filter
  • Clearing a filter
  • Creating compound filters
  • Multiple value filters
  • Creating custom filters
  • Using wildcards

Fecha
Del 20 de septiembre al
21 de septiembre del 2019
Horarios

Friday from 3:00 p.m. to 9:00 p.m. and Saturday from 8:00 a.m. to 2:00 p.m.



Duración
12 hours.
Lugar
.
Nogales, Arizona.
Inversión

$350 dollars with cash, check or credit card at the Santa Cruz Center reception office.

Mayores Informes
Carlos Valdés Robles, M.A.
Director, Zigma Consulting
cvaldes@zigmaconsulting.com
Oficina (662)208 2849
Cel. (662)222 7865

Notas Importantes

Participants are required to use a computer with Microsoft Excel installed.

Proceso de Inscripción

01

Llenar solicitud de inscripción en línea

02

Efectuar pago y proporcionar datos fiscales
Espera nuestra confirmación de inscripción antes de realizar cualquier pago.
Ver formas de pago

03

Confirmación de pago
Envíenos su comprobante de pago a info@zigmaconsulting.com

Programas Relacionados