1. Getting Started with Excel. 2. Formatting Workbook Text and Data. 3. Performing Calculations with Formulas and Functions. 4. Analyzing and Charting Financial Data. 5. Generating Reports from Multiple Worksheets and Workbooks. 6. Managing Data with Data Tools. 7. Summarizing Data with PivotTables. 8. Performing What-If Analyses. 9. Exploring Financial Tools and Functions. 10. Analyzing Data with Business Intelligence Tools. 11. Exploring PivotTable Design. 12. Developing an Excel Application. Excel Appendix A: Customizing Your Workspace Text and Graphics. (Digital Only). Excel Appendix B: Introducing Power BI (Digital Only). Excel Appendix C: Collaborating with Your Team. (Digital Only). Index.
Mr. Patrick Carey received his M.S. in biostatistics from the University of Wisconsin where he worked as a researcher designing and analyzing clinical studies. He co-authored his first textbook on using Excel as a statistical tool. Today, Mr. Carey has authored or co-authored more than 20 leading academic and trade texts for the software industry.