Microsoft Excel Training: Intermediate Level Workshop

Inicia: 07-03-2020
Lugar: Nogales, Arizona.
Modalidad: Presencial

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 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


  • 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


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

Del 07 de marzo al
07 de marzo del 2020

Saturday from 8:00 a.m. to 2:00 p.m.

6 hours.
Santa Cruz Center. 2021 North Grand Ave. Nogales, AZ 85621
Nogales, Arizona.
Mayores Informes
Carlos Valdés Robles, M.A.
Director, Zigma Consulting
Oficina (662)208 2849
Cel. (662)222 7865

Notas Importantes

If the same company, organization or institution enrolls 3 participants in one specific workshop, a fourth participant could enroll in the same course at no cost.

Proceso de Inscripción


Llenar solicitud de inscripción en línea


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


Confirmación de pago
Envíenos su comprobante de pago a

Programas Relacionados

No hay programas relacionados.