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…
Your guide to quickly turn data into results. Transform your skills, data, and business--and create your own BI solutions using software you already know and love: Microsoft Excel. Two business intelligence (BI) experts take you inside PowerPivot fu…
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…
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 mor…
Master the business modeling and analysis techniques that help you transform data into bottom-line results. For more than a decade, Wayne Winston has been teaching corporate clients and MBA students the most effective ways to use Excel to solve busi…
A comprehensive reference to the newest version of the world's most popular spreadsheet application: Excel 2010 John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet,…
All the methods and tools you need to successfully program with Excel John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. With this comprehensive guide, "Mr.
This book introduces PowerPivot in Excel 2010 to power users and data analysts who want to give their data meaning by creating their own Business Intelligence models. This is a book for advanced users of Excel, and not for programmers-- PowerPivot,…
Take control of your small business communication and increase your productivity--with Microsoft Office 365 cloud services. Through extensive walkthroughs, easy-to-follow procedures, and real-world tips, you'll learn how to implement Office 365 for…
Take control of your spreadsheets and use VBA to create your own custom Excel applicationsAuthor and Excel guru John Walkenbach, known to his devoted fans as "Mr. Spreadsheet," guides you through taking your Excel skills to the next level by creatin…
Take 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…
ANALYZE HUGE AMOUNTS OF BUSINESS DATA FASTER, MORE EASILY, AND MORE ACCURATELY! Use Microsoft's free PowerPivot add-in for Excel 2010 to analyze immense amounts of data from any source, perform state-of-the-art business analysis far more easily, and…
In this book, the authors build on RExcel, a free add-in for Excel that can be downloaded from the R distribution network. RExcel seamlessly integrates the entire set of R's statistical and graphical methods into Excel, allowing students to focus on…
Save time and be more productive with this helpful guide to Excel macros While most books about Excel macros offer only minor examples, usually aimed at illustrating a particular topic, this invaluable resource provides you with the tools needed to…
Develop custom Excel VBA macros Perfect for power users, this practical resource reveals how to maximize the features and functionality of Excel 2007. You'll get in-depth details on Excel VBA programming and application development followed by 21 re…
Updating the previous edition's tips to make them compatible with Excel 2010, and featuring tips that are only available in Excel 2010, this new edition of Mr. Excel's popular software guide even incorporates suggestions sent in by readers. Each fea…
Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before, and this book is the first to tackle DAX formulas, the core capability of PowerPivot, fr…
Conquer Microsoft(R) Excel(R) formulas and functions--from the inside out You're beyond the basics, so dive right in and really put Excel formulas and functions to work This supremely organized reference packs hundreds of timesaving solutions, troub…
A reference useful for Excel beginners, intermediate users, power users, and would-be power users everywhere, this book provides Excel tips, tricks, and techniques. It covers the Excel interface, file formats, interactivity with other Office applica…
PivotTables may be Excel's most powerful feature, but Microsoft has estimated that only 15% of Excel users take advantage of them. That's because PivotTables (and their companion feature, PivotCharts) have a reputation for being difficult to learn.…
The comprehensive reference, now completely up-to-date for Excel 2013 As the standard for spreadsheet applications, Excel is used worldwide - but it's not always user-friendly. However, in the hands of veteran bestselling author Greg Harvey, Excel g…
Quickly teach yourself how to automate tasks and create custom spreadsheet solutions with Excel 2007 Visual Basic for Applications (VBA). With Step By Step, you set the pace--building and practicing the skills you need, just when you need them Creat…
Microsoft Excel is an incredible application, feature-rich and easy to use if you know how. It can help with the simplest of jobs, from shopping lists to presentation of data, to more complex formulas and sorting tasks. Everyone in business, or inde…
For introductory courses in Engineering and Computing Based on'Excel 2010, Engineering with Excel, 4e takes a comprehensive look at using Excel in engineering.' This book focuses on applications and is intended to serve as both a textbook and a refe…
“As Excel applications become more complex and the Windows development platform more powerful, Excel developers need books like this to help them evolve their solutions to the next level of sophistication. Professional Excel Development is a b…
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 purc…
The go to resource for how to use Excel dashboards and reports to better conceptualize data Many 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…
Fast answers to frequently asked questions Excel 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…
Step-by-step instructions for creating VBA macros Harness the power of VBA and create custom Excel applications Make Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way…
What's the use of putting out reports that no one reads? Properly created dashboards are graphical representations that put data in a context for your audience, and they look really cool! How cool? You'll find out when you see the dazzling examples…
Helps you create colorful spreadsheets and charts, use Live Preview, and maximize what Excel 2007 has to offer. This work shows you what you need to know about using the new Ribbon, designing spreadsheets that communicate, editing and printing them,…
Mastering Data Analysis and Mining with SQL and Excel shows business managers and data analysts how to use the relatively simple tools of SQL and Excel to extract useful business information from relational databases. The book is organized around ch…
Take your Excel formulas to the next level with this updated reference John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr.
* 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 boo…
Written specifically for finance managers, Excel for the CFO explains the best features of Excel that allow for the automation of regular processes and help reduce the processing time spent on analytics. The book explores the entire gamut of finance…
Comprehensive tools and methods to help you build, develop and apply financial models using Microsoft Excel, enabling you to get better, more accurate results, faster. The new edition of this bestselling title begins by explaining basic modelling te…
Beginning PivotTables in Excel 2007 explains what PivotTables are, how you can benefit from using them, how to create them and modify them, and how to use their enhanced features. Using a Pivot Table in Microsoft Office Excel 2007 is a quick and ex…
The "Advantage" series presents the Feature-Method-Practice approach to computer software applications to today's technology and business students. This series implements an efficient and effective learning model, which enhances critical thinking sk…
Now in its fourth edition, this highly regarded book is ideal for those who wish to solve a variety of practical and recreational problems in astronomy using a scientific calculator or spreadsheet. Updated and extended, this new edition shows you ho…
Furnishing a variety of practical, real-world scenarios to demonstrate the applications of Pivot Tables, a comprehensive review of their function in Excel 2007 offers a series of proven, innovative Pivot Table recipes that can be applied to a variet…
For 2-year and 4-year undergraduates enrolled in a computerized accounting course. Horne teaches accounting concepts and their relationship to Quickbooks Pro 2008 so students can transition from textbook to "real world" transaction analysis.
If Excel 2002 can do it, you can do it too... All you need is the expert advice of leading Excel authority , "Mr. Spreadsheet", and .Whenever you get stuck or want to use a new tool or feature - whether it´s using the new Smart Tags feature, setting…
For use in the Office Applications course. This book is also suitable for students and individuals seeking an introduction to Microsoft Excel 2013. The primary goal of the GO! Series, aside from teaching computer applications, is ease of implementat…
Find out how to set up your project for success as you examine an overview of the project management practices followed by Microsoft Project. Put these principles into practice as you create, track, and report on example projects. You'll learn how t…
"If you've never quite grasped formulas and functions, Paul McFedries will radically expand your understanding and use of Excel. And if you're already an expert and you're moving up to Excel 2007, this book will quickly show you features you've only…
How to Do Everything with Excel 2007 teaches the reader how to master the latest version of Microsoft's market-dominating spreadsheet application Excel 2007 builds on previous versions of Excel by introducing a new interface featuring the Ribbon, a…
Introduce students to the power of spreadsheets. This workbook contains 51 spreadsheet problems that reinforce principles of accounting concepts. The problems incorporate formula development and model building skills that may be used in a variety of…