Excel Parte 1 (2013-2019)

Categoría:

 Excel Parte 1  (2013-2019)

UFI-1001

Logo Excel

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.

  • El curso tiene una duración de 16 horas.

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

El curso incluye

Instructor Certificado

Material Digital

Certificado de participación

Modalidades

Online con profesor en directo

Semipresencial

Presencial (TEOREMA/In House)

B-Learning / Híbrida