Books: 60

Excel

CoverTitleYear
In Beginning Big Data with Power BI and Excel 2013, you will learn to solve business problems by tapping the power of Microsoft’s Excel and Power BI to import data from NoSQL and SQL databases and other sources, create relational data models, and analyze business problems through sophisticated dashboards more » and data-driven maps. While Beginning Big Data with Power BI and Excel 2013covers prominent tools such as Hadoop and the NoSQL databases, it recognizes that most small and medium-sized businesses don’t have the Big Data processing needs of a Netflix, Target, or Facebook. Instead, it shows how to import data and use the self-service analytics available in Excel with Power BI. As you’ll see through the book’s numerous case examples, these tools—which you already know how to use—can perform many of the same functions as the higher-end Apache tools many people believe are required to carry out in Big Data projects. Through instruction, insight, advice, and case studies, Beginning Big Data with Power BI and Excel 2013 will show you how to: * Import and mash up data from web pages, SQL and NoSQL databases, the Azure Marketplace and other sources. * Tap into the analytical power of PivotTables and PivotCharts and develop relational data models to track trends and make predictions based on a wide range of data. * Understand basic statistics and use Excel with PowerBI to do sophisticated statistical analysis—including identifying trends and correlations. * Use SQL within Excel to do sophisticated queries across multiple tables, including NoSQL databases. * Create complex formulas to solve real-world business problems using Data Analysis Expressions (DAX). **** What you’ll learn **** You will learn to: * Use Excel and Power BI to do sophisticated data analytics on large data sets * Import data from other sources into Excel * Understand basic statistical techniques * Analyze trends * Perform complex calculation using DAX * Present results using easy-to-understand visualizations such as maps * Frame and solve real-world business problems through big data analysis **** Who this book is for **** Beginning Big Data with Power BI and Excel 2013is designed for anyone who uses data analytics to make business decisions, especially those in small and medium-sized businesses. « less
2015
Master VBA automation quickly and easily to get more out of Excel Excel VBA 24-Hour Trainer, 2nd Edition is the quick-start guide to getting more out of Excel, using Visual Basic for Applications. This unique book/video package has been updated with fifteen new advanced video lessons, providing a more » total of eleven hours of video training and 45 total lessons to teach you the basics and beyond. This self-paced tutorial explains Excel VBA from the ground up, demonstrating with each advancing lesson how you can increase your productivity. Clear, concise, step-by-step instructions are combined with illustrations, code examples, and downloadable workbooks to give you a practical, in-depth learning experience and results that apply to real-world scenarios. This is your comprehensive guide to becoming a true Excel power user, with multimedia instruction and plenty of hands-on practice. * Program Excel's newest chart and pivot table object models * Manipulate the user interface to customize the look and feel of a project * Utilize message boxes, input boxes, and loops to yield customized logical results * Interact with and manipulate Word, Access, PowerPoint, and Outlook from Excel If you're ready to get more out of this incredibly functional program, Excel VBA 24-Hour Trainer, 2nd Edition provides the expert instruction and fast, hands-on learning you need. « less
2015
Mr. Spreadsheet has done it again with 101 easy-to-apply Excel formulas 101 Ready-to-Use Excel Formulas is filled with the most commonly-used, real-world Excel formulas that can be repurposed and put into action, saving you time and increasing your productivity. Each segment of this book outlines more » a common business or analysis problem that needs to be solved and provides the actual Excel formulas to solve the problem—along with detailed explanation of how the formulas work. Written in a user-friendly style that relies on a tips and tricks approach, the book details how to perform everyday Excel tasks with confidence. 101 Ready-to-Use Excel Formulas is sure to become your well-thumbed reference to solve your workplace problems. The recipes in the book are structured to first present the problem, then provide the formula solution, and finally show how it works so that it can be customized to fit your needs. The companion website to the book allows readers to easily test the formulas and provides visual confirmation of the concepts presented. * Teaches you how to implement the required Excel formula * Explains and details how the formulas work * Lets you reuse or customize the given formula to address your particular needs * Helps you make the formulas a regular part of your new, more efficient workflow Specific real-world scenarios are used to demonstrate how to most effectively apply Excel and its powerful formulas to complete tasks faster and with greater accuracy than ever before. Now you can save time, automate, and be more efficient and productive with 101 Ready-to-Use Excel Formulas. « less
2014
The advanced tools accountants need to build automated, reliable, and scalable reports using Excel Learn about the functions that work together to automate many of the processes involved in Management Reporting. See how to take advantage of the many new features of Excel 2007 and 2010. Find out how more » to build validation structures into your spreadsheet reports. Discover how to identify missing or new codes, either in the creation process or in the day-to-day running of the reports. Do it all with Advanced Excel Reporting for Management Accountants. « less
2014
Maximize the power of Excel 2013 formulas with this must-have Excel reference. John Walkenbach, known as "Mr. Spreadsheet," is a master at deciphering complex technical topics and Excel formulas are no exception. This fully updated book delivers more than 800 pages of Excel 2013 tips, tricks, and more » techniques for creating formulas that calculate, developing custom worksheet functions with VBA, debugging formulas, and much more. * Demonstrates how to use all the latest features in Excel 2013 * Shows how to create financial formulas and tap into the power of array formulas * Serves as a guide to using various lookup formulas, working with conditional formatting, and developing custom functions * Shares proven solutions for handling typical (and not-so-typical) Excel formula challenges * Includes links to the "Mr. Spreadsheet" website, which contains all the templates and worksheets used in the book, plus access to John Walkenbach's award-winning Power Utility Pak. From charts to PivotTables and everything in between, Excel 2013 Formulas is your formula for Excel success. « less
2013
Building Models for Technology Startups
Learn the business thinking behind financial modeling and execute what you know effectively using Microsoft Excel. Many believe that sales and profitability projections shown in financial models are the keys to success in attracting investors. The truth is that investors will come up with their own projections. more » The investor wants to understand the assumptions, structure, and relationships within the modeling of a startup. If the investor is satiated, the entrepreneur has successfully demonstrated a complete understanding of the business side of the enterprise. « less
2009
* 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 more » 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. « less
2007
This book is aimed squarely at Excel users who want to harness the power of the VBA language in their Excel applications. At all times, the VBA language is presented in the context of Excel, not just as a general application programming language. The book is loosely divided into three sections: * more » Primer (Chapter 1) * Working with Specific Objects (Chapters 2-27) * Object Model References (Appendices A-C) The Primer has been written for those who are new to VBA programming and the Excel object model. It introduces the VBA language and the features of the language that are common to all VBA applications. It explains the relationship between collections, objects, properties, methods, and events and shows how to relate these concepts to Excel through its object model. It also shows how to use the Visual Basic Editor and its multitude of tools, including how to obtain help. The middle section of the book takes the key objects in Excel and shows, through many practical examples, how to go about working with those objects. The techniques presented have been developed through the exchange of ideas of many talented Excel VBA programmers over many years and show the best way to gain access to workbooks, worksheets, charts, ranges, and so on. The emphasis is on efficiency--that is, how to write code that is readable and easy to maintain and that runs at maximum speed. In addition, the chapters devoted to accessing external databases detail techniques for accessing data in a range of formats. The final four chapters of the book address the following advanced issues: linking Excel to the Internet, writing code for international compatibility, programming the Visual Basic Editor, and how to use the functions in the Win32 API (Windows 32-bit Application Programming Interface). Finally, the appendices are a comprehensive reference to the Excel 2007 object model, as well as the Visual Basic Editor and Office object models. All the objects in the models are presented together with all their properties, methods, and events. « less
2007
You’re a sophisticated user of Excel—a real pro with spreadsheets—so now dig into its powerful programming capabilities and really put your data to work! From writing code in Microsoft Visual Basic for Applications (VBA) to taking advantage of new XML data-sharing features, this book packs hundreds of more » timesaving programming solutions, troubleshooting tips, and handy workarounds all in concise, fast-answer format. Discover the best and fastest ways to build custom business solutions with Excel—and challenge yourself to new levels of mastery! * From automating simple tasks to building custom solutions, write better code with VBA * Learn best practices for writing and debugging your own macros * Use VBA code to manage dates and times, reformat worksheets, and locate external files * Extend your Excel solutions by developing your own add-ins * Get powerful perspectives on data by programmatically manipulating PivotTable and PivotChart dynamic views * Create custom command bars, dialog boxes, and user forms * Employ ActiveX Data Objects (ADO) to access external databases * Exploit the new XML capabilities in Excel 2003 CD features: * Complete eBook in PDF format * Insider Extras—including all the authors’ sample files and code * Catalog of Excel resources with links to third-party tools and demos * Microsoft resources and demos, including Insider’s Guide to Microsoft Office OneNote 2003 eBook * FREE! Microsoft Computer Dictionary, Fifth Edition, eBook—10,000+ entries A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com. « less
2004
Hey, you know your way around a spreadsheet—so now dig into Excel 2003 and really put your data to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and handy workarounds in concise, fast-answer format. It’s all muscle and no fluff. Discover the best more » and fastest ways to perform everyday tasks, and challenge yourself to new levels of Excel mastery! * Build on what you already know about Excel and quickly dive into what’s new * Learn how the experts design more powerful spreadsheets * Sharpen your core to advanced document editing and formatting skills * Perform calculations, analyze data, and build PivotTable reports * Drill into new Excel functions for statistical analysis * Create high-impact charts, including bubble, radar, and Gantt charts * Link and embed Excel data in other Microsoft Office programs * Capture, reuse, and share data by exploiting XML features * Use macros and Microsoft Visual Basic for Applications to automate Excel CD features: * Complete eBook * Insider Extras—including 30-day trial edition of Spreadsheet Assistant add-in. * Catalog of select Excel resources with links to third-party tools and demos * Microsoft add-ins, demos, and trials, including Insider’s Guide to Microsoft Office OneNote eBook * Microsoft Computer Dictionary, Fifth Edition, eBook—10,000+ entries A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com. « less
2003