Excel 2019 bible
Uloženo v:
| Hlavní autoři: | , , |
|---|---|
| Médium: | Livre numérique |
| Jazyk: | Anglais |
| Vydáno: |
Indianapolis, IN :
Wiley
2018.
Paris : Cyberlibris |
| Témata: | |
| On-line přístup: | Accès Université d'Orléans et IFPM |
| Poznámka: |
Couverture. https://static2.cyberlibris.com/books_upload/136pix/9781119514770.jpg Includes index Cyberlibris (ScholarVox) corpus Informatique |
| Autres localisations: | Voir dans le Sudoc |
| Edition sous un autre format: | • Excel 2019 bible, Michael Alexander, Dick Kusleika, previously by John Walkenbach, 2019, Indianapolis, IN, Wiley, 1 vol. (xlv-1074 p.), 978-1-119-51478-7 |
Obsah:
- Getting started with Excel
- Working with formulas and functions
- Creating charts and other visualizations
- Managing and analyzing data
- Analyzing data using goal seeking and solver
- Understanding power pivot and power query
- Automating 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
- 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
- Getting started with Excel charts
- Using advanced charting techniques
- Creating sparkline graphics
- Visualizing with custom number formats and shapes
- Implementing Excel dashboarding best practices
- 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 with the analysis toolpak
- Protecting your work
- 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
- Introducing visual basic for applications
- Creating custom worksheet functions
- Creating custom worksheet functions
- Creating userforms