Excel 2007 Bible

John Walkenbach

866 pages, parution le 26/01/2007

Ajouter à une liste

Indisponible

Résumé

This book is a single reference that's indispensable for Excel beginners, intermediate users, power users, and would-be 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 readers won't find anywhere else
John Walkenbach, aka "Mr. Spreadsheet," is one of the liworld's leading authorities on Excel
Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features
Includes a valuable CD-ROM with templates and worksheets from the book

L'auteur - John Walkenbach

Surnommé Mr. Spreadsheet (Monsieur Tableur), John Walkenbach est un spécialiste reconnu des tableurs, et plus particulièrement d'Excel, Auteur de plus de 30 ouvrages et de 300 articles, il a été récompensé pour son utilitaire Power Utility Pak.

Autres livres de John Walkenbach

Programmation VBA pour Excel 2022 pour les nuls

Excel 2019 et VBA pour les nuls

Programmation VBA pour Excel 2019 pour les nuls

Programmation VBA pour Excel pour les nuls

Découvrir tous les livres de John Walkenbach

Sommaire

Getting Started with Excel.
- Introducing Excel.
- What's New in Excel 2007?
- Entering and Editing Worksheet Data.
- Essential Worksheet Operations.
- Working with Cells and Ranges.
- Introducing Tables.
- Worksheet Formatting.
- Understanding Excel's Files.
- Using and Creating Templates.
- Printing Your Work.
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.
Creating Charts and Graphics.
- Getting Started Making Charts.
- Learning Advanced Charting.
- Visualizing Data Using Conditional Formatting.
- Enhancing Your Work with Pictures and Drawings.
Using Advanced Excel Features.
- Customizing the Quick Access Toolbar.
- Using Custom Number Formats.
- Using Data Validation.
- Creating and Using Worksheet Outlines.
- Linking and Consolidating Worksheets.
- Excel and the Internet.
- Sharing Data with Other Applications.
- Using Excel in a Workgroup.
- Protecting Your Work.
- Making Your Worksheets Error-Free.
Analyzing Data with Excel.
- Using Microsoft Query with External Database Files.
- Introducing Pivot Tables.
- Analyzing Data with Pivot Tables.
- Performing Spreadsheet What-If Analysis.
- Analyzing Data Using Goal Seek and Solver.
- Analyzing Data with the Analysis ToolPak.
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.
Appendixes.
- Worksheet Function Reference.
- What's on the CD-ROM.
- Additional Excel Resources.
- Excel Shortcut Keys.

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Wiley
Auteur(s)	John Walkenbach
Parution	26/01/2007
Nb. de pages	866
Format	18,6 x 23,3
Couverture	Broché
Poids	1290g
Intérieur	Noir et Blanc
EAN13	9780470044032
ISBN13	978-0-470-04403-2