About the BookPacked 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.For Sale in Indian subcontinent onlyFeaturesNo-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 JelenContentsPart I. Mastering Excel Ranges and FormulasGetting the Most Out of RangesUsing Range NamesBuilding Basic FormulasCreating Advanced FormulasTroubleshooting FormulasPart II. Harnessing the Power of FunctionsUsing FunctionsWorking with Text FunctionsWorking with Logical and Information FunctionsWorking with Lookup FunctionsWorking with Date and Time FunctionsWorking with Math FunctionsWorking with Statistical FunctionsPart III. Building Business ModelsAnalyzing Data with TablesAnalyzing Data with PivotTablesUsing Excel's Business Modeling ToolsUsing Regression to Track Trends and Make ForecastsSolving Complex Problems with SolverPart IV. Building Financial FormulasBuilding Loan FormulasBuilding Investment FormulasBuilding Discount Formulas