Excel Data Analysis: Your Visual Blueprint for Analyzing Data, Charts and Pivot-tables

Though many consumers know the basics of using excel, they may not know the full power of the program. With excel, you can harness the power of your data, manipulate it to suite your needs and achieve more by doing less work. Charts are interactive, allowing the consumer to tweak results with the click of a mouse. Pivot tables allow you to fuse data from several sources into one document excel has an enhanced find function, allowing users to easily search entire workbooks and search worksheets by cell format. Table of contents: building formulas for data analysis troubleshooting formulas enhancing formulas with functions analyzing financial data analyzing statistical data building tables for data analysis sorting and filtering data learning data analysis techniques working with data analysis tools tracking trends and making forecasts working with the analysis tool pak analyzing data with pivottables visualizing data with charts importing data into excel querying data sources learning vba for data analysis appendix a: using excel keyboard shortcuts index