Home > Store > Computer Software > Business Office Software > Spreadsheet Software > Microsoft Excel
Special Edition Using Microsoft Excel 2000
- By Patrick Blattner, Ken Cook, Laurie Ulrich, Timothy Dyck
- Published May 3, 1999 by Que. Part of the Special Edition Using series.
- Register your product - get bonus material or coupon.
- Book
- ISBN-10: 0-7897-1729-8
- ISBN-13: 978-0-7897-1729-0
FAQs
Question 1: I can not find the date function NETWORKDAYS that is listed in the Date and Time functions list in Excel 2000.
Solution 1: This is from the Help files in Excel:
Returns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays. Use NETWORKDAYS to calculate employee benefits that accrue based on the number of days worked during a specific term.
If this function is not available, run the Setup program to install the Analysis ToolPak. After you install the Analysis ToolPak, you must enable it by using the Add-Ins command on the Tools menu.
How?
Syntax
NETWORKDAYS(start_date,end_date,holidays)
Start_date is a date that represents the start date.
End_date is a date that represents the end date.
Holidays is an optional range of one or more dates to exclude from the working calendar, such as state and federal holidays and floating holidays.
Remark
If any argument is not a valid date, NETWORKDAYS returns the #NUM! error value.
Example
NETWORKDAYS(DATEVALUE("10/01/91"), DATEVALUE("12/01/91"),
DATEVALUE("11/28/91")) equals 43
Question 2: Why must I call 1-800-385-2155 to activate the CD?
Solution 2: The CD-ROM contains an extra 650 Office Ready Templates that can be purchased for 50% off the normal retail price! This is a special offered from Canon that we have included with this title. The number has been recently verified and you can still call today and request a new password for the cost of $19.95 to unlock the extra 650 Office Ready Templates featured on the CD-ROM. They'll accept VISA, MasterCard, Discover, and American Express.
If you are outside of the US or Canada, you can contact their technical support department at 757-413-2855 and request to be transferred to the sales department to be able to purchase the number.
Special Edition Using Microsoft Excel 2000 puts a renewed emphasis on realistic applications and uses of the program features. This book does NOT take the cradle to grave approach in coverage. You get the most focused content and value of the essential intermediate to advanced level coverage. Additional coverage of undocumented features, often ignored topics, and practical advice on how to set up a "designer" look spreadsheet is provided. There is no waste of space--or your time--on beginner level coverage.
|
44 of 44 people found the following review helpful
This book is the best of its class!,
This review is from: Special Edition Using Microsoft Excel 2000 (Paperback)
In "Using Excel 2000", Patrick Blattner sets new benchmarks for clarity, thoroughness, and progressive teaching of its subject matter. It is actually a joy to read its 1000+ pages. I was probably a low-end intermediate user of Excel when I purchased the book. I started at the beginning of the book to refresh and upgrade my understanding from Excel 97 to Excel 2000. I constantly found myself amazed at what I was learning and there were several times when I actually felt drawn in to reading 20 or 40 more pages than I had originally intended to read at one sitting because I wanted to see what came next. Within the first couple of days of owning this book, I was committed to reading the book cover-to-cover and moving up to becoming a power user of Excel. I have been raving about the quality of Blattner's book to clients, associates and friends and highly recommend it to Excel users of any skill level. For the first time I actually look forward to reading... Read more
38 of 38 people found the following review helpful
Excellent,
By A Customer
This review is from: Special Edition Using Microsoft Excel 2000 (Paperback)
This is by far the most uselful book I've bought this year. I consider myself an above-average user when it comes to Excel, and wanted to get a head start on this new release before my office upgrades. When I purchase a computer book I want something that reads easily, and explains the workings of the software in a coherent way. I'd bought Laurie Ulrich's books in the past and stuck with her for just these reasons. Blattner's chapters read almost as well, and I guess that's why the publishers teamed them up: they know what they're talking about, and know how to explain it. The best thing about this book is you don't need to be a rocket scientist to get something out of it. My wife, who's not a computer person, has been using the book too and feels it's one of the few books that doesn't make her feel inadequate because she's not a "power-user". What more can I say? I highly recommend it.
26 of 26 people found the following review helpful
When trainers write, everybody wins, By "hargus1304" (Arizona) - See all my reviews
This review is from: Special Edition Using Microsoft Excel 2000 (Paperback)
This Special Edition Using Excel is the exception to my personal rule that Really Big Computer Books are boring and hard to use. This book is accessible and clear, but doesn't baby you. Having taught myself to use Excel, I had a lot of holes in my own knowledge base, and this book helped me master basic things (like setting up a worksheet, editing my data) and the more advanced stuff I need to do (like setting up pivottables, building macros, and adding Excel objects to other applications). If you have other needs, you'll find them covered in this book.Now about that training ---- I am a big fan of training, and have taken a lot of computer classes, both live and online. I never got around to taking an Excel class, though, but after using this book, I feel like I did take a class. This is probably due to fact that one of the writers (Ulrich) is a trainer. The book starts with basic concepts, to make sure everyone has the foundation topics down and then moves through an impressive... Read more |
Table of Contents
Introduction.
I. WORKBOOK BASICS.
II. EDITING WORKSHEET CONTENT.
III. FORMATTING AND PRINTING EXCEL WORKSHEETS.
IV. USING FORMULAS AND FUNCTIONS.
V. CREATING AND MODIFYING CHARTS.
VI. ANALYZING AND MANAGING YOUR DATA.
VII. TAKING EXCEL TO THE NEXT LEVEL.
VIII. INTEGRATING EXCEL WITH OTHER APPLICATIONS.
IX. CUSTOMIZING AND AUTOMATING EXCEL.
Book
$39.99
$31.99
We're temporarily out of stock, but order now and we'll send it to you later.
This book is temporarily out of stock, but will ship for free when in stock.
- Request an Instructor or Media review copy
- Corporate, Academic, and Employee Purchases
- International Buying Options
Get access to thousands of books and training videos about technology, professional development and digital media from more than 40 leading publishers, including Addison-Wesley, Prentice Hall, Cisco Press, IBM Press, O'Reilly Media, Wrox, Apress, and many more. If you continue your subscription after your 30-day trial, you can receive 30% off a monthly subscription to the Safari Library for up to 12 months. That's a total savings of $199.
