Russell's ebook Library
home

Russell's ebook Library

Formulas and Functions: Microsoft Excel 2010
Paul McFedries
Managers, entrepreneurs, and business professionals of all kinds need better skills for building more powerful Microsoft Excel spreadsheet models. In this book, Paul McFedries cuts through Excel's complexity, thoroughly demystifying the most valuable features for spreadsheet model-builders: formulas, functions, ranges, and data analysis tools. Drawing on his unsurpassed experience simplifying difficult technologies for mainstream users, McFedries walks through using these features to solve a wide variety of real-world problems. You will learn how to: " Create advanced formulas and troubleshoot formula problems " Work with text, logical, information, lookup, date/time, math, and statistical functions " Analyze data with standard tables and PivotTables " Use Excel's powerful business modeling tools " Utilize Regression to track trends and make forecasts " Build loan, investment, and discount formulas, and more Packed with no-nonsense, step-by-step tutorials and practical examples, Formulas and Functions has been thoroughly updated to reflect Excel 2010's many improvements, from Sparklines to the newest version of Solver. McFedries also illuminates important Excel 2007 enhancements that many users haven't yet mastered, including conditional formatting. This book is part of the new MrExcel Library series, edited by Bill Jelen, world-renowned Excel expert and host of the enormously popular Excel help site, MrExcel.com. No-nonsense, step-by-step tutorials and practical examples from a world-renowned expert in demystifying complex technology, Paul McFedries Includes specific techniques for analyzing complex data, modeling business problems, tracking trends, making forecasts, and building financial formulas Part of the brand-new MrExcel's Library series, edited by Excel legend Bill JelenAbout the AuthorPaul McFedries, president of Logophilia Limited, is a full-time technical writer, passionate computer tinkerer, and Windows expert. He has authored 60+ computer books that have sold 3,000,000+ copies.Editor:Bill Jelen has made more than 75 guest appearances on TechTV with Leo Laporte and was voted guest of the year on the Computer America radio show. He has produced more than 600 episodes of his daily video Learn Excel podcast. Before founding MrExcel.com in 1998, Jelen spent 12 years “in the trenches” as a financial analyst for the accounting, finance, marketing, and operations departments of a publicly held company. Since then, his company has automated Excel reports for hundreds of clients around the world. The website answers more than 30,000 questions a year–for free–for readers all over the world.
Pivot Table Data Crunching: Microsoft Excel 2010
Bill Jelen and Michael Alexander
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. Not any more! In this book, Excel legends Bill Jelen ("MrExcel") and Michael Alexander teach PivotTables and PivotCharts step-by-step, using realistic business scenarios that any Excel user can intuitively understand. Jelen and Alexander go far beyond merely explaining PivotTables and PivotCharts: they present practical "recipes" for solving a wide range of business problems. Drawing on more than 30 combined years of Excel experience, they provide tips and tricks you won't find anywhere else, and show exactly how to sidestep common mistakes. Coverage includes: " Creating PivotTables, customizing them, and changing the way you view them " Performing calculations within PivotTables " Using PivotCharts and other visualizations " Analyzing multiple data sources with PivotTables " Sharing PivotTables with others " Working with and analyzing OLAP data " Making the most of Excel 2010's powerful new PowerPivot feature " Using Excel 2010's Slicer to dynamically filter PivotTables " Enhancing PivotTables with macros and VBA code This book is part of the new MrExcel Library series, edited by Bill Jelen, world-renowned Excel expert and host of the enormously popular Excel help site, MrExcel.com. Teaches PivotTables, PivotCharts, and Excel 2010's new PowerPivot feature through real-world scenarios that make intuitive sense to users at all levels Includes proven PivotTable recipes for instant on-the-job results Helps Excel users avoid common pitfalls and mistakes Part of the brand-new MrExcel Library series, edited by Excel legend Bill JelenAbout the AuthorBill Jelen, known worldwide as MrExcel, presents live Excel seminars to accountants throughout the U.S. His 20 books on Microsoft Excel include Special Edition Using Excel 2007, Pivot Table Data Crunching, and VBA and Macros for Microsoft Excel. Honored as a Microsoft MVP for Excel, he has produced 500 episodes of his "Learn Excel from MrExcel" video podcast. Michael Alexander, is a Microsoft Certified Application Developer (MCAD), Senior Program Manager for a top Texas technology firm, and principal of DataPigTechnologies, a developer of Excel tutorials. He is author of several books on data analysis with Access and Excel.
VBA and Macros: Microsoft Excel 2010
Bill Jelen and Tracy Syrstad
Using Microsoft Excel 2010 VBA scripting features, Excel users can save dozens - or even hundreds - of hours per year. But most Excel users have never written a VBA script: many haven't even used Excel's built-in Macro Recorder. VBA and Macros is the solution. One simple step at a time, two leading Excel VBA scripting experts teach all the techniques needed to automate virtually any Excel task and customize virtually any Excel report or business solution. Bill Jelen ("MrExcel") and top Excel VBA consultant Tracy Syrstad begin with the absolute basics, including ranges, user-defined functions, looping, flow control, R1C1-style formulas, and event programming. Next, they cover all this, and much more: " Automating Excel 2010's brand-new features " Writing Excel 2010 code that works with older versions of Excel " Creating charts, PivotTables, and other data visualizations " Mining data with Excel's Advanced Filter " Reading from and writing to the Web " Using XML from within Excel " Using Microsoft Access as a back end to enhance multi-user access to data " Handling errors " Customizing the Excel 2010 Ribbon to run macros This book is part of the new MrExcel Library series, edited by Bill Jelen, world-renowned Excel expert and host of the enormously popular Excel help site, MrExcel.com. The fastest, best way to go beyond the Macro Recorder and move up the Excel VBA learning curve Shows how to automate powerful new Excel 2010 features such as Sparklines Includes crucial information on making Excel 2010 VBA code work with older versions Co-authored by Excel legend and Microsoft MVP Bill Jelen ("MrExcel") as part of his new MrExcel's Library series From the Back CoverUsing Microsoft Excel 2010 VBA scripting features, Excel users can save dozens - or even hundreds - of hours per year. But most Excel users have never written a VBA script: many haven't even used Excel's built-in Macro Recorder. VBA and Macros is the solution. One simple step at a time, two leading Excel VBA scripting experts teach all the techniques needed to automate virtually any Excel task and customize virtually any Excel report or business solution. Bill Jelen ("MrExcel") and top Excel VBA consultant Tracy Syrstad begin with the absolute basics, including ranges, user-defined functions, looping, flow control, R1C1-style formulas, and event programming. Next, they cover all this, and much more: " Automating Excel 2010's brand-new features " Writing Excel 2010 code that works with older versions of Excel " Creating charts, PivotTables, and other data visualizations " Mining data with Excel's Advanced Filter " Reading from and writing to the Web " Using XML from within Excel " Using Microsoft Access as a back end to enhance multi-user access to data " Handling errors " Customizing the Excel 2010 Ribbon to run macros This book is part of the new MrExcel Library series, edited by Bill Jelen, world-renowned Excel expert and host of the enormously popular Excel help site, MrExcel.com. The fastest, best way to go beyond the Macro Recorder and move up the Excel VBA learning curve Shows how to automate powerful new Excel 2010 features such as Sparklines Includes crucial information on making Excel 2010 VBA code work with older versions Co-authored by Excel legend and Microsoft MVP Bill Jelen ("MrExcel") as part of his new MrExcel's Library series About the AuthorBill Jelen, known worldwide as MrExcel, presents live Excel seminars to accountants throughout the U.S. His 20 books on Microsoft Excel include Special Edition Using Excel 2007, Pivot Table Data Crunching, and VBA and Macros for Microsoft Excel. Honored by Microsoft as an Excel MVP, he has produced 500 episodes of the "Learn Excel from MrExcel" video podcast. Tracy Syrstad, a Mr.Excel.com consultant, has developed VBA solutions for clients around the world. She co-authored VBA and Macros for Microsoft Office Excel 2007 and co-edited Holy Macro! It's 600 Excel VBA Examples.