- Environment
- Fiction
- Seville
- Baedeker
- Oxford School Shakespeare Series
- Transportation
- Block, Lawrence
- Large Print
- Parapsychology
- Art
- Davidson, Diane Mott
- Leblanc, Maurice
- Needlecrafts
- General
- Kay, Guy Gavriel
- Iowa
- Piloting & Flight Instruction
- von Ziegesar, Cecily
- McKeone, Dixie
- Rabe, Sheila
- Shreve, Anita
- Intellectual Life
- Harjo, Joy
- Albee, Edward
- Graphic Design
- Watches
- Home and Garden
- UK Electronics
- UK Books
- Health and Personal Care
- UK Sporting Goods
- Clothing, Shoes and Accessories
- Electronics, Gadgets and Computers
- CDs and Music Downloads
- UK Software and Video Games
- UK Toys and Games
- UK Home and Garden
- UK Video Games
- UK Baby Clothes and Accessories
- Books On
- German Electronics
Books : Computers & Internet : Software : Spreadsheets : General
-
The only official guide to the #1 bestselling financial software
Packed with insider tips and expert advice, QuickBooks 2012: The Official Guide shows you how to set up a comprehensive, well-organized small business financial management system with ease! Find out the most effective methods for accomplishing essential business tasks and customizing QuickBooks for your needs.
Fully endorsed by Intuit, makers of QuickBooks, this official guide provides best practices for tracking finances, managing payroll, processing invoices, controlling inventory, managing sales and expenses, and maximizing the software's features. Run an efficient and successful small business using the proven techniques and time-saving shortcuts inside this authoritative guide to QuickBooks 2012.
- Configure and customize QuickBooks for your business
- Avoid common mistakes
- Enter transactions quickly and accurately
- Manage accounts payable and receivable
- Set up and manage inventory
- Track employee hours and manage payroll
- Use Online Banking
- Reconcile bank accounts
- Set up and manage budgets
- Create standard and customized business reports
- Make key business decisions with confidence
Leslie Capachietti, MBA, is a nationally recognized speaker and trainer for Intuit and the Principal of Automated Financial Solutions, an accounting sy
-
A comprehensive reference to the newest version of the world’s most popular spreadsheet application: Excel 2010John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach shows you how to maximize the power of all the new features of Excel 2010.
An authoritative reference, this perennial bestseller proves itself indispensable no matter your level of skill, from Excel beginners and intermediate users to power users and potential 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 you won’t find anywhere else.
- Excel guru and bestselling author John Walkenbach ("Mr. Spreadsheet") guides you through every aspect of Excel
- Delivers essential coverage of all the newest features of Excel 2010
- Presents material in a clear, concise, logical format that is ideal for all levels of Excel experience
- Includes a CD that contains all the templates and worksheets used in the book plus John Walkenbach's award-winning Power Utility Pak
Excel 2010 Bible serves as an excellent resource on all things Excel!
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
-
All the methods and tools you need to successfully program with ExcelJohn Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf.
Featuring a complete introduction to Visual Basic for Applications and fully updated for the new features of Excel 2010, this essential reference includes an analysis of Excel application development and is packed with procedures, tips, and ideas for expanding Excel’s capabilities with VBA.
- Offers an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA)
- Features invaluable advice from "Mr. Spreadsheet" himself (bestselling author John Walkenbach), who demonstrates all the techniques you need to create large and small Excel applications
- Provides tips, tricks, and techniques for expanding Excel's capabilities with VBA that you won’t find anywhere else
- Includes a CD with templates and worksheets from the book
This power-user's guide is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA.
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
-
A comprehensive, up-to-date, user-friendly guide to Excel 2010Excel is the standard for spreadsheet applications and is used worldwide, but it's not always user-friendly. That makes it a perfect For Dummies topic, and this handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more.
Eight minibooks address Excel basics, worksheet design, formulas and functions, worksheet collaboration and review, charts and graphics, data management, data analysis, and Excel and VBA.
- Excel is the leading spreadsheet/data analysis software and is used throughout the world; the newest revision includes upgraded tools and a redesigned interface
- For Dummies books are the bestselling guides to Excel, with more than three million copies sold
- Excel 2010 All-in-One For Dummies covers the changes in the newest version as well as familiar tasks, such as creating and editing worksheets, setting up formulas, and performing statistical functions
- Eight self-contained minibooks cover the basics, worksheet design, formulas and functions, worksheet collaboration, presenting data in charts and graphics, data management, data analysis, and creating macros with VBA.
Newcomers to Excel as well as veterans who just want to learn the latest version will find Excel 2010 All-in-One For Dummies has everything they need to know.
-
Take your Excel skills to the next level with VBA programmingNow that you've mastered Excel basics, it's time to move to the next level—creating your own, customized Excel 2010 solutions using Visual Basic for Applications (VBA). The new edition of this non-threatening guide is your key to getting there. Using step-by-step instruction and the accessible, friendly For Dummies style, this practical book shows you how to use VBA, write macros, customize your Excel apps to look and work the way you want, avoid errors, and more.
The book's Web site provides all the programming examples from the book.
- Introduces you to a new range of Excel 2010 options
- Shows you how to use Visual Basic for Applications (VBA) to program your own custom Excel applications or to automate functions
- Explains how to create VBA macros, program, handle errors, debug, and more
- Covers Visual Basic Editor tools and functions; working with range objects; controlling program flow; and the easiest ways to create custom dialog boxes, toolbars, and menus
- Includes a companion Web site with all the sample programs from the book
Create your own, custom Excel programs with this information-packed guide!
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
-
Excel, the world's most popular spreadsheet program, has the muscle to analyze heaps of data. Beyond basic number-crunching, Excel 2010 has many impressive features that are hard to find, much less master -- especially from online help pages. This Missing Manual clearly explains how everything works with a unique and witty style to help you learn quickly.
- Navigate with ease. Master Excel's tabbed toolbar and its new backstage view
- Perform a variety of calculations. Write formulas for rounding numbers, calculating mortgage payments, and more
- Organize your data. Search, sort, and filter huge amounts of information
- Illustrate trends. Bring your data to life with charts and graphics -- including miniature charts called Sparklines
- Examine your data. Summarize information and find hidden patterns with pivot tables and slicers
- Share your spreadsheets. Use the Excel Web App to collaborate with colleagues online
- Rescue lost data. Restore old versions of data and find spreadsheets you forgot to save
Microsoft Excel’s Top 5 Tricks
1. Page break preview -- In page break preview mode (choose View --> Workbook Views --> Page Break Preview) you can see how your printed worksheet will be split across multiple pages. But even more valuable is the ability to drag a page break to a new place. For example, if you spot some data off to the right side that doesn't fit on your page, you can drag the page break to the right so that it does. When you do this, Excel scales down your entire worksheet to fit the information you want.
2. Recovering unsaved work -- Ever start a new workbook, and then forget to save it when you close Excel in a hurry? Now you can get your lost work back. Just choose File --> Info, click the Manage Versions button, and choose Recover Unsaved Workbooks to find the unsaved spreadsheets that Excel stores automatically.
3. Lookup formulas -- If you understand how to use them, lookup formulas give you a powerful way to copy information from one part of a spreadsheet to another. For example, you can use lookup formulas to create an invoice that automatically inserts the correct product and price information when you type in a product code. Ordinarily, you'd expect this sort of solution to need macros or Visual Basic, but it doesn't.
4. Formula tracing -- Sometimes formulas go wrong, and the result is information that doesn't make sense (or an error code). Excel's formula tracing feature is a big help if this happens in a complex spreadsheet. When you use it, Excel adds arrows that point from the source cells to the formula that uses these cells. Essentially, formula tracing gives you a way to graphically "see" how your formula connects to the rest of your data, and it often helps you find the troublemaking cell that's causing the problem.
5. Charting tricks -- Charts tell a story with your data, and there are plenty of tricks that you can use to make them present that story more clearly and conclusively. For example: changing a chart's scale, adding an overlay, changing the fill of a specific series, inserting text and graphics directly on the chart surface, and so on, all have a dramatic effect. They make the difference between a chart that conveys a useful insight, and one that's just a bit of spreadsheet decoration.
-
The bestselling Excel book on the market, updated for Excel 2010As 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.
- Excel is the number one spreadsheet application worldwide, and Excel For Dummies is the number one guide to using it
- With the major changes in Microsoft Office 2010, Excel has new features and a new interface design; users need help to get up to speed
- The book includes everything you need to know to perform basic Excel 2010 tasks
- Covers creating and editing worksheets and charts, formatting cells, entering formulas, inserting graphs, designing database forms, and adding database records
- Also covers printing, adding hyperlinks to worksheets, saving worksheets as Web pages, adding existing worksheet data to an existing Web page, and much more
Whether you're new to Excel or just need to understand the 2010 version, Excel 2010 For Dummies provides what you need to know.
-
This book is very, very different to any other computer book you have ever read. The Smart Method provides an entirely new and better way to learn Excel. Here are just five of the many ways in which this book is unique:
- The book will equip you with excellent Excel skills, good enough to impress any employer, but it doesn’t confuse by attempting to teach skills that are not common in the workplace. Only users who have advanced requirements need progress to the Expert Skills book.
- This is the only book that is also available as a low-cost video (DVD). Each can be used as a stand-alone product, but together they provide an incredibly powerful learning experience.
- Instruction is logically structured into sessions and lessons. While this makes the book ideal for self-instruction, you can also use it to run your own, highly effective, adult training courses.
- Every lesson is presented on two facing sheets of A4 paper (the pages are much bigger than in any other Excel book).
- Each lesson has a sample file that models a real-world business problem. You’ll immediately appreciate the value and relevance of each skill as it is taught.
Both IT professionals and absolute beginners will love this book because it avoids needless technical jargon and concisely explains everything you need in a simple and no-nonsense way.
-
This book is for users who want to upgrade their basic Excel skills to true expert level. It will teach you to master all of Excel’s advanced features. If you are an absolute beginner you need our Essential Skills book.
The book is very, very different to any other computer book you have ever read. The Smart Method provides an entirely new and better way to master advanced Excel features. Here’s just four of the many ways in which the book is unique:
- This book won’t waste your time by teaching basic Excel skills that you already know. All of that material is covered already in our beginner’s Essential Skills book. By assuming that you are already able to use Excel’s basic features, far more ground can be covered.
- Instruction is logically structured into sessions and lessons. While this makes the book ideal for self-instruction, you can also use it to run your own, highly effective, adult training courses.
- Every lesson is presented on two facing sheets of A4 paper (the pages are much bigger than in any other Excel book).
- Each lesson has a sample file that models a real-world business problem. You’ll immediately appreciate the value and relevance of each skill you learn.
Advanced concepts are explained without needless technical jargon. Everything is concisely described in a simple, no-nonsense way. No matter what your background is, this book will enable you to master Excel's most advanced features.
-
One look at Excel 2007, with its new Office Button, Quick Access toolbar, and Ribbon, and you realize you’re not in Kansas anymore. Well, have no fear— Excel 2007 for Dummies is here!If you’ve never worked with a computer spreadsheet, or if you’ve had some experience with earlier versions of Excel but need help transitioning, here you’ll find everything you need to create, edit, format, and print your own worksheets (without sacrificing your sanity!). Excel 2007 for Dummies covers all the fundamental techniques, concentrating on only the easiest, most user-friendly ways to get things done.
You’ll discover how to:
- Rearrange, delete and insert new information
- Keep track of and organize data in a single worksheet
- Transfer data between the sheets of different workbooks
- Create a chart using the data in a worksheet
- Add hyperlinks and graphics to worksheets
- And more!
Plus, in keeping with Excel 2007’s more graphical and colorful look, Excel 2007 for Dummies has taken on some color of its own, with full-color plates in the mid-section of the book illustrating exactly what you’ll see on your screen. Whether you read it from cover to cover or skip to the sections that answer your specific questions, the simple guidance in this book will have you excelling at home or in the office no time.
-
Master the Ribbon, powerful graphics capabilities, and more!Your one-stop guide to great-looking spreadsheets that actually mean something
Create 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
-
Experience learning made easy-and quickly teach yourself how to organize, analyze, and present data with Excel 2010. With STEP BY STEP, you set the pace-building and practicing the skills you need, just when you need them! Topics include creating formulas, calculating values, and analyzing data; presenting information visually with graphics, charts, and diagrams; building PivotTable dynamic views; using the new Excel Web App; reusing information from databases and other documents; creating macros to automate repetitive tasks and simplify your work; and other core topics.
From Inside the Book: Using Pivot Tables
-
Demonstrate your expertise with Microsoft Office 2010! This all-in-one guide is designed to help you practice and prepare for the four core Microsoft Office Specialist (MOS) exams.
With the MOS 2010 Study Guide, you get full, objective-by-objective coverage for:
- Exam 77-881: Microsoft Word 2010
- Exam 77-882: Microsoft Excel 2010
- Exam 77-883: Microsoft PowerPoint 2010
- Exam 77-884: Microsoft Outlook 2010
Use the book’s easy-to-follow procedures and illustrations to review the essential skills measured by the MOS exams. And you can apply what you’ve learned hands-on—using the downloadable files for all the book’s practice tasks.
-
This Excel 2010 book is very, very different to any other computer book you have ever read. The Smart Method provides an entirely new and better way to learn Excel 2010. Here are just five of the many ways in which this book is unique:
- The book will equip you with excellent Excel 2010 skills, good enough to impress any employer, but it doesn’t confuse by attempting to teach skills that are not common in the workplace. Only users who have advanced requirements need progress to the Expert Skills book.
- This is the only book that is also available as a low-cost video (DVD). Each can be used as a stand-alone product, but together they provide an incredibly powerful learning experience.
- Instruction is logically structured into sessions and lessons. While this makes the book ideal for self-instruction, you can also use it to run your own, highly effective, adult training courses.
- Every lesson is presented on two facing sheets of A4 paper (the pages are much bigger than in any other Excel book).
- Each lesson has a sample file that models a real-world business problem.
You’ll immediately appreciate the value and relevance of each skill as it is taught. Both IT professionals and absolute beginners will love this book because it avoids needless technical jargon and concisely explains everything you need in a simple and no-nonsense way.
From the Back Cover
Amongst other things you'll learn how to:
- Master Excel 2010’s Fluent User Interface and Ribbon
- Understand the Excel 2010 file formats and when to use them
- Create your own formulas with the Formula AutoComplete feature
- Use the new Excel 2010 Versions feature to recover lost data
- Create stunning, professional, presentation-quality charts
- Use the Themes feature to create visually excellent worksheets
- Use the new Excel 2010 Sparklines to visually represent large data sets
- Bring your data alive with Excel 2010’s stunning Visualizations
- Create custom conditional formatting rules with the new Rules Manager
- Add a professional sheen to your work with 3-D Elements
- Understand and work with three-dimensional worksheet groups
Companies who have taken Smart Method courses include:
AOL Time Warner, The United States Army, Daimler Chrysler, Motorola, HSBC, Barclays, American Express, Allied Irish Banks, Imperial Tobacco, Volvo, The BBC, British Petroleum, The Foreign and Commonwealth Office, Unilever, The Institute of Chartered Accountants, The Ministry of Defence, Keele University, Deutsche Bank, HBOS, Transport For London, The Performing Rights Society, Scottish Power, The Office of the Parliamentary Ombudsman, BAE Systems, RBS, Marks & Spencer, Virgin, O2, BMW... and many, many others.
-
With the New Perspectives' critical-thinking, problem-solving approach, students will gain a comprehensive understanding of MICROSOFT OFFICE EXCEL 2010 and will learn how to take advantage of the flexibility it offers. Case-based tutorials challenge students to apply what they are learning to real-life tasks, preparing them to easily transfer skills to new situations. With New Perspectives, students understand why they're learning what they're learning and are better situated to retain skills beyond the classroom.
-
Put the power of Excel formulas and functions to work for you!Excel is a complex program. Mastering the use of formulas and functions lets you use Excel to compute useful day-to-day information, such as calculating the true cost of credit card purchases or comparing 15-year and 30-year mortgage costs. This fun and friendly book demystifies Excel's built-in functions so you can put them to work.
You'll find step-by-step instructions on 150 of Excel's most useful functions, how they work within formulas, and how to use them to make your life easier.
- See how to use 150 of Excel's most useful functions, with real-world examples showing how each function is used within a formula
- Learn to calculate the costs of leasing versus buying a car, compute classroom grades, create an amortization table, or evaluate investment performance
- Fully updated for Excel 2010, but the principles will work with earlier versions of Excel as well
- Includes essential coverage of an additional 85 functions
In the ever-popular, non-threatening For Dummies style, Excel Formulas and Functions For Dummies, 2nd Edition makes Excel's power accessible to you.
-
Take your Excel formulas to the next level with this updated referenceJohn Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach provides you with clear explanations on all the methods you can use to maximize the power of Excel with formulas within the frameworks of all the new features of Excel 2010.
You'll learn how to create financial formulas, maximize the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more. This invaluable reference is fully updated for the new Microsoft Office release and provides comprehensive formulas coverage, delivering more than 800 pages of Excel tips, tricks, and techniques you won't find anywhere else.
- Demonstrates how to use all the new features of Excel 2010 to maximize your formulas
- Shows how to develop custom worksheet functions with VBA, debug formulas, create financial formulas, and more
- Serves as an indispensable reference no matter your skill level
- Includes a valuable CD-ROM with sample files, templates and worksheets from the book, plus John Walkenbach's award-winning Power Utility Pak
Prepare to excel with Excel when you have John Walkenbach and Excel 2010 Formulas by your side!
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
-
The go to resource for how to use Excel dashboards and reports to better conceptualize dataMany Excel books do an adequate job of discussing the individual functions and tools that can be used to create an “Excel Report.” What they don’t offer is the most effective ways to present and report data. Offering a comprehensive review of a wide array of technical and analytical concepts, Excel Reports and Dashboards helps Excel users go from reporting data with simple tables full of dull numbers, to presenting key information through the use of high-impact, meaningful reports and dashboards that will wow management both visually and substantively.
- Details how to analyze large amounts of data and report the results in a meaningful, eye-catching visualization
- Describes how to use different perspectives to achieve better visibility into data, as well as how to slice data into various views on the fly
- Shows how to automate redundant reporting and analyses
Part technical manual, part analytical guidebook, Excel Dashboards and Reports is the latest addition to the Mr. Spreadsheet’s Bookshelf series and is the leading resource for learning to create dashboard reports in an easy-to-use format that’s both visually attractive and effective.
-
Created in Excel, balanced scorecards enable you to monitor operations and tactics, while operational dashboards is a set of indicators regarding the state of a business metric or process—both features are in high demand for many large organizations. This book serves as the first guide to focus on combining the benefits of balanced scorecards, operational dashboards, performance managements, and data visualization and then implement them in Microsoft Excel.
-
- 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.