Microsoft Excel 2013 - 9780735669130

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 more effective with the Power View tool
• Tame complex optimization problems with Excel Solver
• Run Monte Carlo simulations on stock prices and bidding models
• Apply important modeling tools such as the Inquire add-in

Informazioni bibliografiche

• Titolo del Libro in lingua: Microsoft Excel 2013
• Sottotitolo: Data Analysis and Business Modeling
• Lingua: English
• Autore:  Winston Wayne L.
• Editore: Microsoft Pr
• Collana: Microsoft Pr (Paperback)
• Data di Pubblicazione: 15 Gennaio '14
• Genere: COMPUTERS
• Pagine: 859
• Dimensioni mm: 228 x 187 x 0
• ISBN-10: 0735669139
• EAN-13: 9780735669130