Shop Categories
- Investing
- Capullo, Greg
- Brucato, Phil
- U.S. Regional
- Jedi Apprentice
- Signac, Paul
- Jakes, T.D.
- Social History
- Comparative
- Deforestation
- Barton, William
- Kimbriel, Katharine Eliska
- Portuguese
- General
- Business Law
- Low Carbohydrate
- Mucha, Alphonse Marie
- Davidson, Diane Mott
- Lindskold, Jane
- ( M )
- Weather
- General
- Soil Science
- Houston
- Miller, Sasha
- Twelve-Step Programs
- Aliphatic Compounds
- Prisoners of War
- Reference
- Jordan, June
- Some of our other sites:
- Books
- Clothing, Shoes and Accessories
- Baby Clothes and Accessories
- Cosmetics, Beauty Products and Fragrances
- Cellphones, Call Plans and Accessories
- Video Games
- DVDs
- Electronics, Gadgets and Computers
- Health and Personal Care
- Home and Garden
- Home DIY
- Jewelry
- Magazines and Newspapers
- Music Downloads
- Musical Instruments
- Office Equipment and Supplies
- Software and Games
- Sporting Goods
- Toys and Games
- Watches
- UK Books
- UK Video Games
- UK Home and Garden
- UK Electronics, Gadgets and Computers
- UK Baby Clothes and Accessories
- UK Software and Games
- UK Sporting Goods
- UK Toys and Games
Books : Computers & Internet : Software : Spreadsheets
-
These double-sided squares are capable of holding lightweight objects up to 2 lbs. Holds: Up to 2 lbs.; Permanent/Removable/Repositionable: Permanent; Length: 1 in; Width: 1 in.
-
- This book is a single reference that’s indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere
- Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won’t find anywhere else
- John Walkenbach, aka "Mr. Spreadsheet," is one of the liworld’s leading authorities on Excel
- Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features
- Includes a valuable CD-ROM with templates and worksheets from the book
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
-
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 even decide that getting organized with a good spreadsheet is downright useful and fun!Flip open Excel 2003 For Dummies, and you’ll quickly start getting the basics of Excel in plain English. Written for the rest of us, this down-to-earth book gently shows you how to:
- Create a spreadsheet from scratch
- Apply the basics of formatting cells
- Take on database forms—even add records—and prevail
- Get organized and stay that way
- Save worksheets as Web pages for your company intranet
In a clear and easy-to-understand style, veteran software trainer and technology writer Greg Harvey explains the basics of worksheets and workbooks, how to enter data and work with formulas, and how to print your masterpieces. When you’re feeling very bold, he’ll have you adding comments and pictures, saving files with security protection, and learning to zip between multiple worksheets in a workbook with ease. And there’s much more:
- Clip and save the Top Ten Beginner Basics of Excel 2003
- Pay heed to the Top Ten Commandments of Excel 2003
- Impress your colleagues by creating a company org chart
- Re-open those documents and add or edit new data with aplomb
- Move between these sheets without trouble
- Decipher and take charge of helpful tools and commands such as Sort, Filter, Format Cells, and PivotTable
You’ll finally be able to stop pestering the Excel experts in your office. Become your own expert with the friendly and down-to-earth practical instruction you’ll find in Excel 2003 For Dummies.
-
Excel provides an easy-to-use, powerful spreadsheet environment that helps you handle calculations and data more effectively - with simple ways to enter and edit data, work with formulas and functions for complex calculations, format worksheets and work with colorful charts, and publish documents to the Web. With MICROSOFT EXCEL 2007 STEP BY STEP, you'll learn all the ins and outs of working with Excel features, including the exciting new interface for this latest version of Office. This information-packed guide provides numbered steps and hands-on examples that show you how to get the most out of Excel. With this book, you'll learn how to work with tools to make worksheet entry faster, make your Excel documents more attractive, present information visually with charts, sorting and filtering data, publish documents on the Web, and lots more. The companion CD provides all exercise source files so that you get hands-on with Excel right away.The smart way to learn Office Excel 2007--one step at a time! Work at your own pace through the easy numbered steps, practice files on CD, helpful hints, and troubleshooting help to master the fundamentals of working with the latest version of Excel, including how to navigate the new user interface. You'll learn how to create a wide-variety of documents, how to present information visually with charts, and how to add graphics to your spreadsheets. You will discover how to work with features to make data entry faster, how sort and filter data, how to create dynamic lists with Pivot Tables, and even how to publish your documents to the Web--plus more! With STEP BY STEP, you can take just the lessons you need or work from cover to cover. Either way, you drive the instruction--building and practicing the skills you need, just when you need them! Includes a companion CD with hands-on practice files.
-
- This book is a single reference that’s indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere
- Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won’t find anywhere else
- John Walkenbach, aka "Mr. Spreadsheet," is one of the world’s leading authorities on Excel
- Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features
- Includes a valuable CD-ROM with templates and worksheets from the book
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
-
* The most comprehensive guidebook available on the most popular spreadsheet program, fully updated to include all-new "X" features
* Written by the leading Excel guru known as "Mr. Spreadsheet," John Walkenbach, who has written more than thirty books and 300 articles on related topics and maintains the popular Spreadsheet Page at www.j-walk.com/ss
* The definitive reference book for beginning to advanced users, featuring expert advice and hundreds of examples, tips, techniques, shortcuts, work-arounds, and more
* Covers expanded use of XML and Web services to facilitate data reporting, analysis, importing, and exporting information
* Explores Excel programming for those who want advanced information
* CD-ROM includes all templates and worksheets used in the book, as well as sample chapters from all Wiley Office "X" related Bibles and useful third party software, including John Walkenbach's Power Utility Pak
-
Microsoft 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.
-
Having Excel and just using it for standard spreadsheets is a little like getting the ultimate cable system and a 50” flat panel plasma HDTV and using it exclusively to watch Lawrence Welk reruns. With Visual Basic for Applications (VBA) programming, you can take advantage of numerous Excel options such as: creating new worksheet functions; automating tasks and operations; creating new appearances, toolbars, and menus; designing custom dialog boxes and add-ins; and much more.This guide is not for rank Excel amateurs. It’s for intermediate to advanced Excel users who want to learn VBA programming (or whose bosses want them to learn VBA programming). You need to know your way around Excel before you start creating customized short cuts or systems for speeding through Excel functions. If you’re an intermediate or advanced Excel user, Excel VBA For Dummies helps you take your skills (and your spreadsheets) to the next level. It includes:
- An introduction to the VBA language
- A hands-on, guided, step-by-step walk through developing a useful VBA macro, including recording, testing, and changing it, and testing it
- The essential foundation, including the Visual Basic Editor (VBE) and its components, modules, Excel object model, subroutines and functions, and the Excel macro recorder
- The essential VBA language elements, including comments, variables and constants, and labels
- Working with Range objects and discovering useful Range objective properties and methods
- Using VBA and worksheet functions, including a list and examples
- Programming constructions, including the GoTo statement, the If-Then structure, Select Case, For-Next loop, Do-While loop, and Do-Until loop
- Automatic procedures and Workbook events, including a table and event-handler procedures
- Error-handling and bug extermination techniques, and using the Excel debugging tools
- Creating custom dialog boxes, also known as UserForms, with a table of the toolbox controls and their capabilities, how-to for the dialog box controls, and UserForm techniques and tricks
- Customizing the Excel toolbars
- Using VBA code to modify the Excel menu system
- Creating worksheet functions and working with various types of arguments
- Creating Excel add-ins such as new worksheet functions you can use in formulas or new commands or utilities
Author John Walkenbach is a leading authority on spreadsheet software and the author of more than 40 spreadsheet books including Excel 2003 Bible and Excel 2003 Power Programming with VBA. While this guide includes tons of examples and screenshots, Walkenbach knows there’s no substitute for hands-on learning. The book is complete with:
- A dedicated companion Web site that includes bonus chapters plus all sample programs to save you a lot of typing and let you play around and experiment with various changes
- Information to help you make the most of Excel’s built-in Help system so you can find out other stuff you may need to know
What are you waiting for? Sure, learning to do VBA programming takes a little effort, but it’s a Very Big Accomplishment.
-
Master the analysis and business modeling techniques that help you transform your data into bottom-line results. Award-winning business professor and corporate consultant Wayne Winston shares the best of his real-world experience in this practical guide now updated for Excel 2007. Use Wayne s proven practices and hands-on exercises to help you work smarter, make better decisions, and gain the competitive edge. Solve real-world business problems with Excel 2007! Maximize profits determine NPV, optimize your product mix, calculate ROI Create best, worst, and most-likely case scenarios for sales Analyze investment performance and help minimize risk Track your personal finances, calculate loan terms, and plan for retirement Use trend and seasonality to forecast revenue Estimate a product s demand curve and manage inventory with precision Interpret the effects of price and advertising on sales Assign a dollar value to customer loyalty Solve work scheduling problems and shorten wait times for customer service queues PLUS predict outcomes of sporting events, presidential elections, and more!C D Includes: Sample files from each chapter Problem-and-solution sets build your expertise! Fully searchable eBook
-
"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
* Incorporating event-handling and interactions with other applications
* Building user-friendly toolbars, menus, and help systems
* Manipulating files and Visual Basic components
* Understanding class modules
* Managing compatibility issues
Feel the power of VBA and Excel
No one can uncover Excel's hidden capabilities like "Mr. Spreadsheet" himself. John Walkenbach begins this power user's guide with a conceptual overview, an analysis of Excel application development, and a complete introduction to VBA. Then, he shows you how to customize Excel UserForms, develop new utilities, use VBA with charts and pivot tables, create event-handling applications, and much more. If you're fairly new to Excel programming, here's the foundation you need. If you're already a VBA veteran, you can start mining a rich lode of programming ideas right away.
CD-ROM Includes
* Trial version of the author's award-winning Power Utility Pak
* Over one hundred example Excel workbooks from the book
System Requirements: PC running Windows 2000 SP3 or later, or Windows XP(TM) or later. Microsoft Excel 2003. See the "What's on the CD" Appendix for details and complete system requirements.
-
- This book is a single reference that’s indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere
- Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won’t find anywhere else
- John Walkenbach, aka "Mr. Spreadsheet," is one of the world’s leading authorities on Excel
- Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features
- Includes a valuable CD-ROM with templates and worksheets from the book
-
Learn everything you need to know for working with Microsoft Office Excel 2007--from the inside out! This book packs hundreds of time-saving solutions, troubleshooting tips, and workarounds for using Office Excel 2007--all in concise, fast-answer format. Whether you are upgrading from Office 97 or Office 2003, you'll be able to dig in to the work-ready resources that help you take your Office Excel 2007 experience to the next level. This information-packed complete reference shows you how to get the most out of Office Excel 2007. You will learn how to navigate the product's new features and capabilities, including the new formatting and editing advances such as Live Preview. You'll explore new graphics capabilities, master the charting interface, and learn how to create dynamic lists with PivotTable® reports. You'll even learn how to automate Office Excel with macros, custom functions, and more. Plus, you'll get tools, eBooks, and more on the companion CD. With INSIDE OUT, you get all muscle and no fluff!
-
Master data analysis, modeling, and spreadsheet use with DATA ANALYSIS AND DECISION MAKING WITH MICROSOFT EXCEL! With a teach-by-example approach, student-friendly writing style, and complete Excel integration, this quantitative methods text provides you with the tools you need to succeed. Margin notes, boxed-in definitions and formulas in the text, enhanced explanations in the text itself, and stated objectives for the examples found throughout the text make studying easy. Problem sets and cases provide realistic examples that enable you to see the relevance of the material to your future as a business leader. The CD-ROMs packaged with every new book include the following add-ins: the Palisade Decision Tools Suite (@RISK, StatTools, PrecisionTree, TopRank, and RISKOptimizer); and SolverTable, which allows you to do sensitivity analysis. All of these add-ins have been revised for Excel 2007.
-
Are you a visual learner? Do you prefer instructions that show you how to do something - and skip the long-winded explanations? If so, then this book is for you. Open it up and you'll find clear, step-by-step screen shots that show you how to tackle more than 150 Excel 2007 tasks. Each task-based spread includes easy, visual directions for performing necessary operations, including:
* Using the Ribbon and galleries
* Entering data and resizing columns
* Applying formulas and functions
* Formatting worksheets
* Adding clip art and 3D effects
* Interpreting data with charts
* Helpful sidebars offer practical tips and tricks
* Succinct explanations walk you through step by step
* Full-color screen shots demonstrate each task
* Two-page lessons break big topics into bite-sized modules
-
EXCEL 2003 STEP BY STEP
-
- Targets beginning to intermediate Excel users seeking real-world examples of how they can use Excel's powerful built-in functions
- Shows readers how to use Excel functions in formulas to help them decide between buying and leasing a car, calculate mortgage costs, compute grades, evaluate investment performance, figure college expenses, and more
- Gives explanations and examples of real-world situations
- Provides an abbreviated discussion of an additional 200 functions
- Excel commands nearly 90 percent of the market for spreadsheet applications; although this book is written for Excel 2003, the functions described are in earlier versions as well
-
Finally, there's a book that treats Excel as the powerful development platform it really is, and covers every facet of developing commercial-quality Excel applications. This is not a book for beginners. Writing for professional developers and true Excel experts, the authors share insider's knowledge they've acquired building Excel applications for many of the world's largest companies-including Microsoft. Professional Excel Development demonstrates how to get the utmost from Excel, addressing everything from application architectures through worksheet and userform design, charting, debugging, error handling and optimizing performance. Along the way, the authors offer best practices for every type of Excel development, from building add-ins through interacting with XML Web services. Coverage includes- Building add-ins to provide new Excel functions
- Designing effective worksheets, userforms and other user interface elements
- Leveraging Excel's powerful data analysis features
- Creating sophisticated custom charts
- Handling errors, debugging applications and optimizing performance
- Using class modules and interfaces to create custom objects
- Understanding Windows API calls: when to use them, and how to modify them
- Adding worksheet functions with C-based XLLs
- Programming with databases
- Controlling external applications from Excel
- Integrating with Visual Basic 6, VB.NET and Visual Studio Tools for Office
- Using XML to import and export data and communicate with Web services
- Providing help, securing, packaging and distributing
-
Principles of Finance with Excel is the first textbook that comprehensively integrates Excel into the teaching and practice of finance. This book provides exceptional resources to the instructor and student, combining classroom-tested pedagogy with the full potential of Excel's powerful functions.
In today's business world, computation is done almost wholly in Excel. Excel's ability to combine graphics with computation and perform complex sensitivity analysis with ease provides potent insights into financial problems. Despite this, most finance texts rely heavily on hand-held calculators and ignore Excel. As a result, many students find that after they enter the professional environment, they have to relearn both finance and Excel.
Principles of Finance with Excel is ideal for undergraduate courses in introductory finance or as a reference for finance professionals. A Free In-Text CD for students contains electronic versions of all spreadsheets in the book. A Companion Website -- http://www.oup.com/us/benninga -- contains lecture notes, PowerPoint Slides, and a Test Bank for instructors.
-
In Microsoft Excel 2007: Comprehensive Concepts and Techniques you’ll find features that are specifically designed to improve retention, and prepare readers for future success. Our trademark step-by-step, screen-by-screen approach now encourages readers to expand their understanding of the Access 2007 software through experimentation, exploration, and planning ahead.
-
Following the critical thinking, problem-solving approach of the New Perspectives Series learners will gain a comprehensive understanding of Microsoft Excel 2007, including the new features of the software. The case-based tutorials challenge learners to apply what they are learning to real-life tasks, preparing them to easily transfer skills to new situations. With the New Perspectives Series approach, learners understand why they’re learning what they’re learning, and are better situated to retain skills.