Create dynamic dashboards and put your data on display with For Excel Dashboards & Reports For Dummies, 2nd Edition is the business analysis tool you need to transform your raw data into a powerful and effective presentation that is accessible to everyone.
Harness the power of Excel to discover what your numbers are hiding Excel Data Analysis For Dummies, 2nd Edition is the ultimate guide to getting the most out of your data. Veteran Dummies author Stephen L. Nelson guides you through the basic and not-so-basic features of Excel t…
Explains how to get the most out of Excel 2013's formulas, covering such topics as worksheet functions, named cells and ranges, array formulas, megaformulas, debugging, and creating custom functions with VBA.
Maximize the power of Excel 2013 formulas with this must-have Excel reference John Walkenbach, known as ""Mr. Spreadsheet, "" is a master at deciphering complex technical topics and Excel formulas are no exception. This fully updated book delivers more than 800 pages of Excel 20…
Explains the use of Excel 2013's charting and graphing tools. Discusses the Excel 2013 charting engine, the use of Sparklines, and the Data Visualization and SmartArt business diagramming tools. Includes the use of Excel VBA to create charts.
Using Power Query, you can import, reshape, and cleanse any data from a simple interface, so you can mine that data for all of its hidden insights. Power Query is embedded in Excel, Power BI, and other Microsoft products, and leading Power Query expert Gil Raviv will help you ma…