Excel Parte 1 (2013-2019)
UFI-1001
Sobre este curso
El curso Excel parte 1 (2013-2019) cubre los conceptos básicos necesarios para la generación, revisión, almacenaje e impresión de hojas de cálculo básicas.
DURACIÓN
- El curso tiene una duración de 16 horas.
TEMARIO
METHODS
- Open a workbook
- Save a workbook
- Set a print area of workbook
- Identify the interface ribbon tabs
- Identify rows and column names
- Identify what are workbooks and worksheets
- Copy and paste an image to the clipboard
- Workbook operations
- General knowledge
- Manipulating a large data range
- Paste Special
FUNCTIONS
- Enter a simple formula in a cell
- Perform addition, subtraction, division or multiplication in a formula
- Identify correct order of operations
- Enter a time in a cell
- Insert a SUM function
- Recognize the ERROR symbol
- Calculations and formulas
- Calculation methods
FORMATTING
- Recognize a bar chart or pie chart
- Use conditional formatting
- Select the best chart to represent a set of data
- Format table text with bold, italics
- Format table color
- Format a table with borders
- Apply, define, modify a cell
- Perform a simple sort
- Filter data in a table
- Insert a simple graphic object
- Apply conditional formatting
- Centre text across several columns
- Insert SmartArt
- Insert graphics
- Apply a theme to a table
- Use Flash Fill
- Merge cells
- Create Sparklines
DATA MANIPULATION
- Perform a simple sort
- Filter data in a table
- Insert a simple graphic object
- Charts
- Sorting data
- Pivot Tables
- Goal Seek
Instructor Certificado
Material Digital
Certificado de participación
Online con profesor en directo
Semipresencial
Presencial (TEOREMA/In House)
B-Learning / Híbrida
Word 2013-2019
Powerpoint 2013-2019
OUTLOOK 2013-2019
