Excel 2019 bible /
Guardado en:
| Autor principal: | |
|---|---|
| Otros Autores: | , |
| Formato: | eBook |
| Lenguaje: | inglés |
| Publicado: |
Indianapolis, IN :
Wiley,
[2019]
|
| Materias: | |
| Acceso en línea: | Ebook suscrito en eLibro.net |
| Etiquetas: |
Sin Etiquetas, Sea el primero en etiquetar este registro!
|
Tabla de Contenidos:
- Getting started with Excel. Introducing Excel
- Entering an dediting worksheet data
- Performing basic worksheet operations
- Working with Excel ranges and tables
- Formatting worksheets
- Understanding Excel files and templates
- Printing your work
- Customizing the Excel user interface
- Working with formulas and functions. Introducing formulas and functions
- Using formulas for common mathematical operations
- Using formulas to manipulate text
- Using formulas with dates and times
- Using formulas for conditional analysis
- Using formulas for matching and lookups
- Using formulas for financial analysis
- Using formulas for statistical analysis
- Using formulas with tables and conditional formatting
- Understanding and using array formulas
- Making your formulas error-free
- Creating charts and other visualizations. Getting started with Excel charts
- Using advanced charting techniques
- Creating sparkline graphics
- Visualizing with custom number formats and shapes
- Implementing Excel dashboarding best practices
- Managing and analyzing data. Importing and cleaning data
- Using data validation
- Creating and using worksheet outlines
- Linking and consolidating worksheets
- Introducing PivotTables
- Analyzing data with PivotTables
- Performing spreadsheet what-if analysis
- Analyzing data using goal seeking and solver
- Analyzing data with the analysis toolpak
- Protecting your work
- Understanding power pivot and power query. Introducing power pivot
- Working directly with the internal data model
- Adding formulas to power pivot
- Introducing power query
- Transforming data with power query
- Making queries work together
- Enhancing power query productivity
- Automating Excel. Introducing visual basic for applications
- Creating custom worksheet functions
- Creating custom worksheet functions
- Creating userforms
- Using userform controls in a worksheet
- Working with Excel events
- Seeing some VBA examples
- Creating custom Excel add-ins.