Excel 2007 Data Analysis

Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 110 Excel data analysis techniques, including:* Identifying trends in your data*Sorting, filtering, and identifying lists*Creating, editing, and checking formulas*Calculating interest rates and depreciation*Performing simple sorts and filters*Hiding rows or columns in a PivotTable*Adding and removing chart data*Querying an Access database*Assigning digital signatures*Solving a formula with a data table"I was stuck on an Excel problem for two days. Finally, I opened one of your books, and there was a macro to accomplish exactly what I needed! You made me look goo...

Master the analysis and business modeling techniques that help you transform your data into bottom-line results. Award-winning business professor and corporate consultant Wayne Winston shares the best of his real-world experience in this practical guidenow updated for Excel 2007. Use Wayne's proven practices and hands-on exercises to help you work smarter, make better decisions, and gain the competitive edge.Solve real-world business problems with Excel 2007! Maximize profitsdetermine NPV, optimize your product mix, calculate ROI Create best, worst, and most-likely case scenarios for sales Analyze investment performance and help minimize risk Track your personal finances, calculate loan terms, and plan for retirement Use trend and seasonality to fore...

Master business modeling and analysis techniques with Microsoft Excel 2013, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables-and how to effectively build a relational data source inside an Excel workbook. Solve real business problems with Excel-and sharpen your edge Summarize data with PivotTables and Descriptive Statistics Explore new trends in predictive and prescriptive analytics Use Excel Trend Curves, multiple regression, and exponential smoothing Master advanced Excel functions such as OFFSET and INDIRECT Delve into key financial, statistical, and time functions Make your charts ...