Book:
F1 Get the Most Out of Excel Formulas and Functions: The Ultimate Excel Formulas and Functions Help GuideAuthor:
Joseph RubinPages:
460Format:
PDFLanguage:
EnglishISBN10:
0974636851With more than 300 solutions to the time-consuming problem of combining Microsoft Excel functions into effective, problem-solving formulas, this handbook addresses questions that are regularly posted to Excel newsgroups—topics of the most interest to Excel users. Questions and answers provide a title, problem, solution, explanation, and screenshot, and include many of the complex formulas and their several nested functions. Formulas for wages, shifts, time sheets, income taxes, financial calculations, amortization tables, counting, and handling errors are demonstrated, and the accompanying CD-ROM contains Excel workbook files that incorporate all the formulas presented in the book. Each question and answer includes a hyperlink that allows interested readers to visit the author's website to discuss problems and proposed solutions.Review
"A wonderful grab-bag of solutions to all kinds of Excel conundrums." —Simon Benninga, author, Principles of Finance with Excel
"Very easy to follow and the sample files are great for those who want to experiment." —spreadsheetsolutions4u.com 
Book:
Microsoft Office WordAuthor:
Torben Lage FrandsenPages:
1Format:
PDFLanguage:
EnglishISBN10:
8776816551Microsoft Office Word is one of the great free eBooks available to download from BookBooN.com.
Book:
Excel Hacks: 100 Industrial-Strength Tips and ToolsAuthor:
Raina Hawley, David HawleyPages:
304Format:
CHMLanguage:
EnglishISBN10:
059600625XYou don't need to know everything that Excel can do in order to use it effectively, but if you're like the millions of Excel power users looking to improve productivity, then Excel Hacks will show you a wide variety of Excel tasks you can put to use, most of which are off the beaten path. The "100 Industrial Strength Tips and Tools" in Excel Hacks include little known "backdoor" adjustments for everything from reducing workbook and worksheet frustration to hacking built-in features such as pivot tables, charts, formulas and functions, and even the macro language. This resourceful roll-up-your-sleeves guide is for intermediate to advanced Excel users eager to explore new ways to make Excel do things--from data analysis to worksheet management to import/export--that you never thought possible. Excel Hacks will help you increase productivity with Excel and give you hours of "hacking" enjoyment along the way.
Book:
Excel 2003 for Starters: The Missing ManualAuthor:
Matthew MacDonaldPages:
400Format:
CHMLanguage:
EnglishISBN10:
0596101546The dominant spreadsheet program and one of the most widely used software applications in the world, Microsoft Excel is unbelievably powerful--and can be downright intimidating. If you're new to Excel or among the many existing Excel users who are dazed and confused by all that the program can do (and by how little it has actually done for you), Excel for Starter: The Missing Manual is your ideal resource.For everyone who wants to quickly get up to speed on Excel to create, organize, and present household and/or office data and information, this smart new guide delivers just the essentials: it concentrates on the must-have information and the best, most practical Excel features that people like you can use to maximize your productivity and minimize your spreadsheet confusion and frustration.Excel for Starters: The Missing Manual demystifies spreadsheets and explains how to use them most effectively and efficiently. Clear explanations (with lots of examples), step-by-step instructions, helpful illustrations, and timesaving advice guide you through all the most common and useful features of Excel 2002 and 2003--including how to build spreadsheets, add and format information, print reports, create charts and graphics, and use basic formulas and functions.Sure, there are plenty more thorough, more massive Excel books on the bookstore shelves. But why wade your way through a swamp of details you'll never need--or want--to use? Let author Matthew MacDonald, an educator and software developer who also wrote the highly popular Excel: The Missing Manual, be your trusted guide as you learn which Excel features will serve you best and which are best ignored.Utterly practical and refreshingly funny, this down-to-earth guide gives you nothing more (and nothing less) than what you need to make Excel do exactly what you want it to do. It's a quick read you'll want to keep on hand for reference again and again.
Book:
Excel 2007: The Missing ManualAuthor:
Matthew MacDonaldPages:
864Format:
CHMLanguage:
EnglishISBN10:
0596527594Microsoft Excel continues to grow in power, sophistication, and capability, but one thing that has changed very little since the early '90s is its user interface. The once-simple toolbar has been packed with so many features over the years that few users know where to find them all. Microsoft has addressed this problem in Excel 2007 by radically redesigning the user interface with a tabbed toolbar that makes every feature easy to locate and use. Unfortunately, Microsoft's documentation is as scant as ever, so even if users can find advanced features, they probably won't know what to do with them.Excel 2007: The Missing Manual covers the entire gamut of how to build spreadsheets, add and format information, print reports, create charts and graphics, and use basic formulas and functions. Like its siblings in the Missing Manual series, this book crackles with a fine sense of humor and refreshing objectivity about its subject, guiding readers through the new Excel with clear explanations, step-by-step instructions, lots of illustrations, and friendly, time-saving advice. It's a perfect primer for small businesses with no techie to turn to, as well as those who want to organize household and office information.
Book:
Excel 2007 For Dummies Quick ReferenceAuthor:
John Walkenbach, Colin BanfieldPages:
240Format:
PDFLanguage:
EnglishISBN10:
0470046716Fast answers to frequently asked questionsExcel 2007 essentials at your fingertips!
If you like your answers quick and your information up-to-date, look no further. With this concise, superbly organized reference, you'll quickly find just what you need to know about navigating the new interface; using the Ribbon and Quick Access toolbar; saving, protecting, and recovering workbook files; entering and editing data; creating formulas and functions, and much more.
Book:
Excel 2007 for Starters: The Missing ManualAuthor:
Matthew MacDonaldPages:
352Format:
CHMLanguage:
EnglishISBN10:
0596528329Fast-paced and easy to use, this new book teaches you the basics of Excel 2007 so you can start using the program right away. This concise guide shows readers how to work with Excel's most useful features and its completely redesigned interface. With clear explanations, step-by-step instructions, lots of illustrations, and plenty of timesaving advice, Excel 2007 for Starters: The Missing Manual will quickly teach you to:* Build spreadsheets
* Add and format information
* Print reports
* Create charts and graphics
* Use basic formulas and functions
* and moreThe new Excel is radically different from previous versions. Over the years, Excel has grown in power, sophistication and capability, but its once-simple toolbar has been packed with so many features that not even the pros could find them all. For Excel 2007, Microsoft redesigned the user interface completely, adding a tabbed toolbar that makes every feature easy to locate.Unfortunately, Microsoft's documentation is as scant as ever, so even if you find the features you need, you still may not know what to do with them. But with this book, you can breeze through the new user interface and its timesaving features in no time. Excel 2007 for Starters: The Missing Manual is the perfect primer for small businesses with no techie to turn to, as well as those who want to organize household and office information.
Book:
Excel 2007 Just the Steps For DummiesAuthor:
Diane KoersPages:
240Format:
PDFLanguage:
EnglishISBN10:
0470039213* Completely updated to reflect the many changes in the latest release of Excel, this helpful book presents readers with concise instructions for carrying out common Excel 2007 tasks
* An easy-to-navigate design features a two-column layout and is packed with step-by-step directions and illustrations that incorporate the notable changes to Excel 2007
* Readers can pick the task, find it fast, and get it done quickly, all while gaining a clear understanding of Excel 2007 enhancements, such as a new user interface, improved charting and PivotTable capabilities, and better data exchange with XML
Book:
Microsoft Excel 2000 Functions in PracticeAuthor:
Patrick Blattner, Laura StewartPages:
350Format:
PDFLanguage:
EnglishISBN10:
0789720450The Microsoft Excel 2000 Functions in Practice provides in-depth information on the functions that will maximize your use of the analytical tools within Excel 2000. Packed with examples and detailed insight into both the functions and their uses, this reference includes more than just discussions of the functionsit offers practical, real-world usage of them with chapters on crucial topics such as using Excel's functions in your job, database and list-management functions, date and time functions, engineering functions, financial functions, information and logical functions, lookup and reference functions, math and trigonometry functions, and statistical and text functions.
Book:
Excel 2007 All-In-One Desk Reference For DummiesAuthor:
Greg HarveyPages:
824Format:
PDFLanguage:
EnglishISBN10:
0470037385Master the Ribbon, powerful graphics capabilities, and more!Your one-stop guide to great-looking spreadsheets that actually mean somethingCreate colorful spreadsheets and charts, use Live Preview, and maximize everything Excel 2007 has to offer! Find just what you need to know about using the new Ribbon, designing spreadsheets that communicate, editing and printing them, working with formulas, protecting your data when you collaborate, turning out cool charts, and much more. The included four-color insert highlights the Ribbon, new graphics features, and more!Discover how to
Create dynamic spreadsheets with style galleries
Work with more than 40 new cell styles
Automate formatting with Live Preview
Share Excel data with other programs
Use VBA to write custom Excel functions
Book:
Excel 2003 Just the Steps For DummiesAuthor:
Diane KoersPages:
216Format:
PDFLanguage:
EnglishISBN10:
0764574884Choose Data Group and Outline AutoOutline. Figure 11-9 illustrates a worksheet with outline headings for both rows and columns. Row outline symbols are at the top of the worksheet.
AutoOutline works best if the worksheet has summary formulas that reference cells in the detail cells. The summary formulas must be adjacent to the detail.
To expand the outline, click the Show Detailbuttons to the left of the rows or above thecolumn headings. (See Figure 11-10.)
To collapse the outline, click the Hide buttonsto the left of the rows or above the columnheadings.
To remove the AutoOutline, choose Data Group and outline Clear Outline.Get ready to
Format cells and data
Build formulas and functions
Save time with Excel tools
Add color graphics toyour spreadsheets
Analyze your data
Create charts and PivotTables
Book:
Excel 2002 from A to Z: A Quick Reference of More Than 200 Microsoft Excel Tasks, Terms and TricksAuthor:
Stephen L. NelsonPages:
193Format:
PDFLanguage:
EnglishISBN10:
1931150222A handy listing of entries that define important Excel 2002 terms and describe key functions, this book organizes its data alphabetically by task. With this logical organization of information, even new Excel users can get answers quickly and easily. Topics such as how to calculate a financial function, create a chart, or set up a database list are simple to access even without prior knowledge of Excel menu commands. Also provided is information on preparing for and passing the MOUS certification and descriptions of how to troubleshoot problems the new Excel user might encounter.
Book:
Escape From Excel Hell: Fixing Problems in Excel 2003, 2002 and 2000 (Mr. Spreadsheet's Bookshelf)Author:
Loren AbdulezerPages:
408Format:
PDFLanguage:
EnglishISBN10:
0471773182Written especially for advanced beginners and intermediate users, this book offers quick fixes for anyone bedeviled by faulty formulas, failed formatting, printer purgatory, and other perplexing Excel problems
Offers three types of fixes: Escape in Under 30 Seconds, Escape in Under Two Minutes, and More Elaborate Escapes-over 400 solutions in all
Topics covered include formula fixes, formatting fixes, data and layout fixes for Excel charts, PivotTable fixes, managing complexity in very large spreadsheets, fixing broken procedure functions, and more
Includes preventive measures and best practices that teach users how to avoid problems in the future
Book:
Absolute Beginner's Guide to Microsoft Office Excel 2003Author:
Joe KraynakPages:
336Format:
CHMLanguage:
EnglishISBN10:
0789729415Microsoft Excel 2003 is an incredibly versatile and easy-to-use spreadsheet program that helps users calculate and analyze numerical data. Absolute Beginner's Guide to Microsoft Office Excel 2003 teaches new users to get the most from the latest version of the software. With the help of this book, users learn to:
Create spreadsheets that include formulas and built-in Excel functions.
Format numbers and text so that Excel printouts are easy to read.
Use clip art, pictures, borders, and colors to add interest to spreadsheets.
Take Excel data and publish it to the World Wide Web.
Use the Excel Function Wizard to choose the right function to calculate the appropriate result.
Use the Autoformat feature to quickly format an entire worksheet.
Use the new speech feature for voice dictation and voice commands.
