Excel 2010 bible [recurso electrónico] / John Walkenbach.

Por: Walkenbach, JohnTipo de material: TextoTextoDetalles de publicación: Indianapolis, Ind. : Wiley Pub., c2010Descripción: 1 online resource (xliv, 1006 p.) : illISBN: 9780470634745 (electronic bk.); 047063474X (electronic bk.); 9781621984269 (electronic bk.); 1621984265 (electronic bk.); 9780470474877; 0470474874Otro título: Microsoft Excel 2010 bible [Título de cubierta]Tema(s): Microsoft Excel (Computer file) | Electronic spreadsheets | Business -- Computer programs | COMPUTERS -- Desktop Applications -- Spreadsheets | Microsoft Excel (Computer file) | Electronic spreadsheets | Business / Computer programs | Microsoft Excel (Computer file) | Business -- Computer programs | Electronic spreadsheets | Microsoft Excel (Computer file)Género/Forma: Electronic books. | Electronic books.Formatos físicos adicionales: Print version:: Excel 2010 bible.Clasificación CDD: 005.54 Clasificación LoC:HF5548.4.M523 | W34579 2010ebRecursos en línea: Libro electrónicoTexto
Contenidos:
pt. 1. Getting started with Excel -- pt. 2. Working with formulas and functions -- pt. 3. Creating charts and graphics -- pt. 4. Using advanced Excel features -- pt. 5. Analyzing data with Excel -- pt. 6. Programming Excel with VBA -- pt. 7. Appendixes.
pt. 1: Getting started with Excel. Introducing Excel -- Entering and editing worksheet data -- Essential worksheet operations -- Working with cells and ranges -- Introducing tables -- Worksheet formating -- Understanding Excel files -- Using and creating templates -- Printing your work -- pt. 2: Working with formulas and functions. Introducing formulas and functions -- Creating formulas that manipulate text -- Working with dates and times -- Creating formulas that count and sum -- Creating formulas that look up values -- Creating formulas for financial applications -- Introducing array formulas -- Performing magic with array formulas -- pt. 3: Creating charts and graphics. Getting started making charts -- Learning advanced charting -- Visualizing data using conditional formatting -- Creating sparkline graphics -- Enhancing your work with pictures and drawings -- pt. 4: Using advanced Excel features. Customizing the Excel user interface -- Using custom number formats -- Using data validation -- Creating and using worksheet outlines -- Linking and consolidating worksheets -- Excel and the internet -- Sharing data with other office applications -- Using Excel in a workgroup -- Protecting your work -- Making your worksheets error-free -- pt. 5: Analyzing data with Excel. Getting data from external database files -- Introducing pivot tables -- Analyzing data with pivot tables -- Performing spreadsheet what-if analysis -- Analyzing data using goal seeking and solver -- Analyzing data with the analysis toolpak -- pt. 6: Programming Excel with VBA. Introducing Visual Basic for Applications -- Creating custom worksheet functions -- Creating userforms -- Using userform controls in a worksheet -- Working with Excel events -- VBA examples -- Creating custom Excel add-ins.
Resumen: "An authoritative reference, this perennial bestseller proves itself indispensable no matter your level of skill, from Excel beginners and intermediate users to power users and potential power users everywhere. Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques you won't find anywhere else. Excel 2010 Bible serves as an excellent resource on all things Excel!"--Resource description p.
Star ratings
    Valoración media: 0.0 (0 votos)
Existencias
Tipo de ítem Biblioteca actual Colección Signatura Copia número Estado Fecha de vencimiento Código de barras
Libro Electrónico Biblioteca Electrónica
Colección de Libros Electrónicos HF5548.4 .M523 W34579 2010 EB (Browse shelf(Abre debajo)) 1 No para préstamo 369632-2001

Includes index.

"An authoritative reference, this perennial bestseller proves itself indispensable no matter your level of skill, from Excel beginners and intermediate users to power users and potential power users everywhere. Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques you won't find anywhere else. Excel 2010 Bible serves as an excellent resource on all things Excel!"--Resource description p.

pt. 1. Getting started with Excel -- pt. 2. Working with formulas and functions -- pt. 3. Creating charts and graphics -- pt. 4. Using advanced Excel features -- pt. 5. Analyzing data with Excel -- pt. 6. Programming Excel with VBA -- pt. 7. Appendixes.

pt. 1: Getting started with Excel. Introducing Excel -- Entering and editing worksheet data -- Essential worksheet operations -- Working with cells and ranges -- Introducing tables -- Worksheet formating -- Understanding Excel files -- Using and creating templates -- Printing your work -- pt. 2: Working with formulas and functions. Introducing formulas and functions -- Creating formulas that manipulate text -- Working with dates and times -- Creating formulas that count and sum -- Creating formulas that look up values -- Creating formulas for financial applications -- Introducing array formulas -- Performing magic with array formulas -- pt. 3: Creating charts and graphics. Getting started making charts -- Learning advanced charting -- Visualizing data using conditional formatting -- Creating sparkline graphics -- Enhancing your work with pictures and drawings -- pt. 4: Using advanced Excel features. Customizing the Excel user interface -- Using custom number formats -- Using data validation -- Creating and using worksheet outlines -- Linking and consolidating worksheets -- Excel and the internet -- Sharing data with other office applications -- Using Excel in a workgroup -- Protecting your work -- Making your worksheets error-free -- pt. 5: Analyzing data with Excel. Getting data from external database files -- Introducing pivot tables -- Analyzing data with pivot tables -- Performing spreadsheet what-if analysis -- Analyzing data using goal seeking and solver -- Analyzing data with the analysis toolpak -- pt. 6: Programming Excel with VBA. Introducing Visual Basic for Applications -- Creating custom worksheet functions -- Creating userforms -- Using userform controls in a worksheet -- Working with Excel events -- VBA examples -- Creating custom Excel add-ins.

Description based on print version record.

19

Con tecnología Koha