Excel 2007 - Advanced (English)

Study&Go
Online

95€ - ($65.301)
¿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: Learn how to print reports and give them a professional look. Learn how to use and create outlines both manually and automatically. Learn how change the worksheet's label appearance, to apply advanced formats, create templates and conditional formats. Use and create advances functions. Organizing and summarizing data, customizing lists and calculating subtotals.
Dirigido a: The present course is fully oriented to anyone who desires to acquire knowledge of the most advanced range of applications this spreadsheet tool provides.

Información importante

¿Qué aprendes en este curso?

Excel

Temario

Document Views and Printing
  • Introduction
  • Preparing the worksheet before printing
  • The Preview
  • Printing the document
  • The Print dialogue box
  • Summary
Using Outlines
  • Introduction
  • The Usefulness of Outlines
  • Automatic outline creation
  • Hide Outlines
  • Eliminating outlines
  • Manually creating an outline
  • Copy Outline data
  • Creating charts form outlines
  • Summary
Advanced format notions
  • Introduction
  • Templates
  • The themes
  • Conditional Formats
  • Worksheet Label appearance
  • Summary
Advanced functions
  • Introduction
  • Functions
  • The IF function
  • The NOW function
  • The PMT function
  • The VLOOKUP function
  • Specific conditions
  • Summary
Organizing and Summarizing data
  • Introduction
  • Organizing data lists
  • Customized sorting
  • Customized lists
  • Calculating subtotals
  • Summary
Merge multiple data sources
  • Introduction
  • Linking data
  • Editing links
  • Consolidating worksheets
  • Multiple data groups
  • Summary
Analyzing alternate data
  • Introduction
  • The data analysis
  • Scenario creation
  • Scenarios
  • Multiple alternate data groups
  • Find objective
  • Summary
Advanced chart ideas
  • Introduction
  • Choosing the right chart
  • Data placement
  • Show hidden data and empty cells
  • Insert a picture in the chart
  • SmartArt charts
  • Change the SmartArt chart design
  • Summary
Pivot Tables
  • Introduction
  • The usefulness of PivotTables
  • Create PivotTables
  • Pivot Data Analysis
  • Pivot Table data filters
  • PivotCharts
  • Summary
The Macros in Excel
  • Introduction
  • Creating a Macro
  • Edit Macros
  • Executing Macros
  • Macro Security
  • Summary
Teamwork with Excel
  • Introduction
  • Sharing data lists
  • Working with comments
  • Change management
  • Data protection
  • Save for the Internet
  • Summary

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