Formulas and Functions

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. http://www.dropshippers.co.za/

• 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 Jelen
http://www.dropshippers.co.za/

About the Author

Paul 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. His recent titles include Microsoft Windows 7 Unleashed, Microsoft Home Server Unleashed, Tweak It and Freak It: A Killer Guide to Making Windows Run Your Way, Formulas and Functions with Microsoft Excel 2007; andTricks of the Microsoft Office 2007 Gurus. He is also proprietor of Word Spy (www.wordspy.com) a website that tracks new words and phrases as they enter the English language. http://www.dropshippers.co.za/

Editor: http://www.dropshippers.co.za/

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. http://www.dropshippers.co.za/

Table of Contents

• Mastering Excel Ranges and Formulas
• Getting the Most Out of Ranges
• Using Range Names
• Building Basic Formulas
• Creating Advanced Formulas
• Troubleshooting Formulas
• Part II. Harnessing the Power of Functions
• Using Functions
• Working with Text Functions
• Working with Logical and Information Functions
• Working with Lookup Functions
• Working with Date and Time Functions
• Working with Math Functions
• Working with Statistical Functions
• Part III. Building Business Models
• Analyzing Data with Tables
• Analyzing Data with PivotTables
• Using Excel's Business Modeling Tools
• Using Regression to Track Trends and Make Forecasts
• Solving Complex Problems with Solver
• Part IV. Building Financial Formulas
• Building Loan Formulas
• Building Investment Formulas
• Building Discount Formulas
http://www.dropshippers.co.za/