The Fictioning Horror Sale
 
 

Recently Viewed clear list


Powell's Q&A | September 3, 2014

Emily St. John Mandel: IMG Powell’s Q&A: Emily St. John Mandel



Describe your latest book. My new novel is called Station Eleven. It's about a traveling Shakespearean theatre company in a post-apocalyptic North... Continue »
  1. $17.47 Sale Hardcover add to wish list

    Station Eleven

    Emily St. John Mandel 9780385353304

spacer
Qualifying orders ship free.
$8.50
Used Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Local Warehouse Microsoft Windows- Applications

Microsoft Excel 2003 Top 100 Simplified Tip 2ND Edition

by

Microsoft Excel 2003 Top 100 Simplified Tip 2ND Edition Cover

 

Synopses & Reviews

Publisher Comments:

Top 100 Simplified Tips & Tricks

You already know Excel 2003 basics. Now you'd like to go beyond with shortcuts, tricks, and tips that let you work smarter and faster. And because you learn more easily when someone shows you how, this is the book for you. Inside, you'll find clear, illustrated instructions for 100 tasks that reveal cool secrets, teach timesaving tricks, and explain great tips guaranteed to make you more productive with Excel 2003.

5-Star Learning System

  1. Minimal text and maximum illustrations
  2. Task-oriented, step-by-step approach
  3. Navigational aids connect instructions to illustrations
  4. Self-contained, two-page lessons
  5. Uniform layout makes it easy to read less, learn more

Synopsis:

* Taking readers beyond the basics, the full-color screen shots and numbered, step-by-step instructions show how to save time and boost productivity

Synopsis:

* Providing timesaving tips, cool secrets, and productivity tricks, this book is completely updated for the newest version of Excel

* The task-oriented approach presents adventurous readers with 100 useful and surprising techniques that can be performed with the latest version of Excel, the dominant spreadsheet and data analysis tool that's part of the Microsoft Office suite

* Taking readers beyond the basics, the full-color screen shots and numbered, step-by-step instructions show how to save time and boost productivity

Synopsis:

Excel 2003: Top 100 Simplified Tips and Tricks, 2nd Edition provides adventurous users with 100 useful and surprising techniques that can be performed in the latest version of Excel. Organized into 10 chapters, with 10 tasks per chapter, Excel 2003: Top 100 Simplified Tips and Tricks, 2nd Edition provides the time-saving tips, cool secrets, and productivity tricks to help take a reader’ s knowledge of Excel beyond the basics. Full-color screen shots and numbered, step-by-step instructions show readers how to save time and boost productivity.

Table of Contents

1. Working with Data.

#1 Enter Numbers and Fractions.

#2 Enter Dates and Times.

#3 Name Cells and Ranges.

#4 Validate Data Entry Using a Pick List.

#5 Extend a Series of Dates with Autofill.

#6 Add a Symbol or Special Character.

#7 Compare Multiple Spreadsheets Using Freeze Panes.

#8 Hide Rows to Compare Data with Outlining.

#9 Access Excel by Keyboard.

#10 Access Excel by Voice with Speech Recognition.

#11 Find and Replace Data.

#12 Generate a Worksheet Using InfoPath.

2. Working with Formulas and Functions.

#13 Add Values in Different Ways.

#14 Make Magic with the Function Wizard.

#15 Document Formulas with Comments.

#16 Document Worksheets with OneNote.

#17 Define a Constant.

#18 Apply Names in Functions.

#19 Figure Out the Best Loan Terms.

#20 Determine the Internal Rate of Return.

#21 Determine the Nth Largest Value.

#22 Create a Conditional Function.

#23 Calculate a Conditional Sum.

#24 Discover Your Inner Calculator.

#25 Find Products and Square Roots.

#26 Calculate the Duration Between Two Times.

#27 Calculate Days Between Two Dates.

#28 Change Text to Numbers.

3. Copying Data, Formats, and More.

#29 Copy a Range with the Office Clipboard.

#30 Transpose a Row into a Column.

#31 Copy Styles to Another Workbook.

#32 Copy Chart Formatting into Another Chart.

#33 Copy Formulas with Paste Special.

#34 Track Changes while Editing.

4. Using Excel Lists.

#35 Generate a List Automatically.

#36 Enter List Data Using a Form.

#37 Import a Word List into Excel.

#38 Sort and Filter a List.

#39 Sort by Multiple Criteria.

#40 Find Averages in a Sorted Group.

#41 Filter by Multiple Criteria.

#42 Remove Duplicate Records from a List.

#43 Count Filtered Records.

#44 Filter by Multiple Criteria in the Same Column.

#45 Chart a Filtered List.

#46 Look Up Information in a List.

5. Exploring Patterns in Data.

#47 Create a PivotTable.

#48 Modify PivotTable Data and Layout.

#49 Find the Average of a Field.

#50 Create a Calculated Field.

#51 Hide Rows or Columns in a PivotTable.

#52 AutoFormat a PivotTable.

#53 Create a PivotChart.

#54 Describe Data with Statistics.

#55 Discover Associations within Your Data.

#56 Explore Outcomes with What-If Analysis.

#57 Optimize a Result with Goal Seek.

6. Creating Charts.

#58 Create a Chart.

#59 Modify Chart Details.

#60 Change the Chart Type.

#61 Add a Trendline to a Chart.

#62 Add and Remove Chart Data.

#63 Visually Represent Missing Chart Data.

#64 Use Error Bars in a Chart.

#65 Pull a Slice from a Pie Chart.

#66 Label the Slices of a Pie Chart.

#67 Create a Histogram.

#68 Paste a Chart into Word.

#69 Embed a Chart into Word.

7. Presenting Worksheets.

#70 Format Numbers as Percentages.

#71 Format a Column of Currencies.

#72 Format Column Headings.

#73 Format Quickly with Format Painter.

#74 Group Formats in a Style.

#75 Insert a Background Image into Your Worksheet.

#76 Create a Transparent Image.

8. Saving and Printing Worksheets.

#77 Save a Workbook as a Template.

#78 Save a Workbook as an XML Spreadsheet.

#79 Print Multiple Cell Ranges on One Page.

#80 Print Multiple Areas of a Workbook.

#81 Print Multiple Worksheets of a Workbook.

#82 Repeat Headings of a Row and Column.

#83 Print Functions to Show Calculations.

9. Extending Excel.

#84 Hyperlink a Worksheet to Another Office Document.

#85 Embed a Chart within PowerPoint.

#86 Publish an Interactive Workbook.

#87 Import a Worksheet from the Web.

#88 Query a Web Site.

#89 Query an Access Database.

#90 Reuse a Saved Query.

#91 Import a Worksheet into Access.

#92 Use Excel Data to Create Labels in Word.

10. Customizing Excel.

#93 Add Features by Installing and Using Add-Ins.

#94 Launch a Specific Workbook when Excel Opens.

#95 Create a Custom Workspace.

#96 Save Time by Creating a Custom View.

#97 Create a Custom Number Format.

#98 Create a Macro to Format Numbers.

#99 Create a Button to Run a Macro.

#100 Enlarge Screen Elements.

Product Details

ISBN:
9780764597619
Author:
Peal, David
Publisher:
Visual
Subject:
Spreadsheets - Excel
Subject:
Electronic spreadsheets
Subject:
Spreadsheets - General
Subject:
Microsoft Excel
Copyright:
Edition Number:
2
Series:
Top 100 Simplified: Tips & Tricks
Series Volume:
15
Publication Date:
20050422
Binding:
Electronic book text in proprietary or open standard format
Grade Level:
General/trade
Language:
English
Illustrations:
Y
Pages:
240
Dimensions:
9.94x8.48x.56 in. 1.75 lbs.

Other books you might like

  1. Powerpoint 2003 Top 100 Simplified T... Used Trade Paper $1.75
  2. Blackwater: The Rise of the World's...
    Used Hardcover $7.50
  3. Eleven on Top (Stephanie Plum Novels) Used Mass Market $3.50
  4. Twelve Sharp (Stephanie Plum Novels)
    Sale Hardcover $1.00
  5. The Warslayer: The Incredibly True... Used Mass Market $4.95
  6. Voyage of the Shadowmoon Used Mass Market $1.95

Related Subjects

Computers and Internet » Computers Reference » General
Computers and Internet » Operating Systems » Microsoft Windows » Applications

Microsoft Excel 2003 Top 100 Simplified Tip 2ND Edition Used Trade Paper
0 stars - 0 reviews
$8.50 In Stock
Product details 240 pages JOHN WILEY & SONS - English 9780764597619 Reviews:
"Synopsis" by , * Taking readers beyond the basics, the full-color screen shots and numbered, step-by-step instructions show how to save time and boost productivity
"Synopsis" by , * Providing timesaving tips, cool secrets, and productivity tricks, this book is completely updated for the newest version of Excel

* The task-oriented approach presents adventurous readers with 100 useful and surprising techniques that can be performed with the latest version of Excel, the dominant spreadsheet and data analysis tool that's part of the Microsoft Office suite

* Taking readers beyond the basics, the full-color screen shots and numbered, step-by-step instructions show how to save time and boost productivity

"Synopsis" by , Excel 2003: Top 100 Simplified Tips and Tricks, 2nd Edition provides adventurous users with 100 useful and surprising techniques that can be performed in the latest version of Excel. Organized into 10 chapters, with 10 tasks per chapter, Excel 2003: Top 100 Simplified Tips and Tricks, 2nd Edition provides the time-saving tips, cool secrets, and productivity tricks to help take a reader’ s knowledge of Excel beyond the basics. Full-color screen shots and numbered, step-by-step instructions show readers how to save time and boost productivity.
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.