The Leading eBooks Store Online
for your Apple or Android device, Nook, Kobo, PC, Mac, Sony Reader...
Most popular at the top
VLOOKUP Awesome Quickby Bill Jelen
Holy Macro! Books 2012; US$ 9.99VLOOKUP is a function in Excel that enables people to use Excel like a database, joining data on different worksheets. VLOOKUP Awesome Quick is an ehnanced eBook designed to get the reader up to speed with the VLOOKUP function in Excel. The book starts with the basics of "Explain a VLOOKUP in plain English", "How to Enter Your First VLOOKUP", how to troubleshoot VLOOKUP when you get all #N/A or a few #N/A errors. Steps to make VLOOKUP easier. Real-life applicatons of VLOOKUP. The book moves on to advanced topics like moving beyond VLOOKUP to using INDEX and MATCH, Two-way VLOOKUP, Finding the last match, finding the last item in a column, and more. The book includes 7 videos and 5 audio clips. more...
Statistical Analysis with Excel For Dummiesby Joseph Schmuller
John Wiley & Sons, Inc. 2009; US$ 29.99You too can understand the statistics of life, even if you're math-challenged! What do you need to calculate? Manufacturing output? A curve for test scores? Sports stats? You and Excel can do it, and this non-intimidating guide shows you how. It demystifies the different types of statistics, how Excel functions and formulas work, the meaning of means and medians, how to interpret your figures, and more in plain English. Getting there learn how variables, samples, and probability are used to get the information you want Excel tricks find out what's built into the program to help you work with Excel formulas Playing with worksheets get acquainted with the worksheet functions for each step Graphic displays... more...
Balanced Scorecards and Operational Dashboards with Microsoft Excelby Ron Person
John Wiley & Sons, Inc. 2010; US$ 49.99Created 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. more...
Excel VBA Programming For Dummiesby John Walkenbach
John Wiley & Sons, Inc. 2011; US$ 24.99Having 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... more...
Learn Excel from Mr. Excelby Bill Jelen
Holy Macro! Books 2005; US$ 12.95Containing 277 business case studies that illustrate nearly every aspect of Excel, this book presents real-life business problems and works them through to their solutions. In addition to exemplary solutions, each case analysis considers alternate approaches and gotchas, and includes a summary of the necessary commands and functions. Excel files that can be downloaded and worked through step-by-step are included for each case. more...
Excel Basics to Blackbeltby Elliot Bendoly
Cambridge University Press 2008; US$ 40.00Excel Basics to Blackbelt is intended to serve as an accelerated guide to decision support designs. more...
Excel 2007 Macros Made Easyby Gail Perry
McGraw-Hill 2008; US$ 21.99Get beyond the basics with Excel 2007 macros Here is the perfect solution for the spreadsheet user who wants to learn powerful shortcuts and time-saving methods for expediting and remembering tasks. This inexpensive guide explains how to use Excel macros to simplify repetitive tasks, store the instructions for complicated tasks, and make standard commands available to other users. You will create your first macro in just one minute and learn to produce interactive macros that ask the user for input and add macros to the Excel toolbar. more...
Excel 2007 Pocket Guideby Curtis Frye
O'Reilly Media, Inc. 2009; US$ 7.99Moving to Excel 2007 is not a routine upgrade. Microsoft's radical redesign of the application's user interface has led to confusion among many who people who have relied on Excel for years. Our new edition of the Excel 2007 Pocket Guide has been written from the ground up to help newcomers and longtime users alike find their way around without getting lost. With this book in hand, you'll be able to find your favorite Excel tools quickly. It's packed with information to guide beginners through the basics of creating spreadsheets and entering data, while providing advanced users with information on formulas, pivot tables, and more. Inside, you'll find: A visual guide to the new "Ribbon" interface that helps users find familiar tools... more...
Excel Formulas and Functions For Dummiesby Ken Bluttman; Peter G. Aitken
John Wiley & Sons, Inc. 2010; US$ 24.99Put 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... more...
Excel VBA Programming For Dummiesby John Walkenbach
John Wiley & Sons, Inc. 2010; US$ 29.99Take your Excel skills to the next level with VBA programming Now 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... more...