Excel 2003 for Dummies Quick Reference (häftad)
Fler böcker inom
Format
Häftad (Paperback)
Språk
Engelska
Antal sidor
194
Utgivningsdatum
2003-10-01
Upplaga
1
Förlag
WILEY
Medarbetare
Banfield, Colin
Illustrationer
Illustrations
Dimensioner
215 x 145 x 20 mm
Vikt
270 g
Antal komponenter
1
Komponenter
book
ISBN
9780764539879
Excel 2003 for Dummies Quick Reference (häftad)

Excel 2003 for Dummies Quick Reference

Häftad Engelska, 2003-10-01
159
Skickas inom 7-10 vardagar.
Fri frakt inom Sverige över 159 kr för privatpersoner.
If youre using Excel 2003 and youd rather be working on your projects instead of plodding through everything you could ever need to know (and may never need to know) about Excel, this is the reference for you. In a compact, info-packed, spiral-bound book that puts the facts you need at your fingertips, it covers the basics most Excel users need to know, including:
    Opening, saving protecting, and recovering workbook files and using workbook templates
  • Adding, copying, and deleting worksheets, e-mailing worksheet data, and publishing worksheet data to the Web
  • Entering and editing data and text and working with cells and ranges
  • Creating formulas and functions
  • Creating and using names
  • Auditing, formatting, and printing your work
  • Charting your data
  • Analyzing data with pivot tables

Complete with concise, step-by-step explanations (most of which take less than one page) and lots of screen shots and tables, this no nonsense guide gets you working instead of searching or reading, A detailed index makes it easy to find what you need to know fast. Excel 2003 For Dummies is a practical, at-a-glance reference for any Excel user.
Visa hela texten

Passar bra ihop

  1. Excel 2003 for Dummies Quick Reference
  2. +
  3. The Complete YouTube Book: What Works for My Channel with 8+ Million Views?

De som köpt den här boken har ofta också köpt The Complete YouTube Book: What Works for My Ch... av Michel Gerard, Jerry Banfield (häftad).

Köp båda 2 för 418 kr

Kundrecensioner

Har du läst boken? Sätt ditt betyg »

Fler böcker av författarna

Övrig information

Colin Banfield has worked in the telecommunications field for more than 20 years. He has used spreadsheet programs for over 18 years, including every version of Microsoft Excel. Colin's largest Excel project to date is a comprehensive tool designed for central office equipment configuration, pricing, and manufacturing, which is used by sales, engineering and manufacturing personnel. In his spare time, Colin enjoys photography, astronomy, chess and expanding his musical repertoire. John Walkenbach is the leading authority on spreadsheet software. He is the author of more than two dozen spreadsheet books and has written more than 300 articles and reviews for a variety of publications, including PC World, InfoWorld, Windows magazine, and PC/Computing. He is also the principal of JWalk and Associates Inc., a consulting firm that specializes in spreadsheet application development.

Innehållsförteckning

The Big Picture: Microsoft Office Excel 2003.


What You See: The Excel Window.


What You See: Dialog Boxes.


Toolbar Table.


The Basics: Starting Excel.


The Basics: Getting Acquainted with Excel.


Navigating with the keyboard.


Navigating with the mouse.


Understanding the Excel menu bar.


The Basics: Getting Help.


The Basics: Creating an Empty Workbook File.


The Basics: Saving a Workbook File.


The Basics: Opening a Workbook File.


The Basics: Closing a Workbook File and Exiting Excel.


What You Can Do: Create and Analyze Data.


What You Can Do: Show Data Graphically.


What You Can Do: Import Data for Analysis.

Part I: Using Workbook Files.


Changing the Default File Location.


Creating Multiple Windows (Views) for a Workbook.


Deleting a Workbook File.


Opening Nonstandard Files.


Opening a non-Excel or older Excel file.


Opening a workspace file.


Protecting a Workbook File.


Recovering Workbook Files after a System Crash.


Saving Files.


Saving a workbook under a different name.


Saving a workbook in a different or older file format.


Saving a workspace file.


Switching among Open Workbooks.


Working with Workbook Templates.


Creating a workbook template.


Creating a workbook from a template.


Creating a default workbook template.

Part II: Working with Worksheets.


Activating Worksheets.


Adding a New Worksheet.


Arranging Windows Automatically.


Changing a Worksheets Name.


Coloring a Worksheet Tab.


Copying a Worksheet.


Deleting a Worksheet.


E-Mailing Worksheet Data.


Freezing Row or Column Titles.


Hiding and Unhiding a Worksheet.


Moving a Worksheet.


Protecting a Worksheet.


Publishing Your Worksheet Data to the Web.


Publishing your worksheet data to a Web page.


Republishing your worksheet data to the Web.


Splitting Panes.


Using Full-Screen View.


Zooming Worksheets.

Part III: Entering and Editing Worksheet Data.


Copying Cells and Ranges.


Copying a cell to another cell or a range.


Copying a range to another range.


Copying data to another worksheet or workbook.


Copying multiple cells or ranges to another range.


Deleting Entire Rows and Columns.


Editing a Cells Contents.


Entering Data into a Range.


Entering data into a specific range.


Entering the same data into a range of cells.


Entering Dates and Times.


Entering specific dates and times.


Entering the current date or time.


Entering Formulas.


Entering formulas manually.


Entering formulas by pointing.


Entering Text.


Entering text into cells.


Completing text entries by using AutoComplete.


Entering ...