Excel 2007 bible / John Walkenbach.

Format:

Book

Author/Creator:

Walkenbach, John.

Series:

Bible

Language:

English

Subjects (All):

Microsoft Excel (Computer file).

Electronic spreadsheets--Computer programs.

Physical Description:

1 online resource (913 p.)

Edition:

1st edition

Other Title:

Microsoft Office Excel 2007 Bible

Place of Publication:

Indianapolis, IN : Wiley, c2007.

Language Note:

English

System Details:

text file

Summary:

This book is a single reference that's indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhereFully 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 elseJohn Walkenbach, aka ""Mr. Spreadsheet,"" is one of the liworld's leading authorities on ExcelThoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded co

Contents:

Excel 2007 Bible; About the Author; Credits; Contents at a Glance; Contents; Acknowledgments; Introduction; Is This Book for You?; Software Versions; Conventions This Book Uses; What the Icons Mean; How This Book Is Organized; How to Use This Book; What's on the Companion CD; Part I: Getting Started with Excel; Chapter 1: Introducing Excel; What Is Excel Good For?; Understanding Workbooks and Worksheets; Moving Around a Worksheet; Introducing the Ribbon; Using the shortcut menus; Customizing your Quick Access Toolbar; Working with Dialog Boxes; Using the Taskbar

Creating Your First Excel WorksheetChapter 2: What's New in Excel 2007?; A New User Interface; Larger Worksheets; New File Formats; Worksheet Tables; Styles and Themes; Better Looking Charts; Page Layout View; Enhanced Conditional Formatting; Consolidated Options; SmartArt; Formula AutoComplete; Collaboration Features; Compatibility Checker; Improved Pivot Tables; New Worksheet Functions; Other New Features; Chapter 3: Entering and Editing Worksheet Data; Exploring the Types of Data You Can Use; Entering T ext and Values into Y our Workshets; Entering Dates and Times into Y our Workshets

Modifying Cel ContentsAplying Number Formating; Chapter 4: Essential Worksheet Operations; Learning the Fundamentals of Excel Worksheets; Controlling the Worksheet View; Working with Rows and Columns; Chapter 5: Working with Cells and Ranges; Understanding Cells and Ranges; Copying or Moving Ranges; Using Names to Work with Ranges; Adding Comments to Cells; Chapter 6: Introducing Tables; What Is a Table?; Creating a Table; Changing the Look of a Table; Working with Tables; Chapter 7: Worksheet Formatting; Getting to Know the Formatting Tools; Using Formatting in Your Worksheets

Using Named Styles for Easier FormattingUnderstanding Document Themes; Chapter 8: Understanding Excel's Files; Excel File Operations; Excel File Compatibility; Chapter 9: Using and Creating Templates; Exploring Excel Templates; Understanding Custom Excel Templates; Chapter 10: Printing Your Work; Printing with One Click; Changing Your Page View; Adjusting Common Page Setup Settings; Adding a Header or Footer to Your Reports; Adjusting the Settings in the Print Dialog Box; Preventing Certain Cells from Being Printed; Preventing Objects from being Printed

Creating Custom Views of Your WorksheetPart II: Working with Formulas and Functions; Chapter 11: Introducing Formulas and Functions; Understanding Formula Basics; Entering Formulas into Your Worksheets; Editing Formulas; Using Cell References in Formulas; Using Formulas In Tables; Correcting Common Formula Errors; Using Advanced Naming Techniques; Tips for Working with Formulas; Chapter 12: Creating Formulas That Manipulate Text; A Few Words About Text; Text Functions; Advanced Text Formulas; Chapter 13: Working with Dates and Times; How Excel Handles Dates and Times; Date-Related Functions

Time-Related Functions

Notes:

Includes index.

ISBN:

9786610740581

9781118050675

1118050673

9781280740589

1280740582

9780470117088

0470117087

OCLC:

243563090