Microsoft Excel
* Combining nine books in one, this thorough desk reference delivers the know-how readers need to take full advantage of Excel
* Outlines the most practical and useful applications of Excel for the workplace
* Explains how to import data, build and edit worksheets, create formulas, generate pivot tables, and work with financial functions, what-if scenarios, database functions, and Web queries
* Explores more advanced topics such as worksheet sharing ... Read More
* Outlines the most practical and useful applications of Excel for the workplace
* Explains how to import data, build and edit worksheets, create formulas, generate pivot tables, and work with financial functions, what-if scenarios, database functions, and Web queries
* Explores more advanced topics such as worksheet sharing ... Read More
When you think of number-crunching and spreadsheets, you think of Excel, right? After Word, it’s the most popular program in the Microsoft Office suite. But if technical jargon isn’t your first language, you may have found Excel just a teeny bit frustrating. It can be really hard to pick your way through the many features and make Excel do what you need for it to do.
Once you know how, you can use Excel to ... Read More
A complete package for learning Excel 2010!
As the leading spreadsheet application, Excel is an essential data analysis and business tool. With this dynamic combination of a full-color printed book and a Dummies interactive eLearning course on CD, you'll find a wealth of information on the latest release of Excel. Featuring both written and animated step-by-step how-tos, practice labs, helpful videos, numerous examples, and a host of Dummies hints ... Read More
Every time you turn around, you run into Excel. It’s on your PC at work. It’s on your PC at home. You get Excel files from your boss. Wouldn’t you like to understand this powerful Microsoft Office spreadsheet program, once and for all? Now, you can crunch financial data, add sparkle to presentations, convert static lists of numbers into impressive charts, and discover what all the shouting’s about regarding databases, formulas, and cells. You may ... Read More
The bestselling Excel book on the market, updated for Excel 2010
As the world's leading spreadsheet application, Excel has a huge user base. The release of Office 2010 brings major changes to Excel, so Excel For Dummies comes to the rescue once more!
In the friendly and non-threatening For Dummies style, this popular guide shows beginners how to get up and running with Excel and helps more experienced users get comfortable with new features. ... Read More
This Quick Reference will quickly get you up to speed with Excel's new features, whether you're a novice user or an expert. You'll master how to easily publish interactive Web pages that include spreadsheets and tables. You'll learn how to use new Smart Tags to access real-time data from the Web for your Excel documents. You will be able to use Excel's latest speech recognition capabilities to "talk to your spreadsheets, ... Read More
Just because electronic spreadsheets like Excel 2002 have become almost as commonplace on today's personal computers as word processors and games doesn't mean that they're either well understood or well used. If you're one of the many folks who has Office XP on your computer but doesn't know a spreadsheet from a bedsheet, this means that Excel 2002 is just sitting there taking up a lot of space. Well, it's high time to change all that. ... Read More
Just because electronic spreadsheets like Excel 97 have become almost as commonplace on today's personal computers as word processors and games doesn't mean that they're well understood or well used. In fact, many computer users – even those well versed in the art of writing and editing in Microsoft Word – have little or no idea of what they could or should do in Excel.
Do you fall into that category? If so, rest assured – you're not alone. Excel ... Read More
The good news is that Microsoft Excel is out in a brand-new version with more features than ever before. The bad news is that this brand-new version contains plenty of new functions and commands to remember. So, to help you work productively with Excel 97 without being hindered by differences in its new functions, IDG Books Worldwide, Inc., presents Excel 97 For Windows For Dummies Quick Reference. In this book, you can find all the tips, shortcuts ... Read More
Just because electronic spreadsheets like Excel 2000 have become almost as commonplace on today’s personal computers as word processors and games doesn’t mean that they’re either well understood or well used. Excel is a great organizer for all types of data, be they numeric, textual, or otherwise.
Excel 2000 For Windows For Dummies covers all the fundamental techniques that you need to know in order to create, edit, format, and print your own worksheets ... Read More
Spreadsheet. Does that word send shivers down your spine? Well, you can’t ignore it if you need to create tables, charts, or lists of information to do your job. Loads of people get it done with the Excel spreadsheet program, but it’s a safe bet that most Excel users don’t know its full potential. You may get by just fine after you learn the basics, but Excel can automate many tasks and save time. You’ll have more time for fun things and may even ... Read More
El hecho que las hojas electrónicas como Excel 2002 se hayan vuelto tan comunes en las computadoras personales de hoy día como los procesadores de palabras y juegos, no quiere decir que son bien entendidas o bien usadas. Si usted es una de las muchas personas que tiene Office XP en su computadora pero no diferencia una hoja electrónica de una hoja de papel, esto significa que Excel 2002 está simplemente ocupando mucho espacio. Bueno, es hora de cambiar ... Read More
"Today, no accomplished Excel programmer can afford to be without John's book. The value of Excel 2003 Power Programming with VBA is double most other books-simultaneously the premier reference and best learning tool for Excel VBA."
--Loren Abdulezer, Author of Excel Best Practices for Business
Everything you need to know about:
* Creating stellar UserForms and custom dialog box alternatives
* Working with VBA subprocedures and function procedures
* ... Read More
--Loren Abdulezer, Author of Excel Best Practices for Business
Everything you need to know about:
* Creating stellar UserForms and custom dialog box alternatives
* Working with VBA subprocedures and function procedures
* ... Read More
If you're ready to take the next step with Excel, then look no further. By using VBA (Visual Basic Application), you can discover a side of Microsoft Excel that most users never uncover. Excel 2000 Programming For Dummies introduces you to a wide array of new Excel options, including options for creating new worksheet functions; automating tasks and operations; creating new appearances, toolbars, and menus; and doing much more. ... Read More
By itself, Excel 97 can do some pretty amazing stuff. Add Visual Basic for Applications (VBA) and you add a whole other dimension of automation and customization. Excel 97 Programming For Windows For Dummies offers plenty of practical examples of Excel programming in action and explains in plain English how to
* Save time and improve accuracy by automating common tasks
* Design custom dialog boxes to suit your and your organization's needs
* Build specialized ... Read More
* Save time and improve accuracy by automating common tasks
* Design custom dialog boxes to suit your and your organization's needs
* Build specialized ... Read More
From formulas to functions to the latest features - practice and plan Excel tasks with ease
Confused by Excel? Want to make the most of its capabilities? No worries - this hands-on workbook gets you up to speed in a step-by-step manner. From navigating the new user interface and creating your first spreadsheet to using formulas, working with charts and graphics, managing and securing data, and creating macros, you'll do it all with the help of practice ... Read More
Confused by Excel? Want to make the most of its capabilities? No worries - this hands-on workbook gets you up to speed in a step-by-step manner. From navigating the new user interface and creating your first spreadsheet to using formulas, working with charts and graphics, managing and securing data, and creating macros, you'll do it all with the help of practice ... Read More
(E-Book also available)
From our partner Element K
This online course covers the basics of creating Excel spreadsheets, creating and using formulas and functions, and formatting worksheets. You will move at your own pace through three interactive lessons, discovering how worksheets work, how to add and edit content, what formulas and functions do, and how to format your spreadsheet to best demonstrate your data.
From our partner Element K
In this online course, you'll learn how to create and format several types of Excel charts, present data clearly, use financial functions, work with math, statistical, and text functions, store and manage data in tables and lists, work with PivotTables and PivotCharts, and correct, protect, and share your workbook data. The seven interactive lessons take you step-by-step through the process, so you learn at your own pace.
Spreadsheets have become the de facto standard for communicating business information and the preferred tool for analyzing business data. In this current climate, the accuracy and clarity of spreadsheets are paramount. However, busy managers have little time to sift through heaps of reference books to extrapolate techniques for making polished spreadsheets. Even with finished spreadsheets in hand, managers and business professionals still need a book ... Read More
Excel is the most popular tool for number crunching on the PC, but the challenge is in putting a meaningful face on those raw numbers. That’s where Excel Charts For Dummies comes in. Ken Bluttman will show readers how to professionally display data in presentation-quality charts. But he’ll go beyond showing readers how to create attractive charts—he’ll explain why to use specific charts in particular circumstances. Lots of real-world examples will ... Read More
So here’s a funny deal: You know how to use Excel. You know how to create simple workbooks. And how to print stuff. And you can even, with just a little bit of fiddling, create cool-looking charts. But sometimes you wish that you could do more with Excel, such as how to use Excel to really gain insights into information, the data, that you work with in your job.
Using Excel for this kind of stuff is what ... Read More
If you’re using Excel 2003 and you’d 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: ... Read More
Whatever you're now doing with Microsoft Excel there's much more you could be doing. The world's most popular spreadsheet program, Excel grows richer in features with each new release. Excel For Dummies puts at your disposal all the powerful capabilities of version 5 -- capabilities for everything from manipulating databases to creating three-dimensional charts. Whether you're new to Excel or just new to version 5, bestselling author Greg Harvey's ... Read More
Everything you need to know about
* Mastering operators, error values, naming techniques, and absolute versus relative references
* Debugging formulas and using the auditing tools
* Importing and exporting XML files and mapping the data to specific cells
* Using Excel 2003's rights management feature
* Working magic with array formulas
* Developing custom formulas to produce the results you need
Here's the formula for Excel excellence
Formulas are the lifeblood ... Read More
* Mastering operators, error values, naming techniques, and absolute versus relative references
* Debugging formulas and using the auditing tools
* Importing and exporting XML files and mapping the data to specific cells
* Using Excel 2003's rights management feature
* Working magic with array formulas
* Developing custom formulas to produce the results you need
Here's the formula for Excel excellence
Formulas are the lifeblood ... Read More
