Excel Parte 1  (2013-2019)

• 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