Microsoft Excel Training: Intermediate Level Workshop

Inicia: 07-03-2020
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 07 de marzo al
07 de marzo del 2020
Horarios

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



Duración
6 hours.
Lugar
Santa Cruz Center. 2021 North Grand Ave. Nogales, AZ 85621
Nogales, Arizona.
Inversión

$175 per participant 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

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

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