Russell's ebook Library
Balanced Scorecards and Operational Dashboards With Microsoft Excel
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.
Beginning SharePoint With Excel
Gini Courter and Annette Marquis
Beginning SharePoint with Excel is for advanced Excel users who want to extend the usefulness of Excel by adding the collaborative features of SharePoint. There's no code in this book because it's not for programmers; nor is it for Excel beginners. It's for those of you who regularly use Excel in enterprise business environments and who want to leverage the power and capabilities of SharePoint. Authors Gini Courter and Annette Marquis have authored over 22 books on Microsoft Office and are partners in a business application consulting firm. In this book, they provide easy-to-implement examples of powerful business solutions. And they take care to explore the interaction between Excel and SharePoint. They also include resources and add-ons that extend SharePoint and Excel features.
Guerilla Data Analysis Using Excel
This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These are tips honed by Bill Jelen, “MrExcel,” during his 10-year run as a financial analyst charged with taking mainframe data and turning it into useful information quickly. Topics include perfectly sorting with one click every time, matching lists of data, data consolidation, data subtotals, pivot tables, and much more.
Mastering VBA for Microsoft Office 2016
Enhance productivity in any Office application with zero programming experienceMastering VBA for Microsoft Office 2016 helps you extend the capabilities of the entire Office suite using Visual Basic for Applications (VBA). Even if you have no programming experience , you'll be automating routine computing processes quickly using the simple, yet powerful VBA programming language. Clear, systematic tutorials walk beginners through the basics, while intermediate and advanced content guides more experienced users toward efficient solutions. This comprehensive guide starts at the beginning to get you acquainted with VBA so you can start recording macros right away. You'll then build upon that foundation to utilize the full capabilities of the language as you use loops and functions, message boxes, input boxes, and dialog boxes to design your own Office automation program. Add-ins, embedded macros, content controls, and more give you advanced tools to enhance productivity, and all instruction is backed by real-world practice projects in Word, Excel, Outlook, and PowerPoint. Productivity is the name of the game, and automating certain computing tasks is an easy solution with significant impact for any business. This book shows you how, with step-by-step guidance and expert insight. Expand Office 2016 functionality with macrosLearn how to work with VBA and the entire Office suiteCreate effective code, even with no programing experienceUnderstand ActiveX, XML-based files, the developer tab, and moreVBA is designed to be understandable and accessible to beginners, but powerful enough to create specialized business applications. If you're ready to begin exploring the possibilities, Mastering VBA for Microsoft Office 2016 gets you started right away.
Microsoft Excel Dashboards and Reports
Michael Alexander and John Walkenbach
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 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 visualizationDescribes how to use different perspectives to achieve better visibility into data, as well as how to slice data into various views on the flyShows how to automate redundant reporting and analysesPart 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.
Office VBA Macros You Can Use Today
Juan Pablo González and Cindy Meister and Suat Ozgur and Bill Dilworth and Anne Troy and T J Brandt
For any Microsoft Office user familiar with Word, Excel, PowerPoint, Access, or Outlook, this book provides tutorials on the tools and tricks that automate these programs for increased productivity. Each lesson includes instructions and a downloadable file on which to test the VBA macros and procedures provided. Tasks covered include how to run several mail merges at once, removing duplicates from data, and saving email attachments.
VBA for Dummies
John Paul Mueller
VBA helps you put your computer in its place Write programs that automate tasks and make Office 2007 work better for you If your computer is becoming your boss instead of your servant, start using VBA to tell it what to do! Here's the latest on the VBA IDE and program containers, debugging and controlling your programs, working with multiple applications using a single program, and the most exciting stuff -- programming for all the Office 2007 applications. Discover how to Customize an application's interface Quick-launch a VBA program Store and modify information Use VBA with the Ribbon Understand object-oriented programming Avoid runtime errors