Excel 2007 - Basic (English)

Study&Go
Online

95€ - ($67.920)
IVA inc.
¿O prefieres llamar ahora al centro?
+34 9... Ver más
Compara este curso con otros similares
Ver más cursos similares

Información importante

  • Curso
  • Online
  • 30 horas de dedicación
Descripción

Objetivo del curso: Use several basic tools of the programme. Learn about Excel working environment and how to personalize it. Learn how to create spreadsheets and enter data both manually and automatically. Learn how to create data tables and use database functions. Use and analyze formulas and functions in order to perform calculations and learn how to use references.
Dirigido a: The present course is fully oriented to anyone who desires to acquire knowledge of the basic range of applications this spreadsheet tool provides.

Información importante

¿Qué aprendes en este curso?

Excel

Temario

Excel Introduction
  • Introduction
First Steps with Excel 2007
  • Introduction
  • The Excel Window
  • Working with books
  • The worksheet
  • Summary
The Work Area
  • Introduction
  • About Movement
  • Working with rows and columns
  • Working with cells
  • Summary
Introducing Data
  • Introduction
  • Insert data
  • Editing data
  • Data modification
  • Summary
Improve data insertion
  • Introduction
  • Automate data entry
  • Revision Options
  • Summary
Tables
  • Introduction
  • Creating a table
  • Table editing
  • Database functions
  • Summary
Calculations with data
  • Introduction
  • Ranges
  • The formulas
  • Summary
Basic Functions
  • Introduction
  • Working with functions
  • The Function argument
  • Function Categories
  • Summary
The Excel Worksheet format
  • Introduction
  • Format Cells
  • Font Format
  • Format Options
  • Cell styles
  • Pictures
  • Summary
Filters and validation rules
  • Introduction
  • Data restriction
  • The AutoFilter tool
  • Creating Custom Filters
  • More filters
  • Working with filtered data
  • Establish validation rules
  • Summary
Insert Charts
  • Introduction
  • Create charts
  • Chart elements
  • Chart modifications
  • Customize chart appearance
  • Save as template
  • Establish data trends
  • Summary

Compara este curso con otros similares
Ver más cursos similares