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
6 hours.
Lugar
.
Nogales, Arizona.
Mayores Informes
Carlos Valdés Robles, M.A.
Director, Zigma Consulting
cvaldes@zigmaconsulting.com
Oficina (662)208 2849
Cel. (662)222 7865